Last post Jan 02, 2013 04:52 AM by swapna.anu
Dec 20, 2012 07:05 AM|swapna.anu|LINK
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
So it should display the records in the same order.
Can any one help me on this please.
Thanks in advance.
Dec 26, 2012 08:39 PM|augustwind|LINK
I don't quite understand your question......
If you want the records to come back and be displayed in the order they were entered in the database, then you do not use an order by clause in your sql statement.
1. show us what you have for a sql statement?
2. Tell us what is being returned and how it's not what you need to be displayed
Jan 02, 2013 04:52 AM|swapna.anu|LINK
Thanks for the reply.
My requirement is like below
If a user enters values into the report like below
which doesn't have any order then the results should also come in the same above entered order. My database query will be like below
select clientorderno, clientname from tablename where clientorderno in (200,105,86,355,800,345)
But my query doesn't return like this.
Hope I am clear now.