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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Expressing 'Select All' from dropdown

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 like

SELECT 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 like

SELECT 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 MVP
http://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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -