Workday-Pro-HCM-Reporting Exam - Topic 1 Question 12 Discussion

In Workday composite reports, sorting behavior is controlled at the column level, not globally. Each column in a composite report can be configured with its own sort order (ascending or descending). When a composite report is sorting by the last column, it means that column has an active sort configuration applied.

To change the sort to the second to last column and set it to descending, you must edit that specific column's configuration and adjust the sort settings accordingly. Workday evaluates column sorting in sequence, and the active column-level sort determines the output order.

From the Workday HCM Reporting documentation:

''Composite reports support column-based sorting. Sorting is defined within the column configuration and determines the order in which results display.''

''To change sort behavior, update the sort settings on the appropriate column.''

The other options are incorrect because dynamic data rows control layout flexibility, combine data rows merge subreport results, and report settings manage prompts and general options---not sorting logic.