A manager requests a report that contains the following columns: Create Date, Case ID, Create Operator, and Work Status. You must sort the cases so…

The requirement is to sort cases so the most recent 'Create Date' appears at the top. This is a descending sort order. In a Pega report definition, sorting a date or numeric column from "Highest to Lowest" arranges the records in descending order. The highest date value is the most recent date, fulfilling the manager's request to see the newest cases first.

B. Making the Create Date the first column only changes its display position in the report grid; it does not control the sort order of the records.

C. Selecting "Lowest to Highest" would sort the cases in ascending order, placing the oldest cases at the top, which is the opposite of the requirement.

D. This is a filter condition, not a sorting option. It would incorrectly attempt to show only cases created in the future, resulting in an empty report.

1. Pega Academy: Business Architect Mission

Module: Reporting

Topic: Creating a report. This module explains that to sort data

you use the sorting options in the report definition's Query tab

and a descending sort (Highest to Lowest) is used to show the most recent items first.

2. Pega Platform Documentation: Creating a report definition

Section: Report Definition Query tab. The documentation specifies that the "Sort" section on the Query tab is used to define the record order. For date properties

selecting "Highest to Lowest" as the "Sort Type" configures a descending sort.