Sorting problem in SQL reporting services

• Seema Gupta-289143

  SSC Veteran

  Points: 296

  More actions

  March 1, 2006 at 5:32 pm

  #365445

  I have order by in my stored procedure for report and the stored procedure works in the report data tab, execute command.

  But when I preivew the report the order by changes. I am ordering by one column only and thats a integer. How should I deal with it.

  Seema

• Jon Spink

  SSCarpal Tunnel

  Points: 4010

  More actions

  March 3, 2006 at 3:16 am

  #624553

  Try setting the sort order using the Sorting tab under the data region properties. If you have any groups they can each have their own sort orders.