Customizing the filtering and sorting for standard reports

Article:HOWTO82006  |  Created: 2012-11-05  |  Updated: 2013-04-18  |  Article URL
Article Type
How To


Customizing the filtering and sorting for standard reports

You can specify the grouping, sorting, and paging options for a report.

For information about optimizing your reports to improve the performance of the Process Manager:

See Optimizing reports in the Process Manager portal.

To customize the filtering and sorting for a report

  1. In the ServiceDesk portal, select Reports.

  2. On the Reports page, do one of the following:

  3. In the Add/Edit Standard Report dialog box, select the Report Designer tab.

    See Add/Edit Standard Report dialog box.

  4. (Optional) In the Report Designer tab, select Options.

  5. Select the Limit Rows check box to limit the number of rows that are returned with the report. The default number of rows that are returned is 50. When you select this option, the user is able to configure the number of rows that are returned at run time.

  6. Select the Use Paging check box, and specify the number of rows per page for the report.

  7. Select a column in the Sort By drop-down list to sort the report by that column, and select ascending or descending sort order.

  8. Select up to three columns to group the report by in the Group By drop-down lists.

  9. To add aggregations to your groups, under Group Aggregations, select a column to aggregate a group by and the type of aggregation, and then click Add Aggregation. Aggregations summarize mathematical data at the group level. For example, you can set up an aggregation that displays the average age of a ticket per location.

  10. Click Display SQL to display the SQL statement that the report executes against the database.

  11. Click Save.

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices