I am working on a SSRS report which is using a select query and have a parameter clientorderno of integer type to get multiple orders. The order it returns is always the order that is returned in the database (no order can be seen on the select query as
the results are always jumbled without any order).
I want the returned data to be displayed to the user in the order they have entered the values for filtering. It might be like this
3
2
4
1
So it should display the records in the same order.
Participant
1359 Points
744 Posts
Return records in the order it is queried + Sql Select + SSRS
Dec 20, 2012 07:05 AM|swapna.anu|LINK
Hi
I am working on a SSRS report which is using a select query and have a parameter clientorderno of integer type to get multiple orders. The order it returns is always the order that is returned in the database (no order can be seen on the select query as the results are always jumbled without any order).
I want the returned data to be displayed to the user in the order they have entered the values for filtering. It might be like this
3
2
4
1
So it should display the records in the same order.
Can any one help me on this please.
Thanks in advance.