Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

On saving report definition rule, sort type and order populates



On saving a report definition rule, sort order and sort type is pre-populated.

Error Messages

Not Applicable

Steps to Reproduce

1. Create a report definition with count distinct as Summarize then provide additional columns
2. Save the report definition rule

Root Cause

A software use or operation error. In Pega 7, inside report definition, sort order is populated automatically on the group by columns to increase the performance of aggregate calculations.


Perform the following local-change:

There are two ways this use case can be addressed:

  • In Pega 7, inside report definition > report viewer tab, if “Do not display group headings” checkbox is checked, Pega does not mandate any sort sequence and sorting can be performed on aggregates as required. Therefore, check the “Do not display group headings” checkbox to override the sort sequence enforced by Pega. When this is selected, the user can sort the report in any way desired.

  • On the summary report definition, move columns that do not require sort order to be applied by Pega to the drill-down report. If the drill-down report is type list, default sorting behavior does not occur.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us