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 |
|
Insider
Starting Member
5 Posts |
 Posted - 2013-12-09 : 01:46:17
|
| Hi All,Using SSRS 2008, I would like to reference a second report via the 'Go to Report' Action Option. This second report however contains a drop-down parameter of multiple listings, including a box at the very top that can be checked to '(Select All)'. I would like to know how to write an expression such that the parameter in question indeed 'Selects All' from the drop down. I have tried typing 'All', 'Select All', '(Select All)' etc in the expression window and I just can't seem to get it to work.Any help will be appreciated.Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-09 : 01:50:58
|
| What i've done in similar cases is to pass 'All' as the value for the parameter from first report. In the second report for the parameter i'll add a dataset which will select values to populate the combobox. the query will be likeSELECT FieldName FROM Table WHERE FieldName = @Param OR @Param='All'and using this dataset i'll set the default values also by choosing values from query option and mapping to the above dataset.Once this is done and you pass 'All' from first report it'll make sure entire fields are selected as default value and so in combo you'll see select all as well as all options selected------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Insider
Starting Member
5 Posts |
Posted - 2013-12-09 : 04:47:53
|
quote:
Originally posted by visakh16
What i've done in similar cases is to pass 'All' as the value for the parameter from first report. In the second report for the parameter i'll add a dataset which will select values to populate the combobox. the query will be likeSELECT FieldName FROM Table WHERE FieldName = @Param OR @Param='All'and using this dataset i'll set the default values also by choosing values from query option and mapping to the above dataset.Once this is done and you pass 'All' from first report it'll make sure entire fields are selected as default value and so in combo you'll see select all as well as all options selected------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Hi. Thanks for you reply. I don't quite follow your solution so let me just clarify my situation. In my first report I have three parameters, all of which consist of a multiple drop-down list. My second report has five parameters, one of which is a date box whilst the remaining four are multiple drop-down lists. There is only one common parameter between both the two reports and that is in the form of a drop-down. What I would like to do is reference the second report via the first report through the Action option. However I need to make the 'other' (not common) parameters in the second report default to '(Select All)'. Hope that makes sense and I hope I haven't repeated myself, just that I didn't quite follow your idea.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-09 : 06:56:48
|
| ok..So you want the noncommon parameters to default to select All? In that case dont pass any value for them from the first report. In the second report for those parameteres set default values in parameter properties using from query option and use the same dataset you used to fill them as the source and map the value field as corresponding field from the dataset which gives you the parameter values which is used for filtering in the report query.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Expressing 'Select All' from dropdown