Hi All, I want to create a report based on user selection. Basically it is a stored procedure that dynamically creates query and allows user to search data based on some parameters and then they can sort the data based on selection from group of database columns. Now I can sort the data by creating some sudo parameter and adding name of those columns based on which I want to sort the results. But What I can do to sort the result based on multiple selection ?? I mean, how do I make possible for user to select more than one sort option from my list ?? I can do some in my ASP.NET app. (using checkboxes) but what I don't get how can I do same in SSRS ? Any help is really appreciated ... Thanks, -Jack

Hi Jack, Do you mean you need to allow users to select multiple values in a parameter? If so, we can use a multi-value parameter in the report. To set the multi-value property for a parameter, please select the Allow multiple values option on the Report Parameter Properties dialog box. Then you can also specify available values to this parameter. After that, you can call the procedure in the dataset query by using an expression to combine the values of the parameter. For example, if we have a multi-value parameter which name is Parameter1, then we need to specify the data query to the expression like ="EXEC ProcedureName "+Join(Parameters!Parameter1.Value,",") If this cannot meet your needs, please point out and post an example to elaborate. Then I will provide you further assistance. For more information about using Multi-value Parameters, please refer to the link below: http://msdn.microsoft.com/en-us/library/aa337292(SQL.100).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help