Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scamper
Yak Posting Veteran
52 Posts |
 Posted - 2014-06-18 : 17:02:05
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-06-21 : 05:41:41
|
| Make parameter as multi values (Allow mutiple values property selected)Create a dataset to return all 5 report namesgo to default values tab and map default value to reportname field of the datasetand you'll have all report names selected when report loads and it will show you all the matrices.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
ssrs default Multi-value parameter select all