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 

---

JOHN

Answer 1

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

Answer 2

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

Answer 3

Hi Brain,

 

Tablix = table +matrx

Thank you its working now ...

 

Thanks 

John

---

JOHN

Answer 4

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.

Answer 5

Hi,

This is a good information ...

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

 

Thanks 

Eapen 

---

JOHN

Answer 6

Thank you thank you.   You saved me a lot of frustration.

---

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

Answer 7

Sorting in Row/Column Group Properties was very non-intuitive to me, this answer saved me a lot of time, thank you!!!

Answer 8

pls tell me where can i find the tablix? thanks in advance.