Sort month which is in the groupby
RoyalM, In your scenario you can sort with Year & then Month. For sorting on month as per your expression please find updated expression =Month(CDATE("01-" + Fields!MNTH.Value + "-2012")) Thanks, Sandip Shinde Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
January 30th, 2012 1:53pm

Hi From the End to End design point of view, It is recommended to sort the DATE fields at SSAS design (if your using cube as source to report), sort the attribute on Name by working on Key at SSAS design. In case your report bases on Database, please go with Month Number for expression implementation while displaying month Name. Prav
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2012 8:04am

I am unable to sort the month with using =CDATE("01-" + Fields!MNTH.Value + "-2012") how to sort the aboue months which is in the groupby.
February 5th, 2012 5:00am

Hi, if you get this data by MDX query, you can do this in sort tab of your matrix group type [date].[month canlendar].[month].[key] or something like this. I mean know it sort in alphabet order and you have key for each month in your date dimension, so display month name and sort by using month key. I hope this is helpful. Elmozamil Elamir MyBlogPlease Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid http://elmozamil.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2012 5:11am

RoyalM, In your scenario you can sort with Year & then Month. For sorting on month as per your expression please find updated expression =Month(CDATE("01-" + Fields!MNTH.Value + "-2012")) Thanks, Sandip Shinde Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
February 5th, 2012 6:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics