Post reply

Sort Desc

  • August 31, 2006 at 12:06 pm

    #116494

    Good Morning everyone...

    I have a matrix table built on Reporting Services and within this matrix table, I have month as the row and country as the column.  I want to sort the country asc but the month desc... How would I do that?

    Please help!

    Thanks!

  • August 31, 2006 at 12:13 pm

    #657893

    Just taking a guess here... almost assuming that I'm wrong .

     

    Select... order by Country ASC, MonthDate DESC

  • September 1, 2006 at 6:31 am

    #658002

    Good Morning Somebody...

    Right click on the row cell and click on edit group. Click on the 'Sorting' tab and select the field name from the dataset and the order (ascending is the default). Repeat for the column cell for the country.

    The only thing to watch out for on the month sort is what data type you are sorting by (i.e. varchar for the name or integer for the number of the month or date/time).

    HTH.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply