Grouping and Sorting Report Results
  • Updated on 11 Oct 2013
  • 1 minute to read
  • Print
  • Dark
    Light

Grouping and Sorting Report Results

  • Print
  • Dark
    Light

Report Results can be sorted and grouped by column value.
To group report results in the Report Designer , select the header of the column to be grouped, click the icon that appears, and select Group .  At runtime use the icons on the column header to change the report grouping.
Sort report results at runtime by clicking the column header.
Example
The goal of this example is to:

  1. Create a report.

  2. Group the information based on a specific column.

  3. View the results.

Begin by navigating to a Designer Folder .  Click on the Create Report button and select Create Report from the resulting menu.
2017-12-29_160519.png

In the resulting New Report popup window give the report a name and click OK .
2017-12-29_160552.png

Define a data source for the report by selecting Folder Data Source from the Data Sources > Common .
2017-12-29_160646.png

Next, expand the Folder Data Sources category and select Entity Name , Folder Type Name , and Nesting Level into the workspace.
2017-12-29_160735.png

Next, group the results by Nesting Level .  Select the Nesting Level column and in its Action menu select Group .
2017-12-29_160847.png

The report entries will be grouped according to the value that appears in their Nesting Level cell. 
This completes the report.  Save it and close the Report Designer .
2017-12-29_160918.png

Back in the portal, select the desired report and in its Action menu, select Run Report .
2017-12-29_160956.png

The report will open in a new window.  The user can hover over each column’s header and sort the results in ascending or descending order according to the column’s values.
2017-12-29_161050.png

Was this article helpful?