locked
Order by not working in SSRS report RRS feed

  • Question

  • Hi All,

    I have created a report that sharing  two datasets  for displaying the data. This datasets are using Stored procedure for execution of the report.

    One of the stored procedure using Order by clause and returning the data.

     

    But on running the report , the report viewer displays the unsorted data of the filed. But if we run the stored procedure directly from the sql server , it will return the sorted data.

     

    Could you please help me to resolve the issue?

     

    Thanks in advance

     

    -John 


    JOHN
    Thursday, November 4, 2010 2:52 PM

Answers

  • Hi John,

    If your report has groupings, then you have to go each group properties and check sorting. You can delete sorting options there. Then the sorting provided by the datasource will be intact.

     


    Thanks. Igor -Remember to mark as an answer if this post has helped you.
    • Marked as answer by JOHN_Eapen Thursday, November 4, 2010 3:42 PM
    Thursday, November 4, 2010 3:33 PM
  • Hi John,

    I ran into this same problem, SSRS basically ignores the ORDER BY Clause in a query or stored procedure. You need to right click on the Tablix and go to properties, there is a sorting section that you use to order your tables/matrices by.

     

    -Brian

    • Marked as answer by JOHN_Eapen Thursday, November 4, 2010 3:30 PM
    Thursday, November 4, 2010 3:00 PM

All replies

  • Hi John,

    I ran into this same problem, SSRS basically ignores the ORDER BY Clause in a query or stored procedure. You need to right click on the Tablix and go to properties, there is a sorting section that you use to order your tables/matrices by.

     

    -Brian

    • Marked as answer by JOHN_Eapen Thursday, November 4, 2010 3:30 PM
    Thursday, November 4, 2010 3:00 PM
  • Hi,

    Thank you for your quick replay .

    What is this Tablix( is it texbox inside a matrix) ..

    Are you telling about interactive sorting .

     

    Thanks & Regards,


    JOHN
    Thursday, November 4, 2010 3:16 PM
  • Hi Brain,

     

    Tablix = table +matrx

    Thank you its working now ...

     

    Thanks 

    John


    JOHN
    Thursday, November 4, 2010 3:31 PM
  • Hi John,

    If your report has groupings, then you have to go each group properties and check sorting. You can delete sorting options there. Then the sorting provided by the datasource will be intact.

     


    Thanks. Igor -Remember to mark as an answer if this post has helped you.
    • Marked as answer by JOHN_Eapen Thursday, November 4, 2010 3:42 PM
    Thursday, November 4, 2010 3:33 PM
  • Hi,

    This is a good information ...

    I will try it , i just added a sorting property for a group there..

     

    Thanks 

    Eapen 


    JOHN
    Thursday, November 4, 2010 3:42 PM
  • Thank you thank you.   You saved me a lot of frustration.


    Moojjoo MCP, MCTS
    MCP Virtual Business Card
    http://moojjoo.blogspot.com

    Wednesday, August 8, 2012 4:08 PM
  • Sorting in Row/Column Group Properties was very non-intuitive to me, this answer saved me a lot of time, thank you!!!
    Wednesday, October 7, 2015 8:13 PM
  • pls tell me where can i find the tablix? thanks in advance.
    Thursday, January 31, 2019 9:11 AM