0

Sort Table [RESOLVED]

Jet Reports Historic Posts

October 03, 2011 13:31

None

Follow

is it possible to automaticly sort a table on for example a Date field when the table is renewed?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts October 03, 2011 14:08

  It sure is. If you are using the Table Builder, it does require that you modify the function that was created by the Table Builder.
  
  For example, here is a basic function that shows a table with some data from the Customer table (in my case D4 and E4 are set to the No. and Name fields):
  
  =NL("Table","18 Customer",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","18 Customer")
  
  You can modify the function (either directly in the cell or through the use of the Jfx button) to tell it to always sort by the Name field like so:
  
  =NL("Table","18 Customer",$D$4:$E$4,"Headers=",$D$3:$E$3,"TableName=","18 Customer","+Name","*")
  
  -HP

• 0
  
  Jet Reports Historic Posts October 04, 2011 07:23

  Thanks that works great!!