Click here to Skip to main content
15,867,990 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

Is there any way to set order of parameter in SSRS Report??
Posted
Comments
AmitGajjar 25-Apr-13 6:14am    
What you mean by order of paramters ?
niralirshah 25-Apr-13 6:20am    
want to set order by id or name in parameter value....
AmitGajjar 25-Apr-13 6:25am    
you mean to say that you want to order your data with id or name depending on parameter value. is it so ?
niralirshah 25-Apr-13 6:29am    
i set parameter values in drop down box and want to those values order by name in drop down box ...
AmitGajjar 25-Apr-13 8:24am    
do you want to get column name in order ? for that you need to write your query such a way that your table columns are in order then it will also display in drop down with order.

In the Report Data pane, expand the Parameters node. Click the parameter and use the up and down arrow buttons on the Report Data pane toolbar to move the parameter higher or lower in the list.

MSDN : How to: Change the Order of a Report Parameter (Reporting Services)[^]
 
Share this answer
 
Hi
As per your information from the comment, below solution may work for you.
you need to pass index of the column in the query to sort your data.
like
SQL
select * from table order by 1

above query will sort your table with order by first column. so from database you need to pass index of the column from the dropdown.

hope this will work for you

Best luck.
 
Share this answer
 
Comments
niralirshah 25-Apr-13 8:02am    
hello... thank you very much for your reply,.... but i am working in ssrs and want to apply sorting in parameter values...i have set that parameter for dropdown box and ascending by name.. please help...
AmitGajjar 25-Apr-13 8:06am    
but in the backend you must be executing query. am i right ?
niralirshah 25-Apr-13 9:36am    
Yes, u r right .. but my datasource is shared datasource and i can't change it..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900