SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Expressing 'Select All' from dropdown
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Insider
Starting Member

2 Posts

Posted - 12/09/2013 :  01:46:17  Show Profile  Reply with Quote
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

Edited by - Insider on 12/09/2013 01:47:01

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 12/09/2013 :  01:50:58  Show Profile  Reply with Quote
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

2 Posts

Posted - 12/09/2013 :  04:47:53  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 12/09/2013 :  06:56:48  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000