Tuesday, April 10, 2012

Month Sorting Issue in SQL Server Reporting Services (SSRS)

This error Occurred to me while I design the query in the Query Builder and generate the report in SSRS ( MDX). Months are showing alphabetical order (April , August,..) , but it should be January , February ..

I did some background works and even follows the the thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/27765eda-371d-4428-ab13-2e96b2fbb6ca.

But ultimately I  found there is a sorting adding by default to that column. I Deleted it ..

Bingo .. It worked .. 

image

3 comments:

Albert Chang said...

Your place is valuable for me. Thanks!…

Anonymous said...

Good and Short!...Thanks!

melick baranasooriya said...

@Anonymous!

Thanks!