How to Sort Reports

Top  Previous  Next

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.