Thursday, July 26, 2012

Month Sorting Issue in SQL Server Reporting Services (SSRS)

This error appeared when I designed a query in the Query Builder to generate the report in SSRS (MDX). Months are showing in alphabetical order (April , August,..) instead of chronologically.

I did some background work and even followed this thread but ultimately I found there is a default sorting to that column.

I Deleted it ..

Bingo .. It worked .. 

image

No comments:

Post a Comment