If the list of Page Properties Report macro spans across multiple pages, then sorting by a column only sorts the data of the visible page only. It does not sort all data across all pages.

Below are the example of what is happening currently:

• Scenario 1: This shows the 1st tab ordered by (asc) the 'Request For' column. Screenshot Tab 1 - Order 1.jpg
• Scenario 2: This shows the 1st tab ordered by (desc) the 'Request For' column. Screenshot Tab 1 - Order 2.jpg
• Scenario 3: This shows the 5th tab ordered by (asc) the 'Request For' column. Screenshot Tab 5 - Order 1.jpg
• Scenario 4: This shows the 5th tab ordered by (desc) the 'Request For' column. Screenshot Tab 5 - Order 2.jpg

The screenshots that describe the issue are attached.

It is desirable that the sorting should be applied across all pages of the report.

Please investigate the reason why the sorting of page properties report macro does not sort across all pages. Is there some way to make an improvement with the sorting?

Thank you and regards,
Lazuardi