September 29, 2010 at 6:30 am
Dear All !
in SSRS 2008 im grouping columns by Year value followed by Month value.
In place of Month im displaying the name of month, which is done in query using DateName(Month,Date_Doc)
When previewing the report, all works fine xcept for the Month Name columns. the Months are getting displayed in alphabetical order like April, Feb, Jan, March ... n so on.
Is there a way to sort it as like the order of month num??
please let me know ..
Thanks a lot !!
September 29, 2010 at 8:31 am
Go into the row group properties on the sort tab, and enter a formula for the month number as the value to sort on.
September 29, 2010 at 8:43 am
You can also add the month number of the year to the query and then sort by it in RS without having to show it anywhere in the report.
September 30, 2010 at 12:16 am
Daniel Bowlin (9/29/2010)
Go into the row group properties on the sort tab, and enter a formula for the month number as the value to sort on.
Hey Thanks yaar !!! it helped ...
hi Duog Lane !! i thought not to alter the query again..Any ways Thanks for ur reply !!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply