Adding Row and Sort Column Items

The $ROW variable enables you to insert a row number for all the dimension values in a simple tabular report. Before inserting the $ROW values, you must add a blank column to the report. Additionally, you can use the $SORT_COLUMN variable to list the column heading used to sort values up or down in the report. If a report is unsorted, inserting the $SORT_COLUMN variable displays the value unsorted. Using the $SORT_COLUMN variable can be useful in a multi-page report where the column used to sort the report may not be obvious.

The following procedure illustrates how to insert $ROW and $SORT_COLUMN variables into a report:

  1. Open a sales model, for example, sales_90day.mdl.

  2. On the Console, double-click Company.

  3. Click the Report icon to open the Default Report dialog box.

  4. Click OK to display a simple tabular report.

  5. Unlock the report, and then click the Add Column icon.

  6. Use a drag and drop operation to moce ClosedColumn E to the left of Column A.

    ProDiver updates the column labels to reflect the changes in the column positions.

  7. Select Column A, and then click the Add Item icon.

  8. Click $ROW and perform the following actions:

    • On the Breaklevel tab, set the Dimension to Company and the Location to Body.
    • On the Position tab, set the Column to Column A.
    • On the Style tab, set the Style Name to Text.

  9. Click OK Closedto view the report with a row number added for each dimension value.

  10. To add the name of the sort column, lock the report, and select the Cases column heading.

  11. Click the Sort Up icon Closedto sort the summary values in the report from the lowest to the highest. The sorting column is Cases.

  12. Unlock the report, and click the Add Item icon to open the Add Item dialog box.

  13. Click $SORT_COLUMN.

  14. Click OK Closedto view the report.

  15. Click File > Save Marker as inserting_find_actions_metadata to continue using this report in search-related topics.