You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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)
  • No labels