Answered by:
Order by not working in SSRS report

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
JOHNThursday, 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,
JOHNThursday, November 4, 2010 3:16 PM -
Hi Brain,
Tablix = table +matrx
Thank you its working now ...
Thanks
John
JOHNThursday, 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
JOHNThursday, 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.comWednesday, 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