Sorting Rows, Columns, or Pages in Grids

You can sort a range of consecutive data rows or columns in a grid based on the values in a specific column or row. You can also sort columns, rows, and pages based on their headings. If you select a range of columns, Financial Reporting Web Studio sorts the columns based on the values in a specified row. If you select a range of rows, Financial Reporting Web Studio sorts the rows based on the values in a specified column. If the column or row by which you sort contains multiple members, the sort is based only on the values of the first member.

You can sort columns or rows in ascending or descending order. When you sort in ascending order, the lowest number, the beginning of the alphabet, or the earliest date appears first in the sorted list. When you sort in descending order, the highest number, the end of the alphabet, or the latest date appears first in the sorted list.

You can sort only multiple ranges of columns or rows. Suppressed rows or columns are not sorted.

Note:

When sorting on data rows or columns, text rows or columns cannot be included as part of the sort definition.

To sort a range of rows and columns:

1. Open a report and select a grid.

2. In Grid Properties, select Sort, and then click Setup.

3. In the Sort dialog box, under Apply Sorting to the, select Rows, Columns, or Pages.

   For the Pages option, you can only select headings from the Sort by: drop-down menu. All other options are disabled.

4. For Rows or Columns, use From and To to select the range of columns or rows to sort.

   When auto calculations is enabled, the outermost layers contains the grand total of all rows in the calculation. Sorting on the outermost layer is ignored. Also, when you select sort with auto calculation set on multiple layers, you must sort on all heading layers which have auto calculations.

5. In Sort by, select the options by which to sort:

   1. From the first drop-down list, select the headings or row or column on which to base the sort, then select Ascending or Descending for the sort order.

   2. Optional: Use the Then by drop-down lists to set up one or two additional sorts parameters.

6. Optional: Click Add Sort to set up additional sorts:

7. Click OK.