| **Navigation:**  [[clarion 7 faqs.htm|How To's and Troubleshooting]] > How to... >====== How to Sort Reports ====== | [[how to set up subversion in the clarion ide.htm|{{btn_prev_n.gif|Previous page}}]][[clarion 7 faqs.htm|{{btn_home_n.gif|Return to chapter overview}}]][[how to start a dde conversation.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

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.