I was developing a SQL Server Reporting Services report from data that was coming from Analysis Services cube. And when I created the report having Month Names, it was not sorting it correctly.
April, August, February, Jan….
But It should have been:
Jan, Feb, Mar…
because I had correct sorting settings in the cube. So what was wrong? Or what can we fix?
Turns out, the solution was pretty simple. Here are the steps:
1) Select the chart.
2) Select the Month Name category group
3) Go to Properties
4) Go to Sorting section
And delete the sorting property that sorts the Month Names by A to Z. seems this overrides over sorting properties that’s in the cube.
5) After deleting the sorting property in SSRS fixs the issue.
Please preview the report to see if the issue has been resolved for you.