In a new SSRS 2008 report, I want to be able to allow the user to select which report they would like to see generated by selecting the report name from a dropdown list. This is a multi-valued parameter and the parameter name is called 'report'. I
would like the default value to be for all 5 reports to be selected.
All 5 reports will be on the 'main' report. There will be no subreports. Each report will have its own unique matrix and the matrix will be visibile based upon what is selected in the parameter called 'report'.
My question is how can I make the 'default' value for the parameter called 'report' have all the reports selected?
Normally to get all multivalued parameter values selected you create a dataset and run a query against a table. However in this case, there is no table to query. The user just selects what report(s) they want executed.
Thus how can I set the default value to select all the parameter values selected?
After testing the issue in my environment, we can refer to the steps below to achieve your requirement.
Right-click the multiple parameter ‘repot’ to open the Properties dialog box.
Specify the values below in the Available values:
Specify the values below as the Default Values:
report1 report2 report3 report4 report5
Right-click the ‘report1’ to open the Tablix Properties dialog box.
Select Visibility in the left pane, type the expression below in the “Show or hide based on an expression” textbox:
Use the expressions below to control the visibility of the ‘report2’, ‘report3’, ‘report4’, ’report5’:
If there are any other questions, please feel free to ask.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.