topic Re: Pages and Levels - Sorting in Reporting Service & Alerting

Pages and Levels - Sorting

ShaneMichelon1 — Fri, 15 Nov 2024 21:04:31 GMT

Hi! I have a requirement to generate a report with Excel sheets for a set of months. This works fine but how do I show the most recent month as the first worksheet?

Re: Pages and Levels - Sorting

JonnyPoole — Wed, 06 Mar 2024 05:39:53 GMT

I added a "negative" month number to the data model and 'paged' on the month number to make the highest month number value (and most recent) month appear first.

I noticed you can't use the <Month> table tag (otherwise it repeats of course) so I created a new expression to place at the top of each page to display the month

When running the template in PDF mode, the pages come in ascending order based on the negative month number which means highest (most recent) month first

Please note this older post provided the solution which is still valid in Tabular Reports https://community.qlik.com/t5/Qlik-NPrinting/How-to-sort-the-way-Pages-appears/td-p/1269550

Re: Pages and Levels - Sorting

ShaneMichelon1 — Tue, 19 Mar 2024 02:05:50 GMT

Thanks and sorry for the delay in replying. I didn't realize someone had replied. The only issue with that technique is that the sheet names will be numeric instead of the text I want (ie I want to see Jan 23, Feb 23, Mar 23, etc).