Sorting Data

To make reports more effective, you can sort by one or more database columns. You can sort columns in ascending or descending order.

*  To set the sort order of columns:

  1. Click Order By on the Query Builder - Fields page.

    The Order By dialog box is displayed.

  2. Select a column under Available Columns and add it to the sort order under Order Columns.

    • Click the desired column and click Add.

    • Double-click the column.

      To remove a column from the sort order, click the column and click Remove, or double-click the column.

  3. To change the column order, click a column and click Move Up or Move Down.

    The order in which you add the columns is important, since the column order designates the sort priority.

  4. Click Toggle Sort to specify whether to sort the columns in ascending or descending order.

    IconDescription

    Ascending button

    The icon with the arrow pointing up indicates that the columns will sort in ascending order.

    Descending button

    The icon with the arrow pointing down indicates that the columns will sort in descending order.

Note:

If you define group breaks, it is a good idea to apply a sorting order to your database columns. SQR Production Reporting Studio automatically generates the sort order if you have automatic group break synchronization enabled (you selected Create sort order fields from break fields in the Group Breaks dialog box). With group break synchronization, SQR Production Reporting Studio selects sort order fields based on the current group breaks. Adding or removing sort order fields at this point, disables group break synchronization.