Hello,
I am trying to sort the months (which appear in the column) of a matrix table in a paginated report. However, It does not seem to be working.
As you can see in the image below, my months are not in order.
Any ideas or suggestions would be highly appreciated.
What logic did you use for the month sort number expression?
You might need to explicitly declare the month sort number as a number.
From the Microsoft documentation, it seems to state that if you apply the sort order in your original query then this should apply through to your report.
Let me know how this goes.
I just tried it and it worked. I didn’t know there was a sorting option there. Thank you.
Great, glad to hear it’s sorted.
Paginated Reports, has so many options, they’re hidden all over the place, not always obvious.
Have you ever checked out the PRIAD training? Some useful stuff in there.
