Skip to main content

Table of Contents

Sorting and grouping columns in list reports


Only available versions of this content are shown in the dropdown

Make your report more readable and organized by grouping columns and sorting the column values. For example, you can sort and group the report results to present the cases that the user accessed most recently.

  1. If App Studio is not in Preview mode, in the header, click Preview application.

  2. In the header of App Studio, select the portal in which you manage reports.

  3. In the left navigation pane, open the Report Browser by clicking Reports.

  4. Select the reports that you want to view:

    • To view your custom reports, click the My Reports tab.
    • To view all available reports, click the All reports tab.
  5. In the upper-right corner, click Edit report.

  6. Click Actions Sort .

  7. In the Sort and Group section, manage the report columns:

    Choices Actions
    Sort the column values Next to the column name, in the Sort list, select a sorting method for the column.
    You can apply different sorting methods for each column.
    Group the results
    1. Select the Group results check box.

    2. In the numeric list, select the number of columns to display as the group heading.

    3. Optional:

      To remove the rows that share the same values in all columns, select the Remove duplicate rows check box.

    Limit the number of displayed rows in the report
    1. In the Top/Bottom Rank section, in the Display list, select how you want to display the rows.

      For example, if you want to display the rows with the highest values, select Top Ranked.

    2. Next to the Display list, in the box, enter the maximum number of rows to include in the report.

    3. In the Rows list, select where you want to limit the rows number.

      For example, if you want to limit the overall rows number in the entire report, select Overall.

    4. In the based on field, press the Down arrow key, and then select a property to use.

  8. Click Apply changes.

  • Editing a report

    You can modify a report to change the way the report displays information, or filter the data for different audiences by using the Report Editor.

  • Creating a report

    In addition to using the standard reports, you can create your own reports to meet additional business needs. For example, you can decide which columns to display in your report by using the Report Editor.

Did you find this content helpful?

0% found this useful

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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