Post reply

Order in Report result different from SP results

  • March 31, 2011 at 12:57 am

    #234852

    Greetings.

    I have a report via SP where the order by in the sp works 100% from the management studio, but the report does not order in the same manner. I have added in the columns in the sorting tab of the report table but nothing, report has been deployed but still nothing.

    Logically when you look at the result set, the sp is ordering correctly. Not sure what to do now.

    Please assist.

    Thanks,

    Rivesh

  • March 31, 2011 at 7:30 am

    #1305961

    Look for a sort elsewhere on the report, on the tablix, a group column, etc..

  • April 1, 2011 at 1:02 am

    #1306307

    Hi

    Thanks for that. There was a grouping that I didn't see. Removed it and the report now sorts 100%.

    Thanks,

    Rivesh

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

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