Navigation: How To's and Troubleshooting > How to… >====== How to Sort Reports ====== | |
The sort sequence of a report is determined by a KEY or INDEX defined in the Data Dictionary's Field/Key Definition dialog. Keys or indexes are selected for use in this particular report procedure, using the Data / Tables Pad. When you select a sort key for your report, the key will determine the variables on which you define your group breaks.
For example, if you select the CUS:LastNameKey as your key, then your BREAK variables should be among those fields listed as components of the CUS:LastNameKey. You can see the key's component fields in the Data Dictionary's Field/Key Definitions dialog.
To specify the sort sequence for your report:
1.From the Application Tree dialog, select the report procedure name.
2.Open the Data / Tables Pad (From the IDE Menu, select View > Data / Tables, or press the F12 key).. Use this pad to tell the Application Generator which files and keys your report procedure will access.
3.DOUBLE-CLICK the ToDo item for your procedure.
The Select File dialog appears.
4.Select the file you wish to report from.
You may specify more than one file to report on: a primary file, and secondary files. The secondary files must be related to the primary file by a common field. Adding secondary files to your procedure gives you another logical field to break on: that is, the common field(s) linking the two files.
5.Press the Edit button, to specify which key is used for this report procedure.
The Change Access Key dialog appears.
6.DOUBLE-CLICK the key you want for this report.