Description
Sorts data within a Run_Report report.
Syntax
By COLUMN
- OR -
By-DSND COLUMN
Remarks
By arranges the list or report according to the order of the contents of a column.
To create a list or report sorted in descending (reverse) order, use the keyword By-DSND.
Example
* List Customer by State in State order
.
stmt = 'LIST CUSTOMERS CUSTOMER_NAME STATE BY STATE"
Run_Report("",stmt)
* List Customer by State in State descendig order.
stmt = 'LIST CUSTOMERS CUSTOMER_NAME STATE BY-DSND STATE"
Run_Report("",stmt)