Default value for multi select parameter
Hi I am generating this report which has ten parameters. All parameters are multi value parameter. Now is there any way to set all parameters to "Select All" by default? What I mean is that user dont have to go each an every parameter and click 'Select All' option to view report. Regards
October 18th, 2006 6:24pm
If you are using a query to select the possible values you can use the same query to do a select all. Otherwise, I believe you can specify the value a an array ['value1'],['value2'],...
October 18th, 2006 9:37pm
Hi Lonnie Thanks for your reply. I am using a dataset to select the possible values for parameter. When you use the same dataset for default value it does not select anything. Amit
October 18th, 2006 9:45pm
Are you using RS2005 or RS2000? I know that for RS2005 that works. For RS2000 you have to create an 'All' option, then do some coding in the SQL to get it to work.
October 18th, 2006 11:07pm
I am using RS2005 sp1 hotfix applied (which put back in the <Select All> option that sp1 took out ). I am using queries for my parameter lists. I do not see a way to pick a default of the <Select All> option that RS adds into the list. Under default you specify the dataset and the value field (which is a drop down of the field names - not values).
October 19th, 2006 9:50pm
As Lonnie suggested, you can create an ALL option in your Available Values query, and then set your default to that value. I've detailed the step-by-step in my blog, here. http://dataqueen.unlimitedviz.com/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/ Martina White
November 19th, 2011 10:05am