Post reply

ssrs 2008 matrix column sorting

  • September 16, 2011 at 4:47 am

    #245069

    How is it possible to DISABLE the way ssrs sorts the column headers.

    I want the columns to appear as they are retrieved from the sp.

    Thanks

  • September 16, 2011 at 4:57 am

    #1382465

    Can't say this with 100% certainty, but the only way I've been able to garantee the order of the columns was the create a new "order" column in the dataset from sql server and then force a sort by that.

    In any case I think this is the safest way to garantee to have the correct order. Otherwise you're just asking for trouble (upgrades, code change, anything else you don't know might screw that up, but almost impossible if you specify the order by for the matrix).

  • September 16, 2011 at 5:10 am

    #1382472

    Thanks.

  • September 16, 2011 at 5:14 am

    #1382474

    What are you trying to sort by anyways? I've seen overly complex solution to sort by date or month in the past !

  • September 16, 2011 at 5:19 am

    #1382475

    problem solved by adding a new field and sorting by that new field.

    Thanks

  • September 16, 2011 at 5:30 am

    #1382484

    fmardani-786425 (9/16/2011)

    problem solved by adding a new field and sorting by that new field.

    Thanks

    Thanks for the feedback.

Viewing 6 posts - 1 through 5 (of 5 total)

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