is it possible to automaticly sort a table on for example a Date field when the table is renewed?
2 comments
-
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts Thanks that works great!!