Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

problem with setting the subscription for a multivalue parameter as 'All' in a SSRS Report Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 2:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
Hi Experts,

I have a multi value parameter named 'Country'. When the report is previewed, the user selects single or multiple countries or All countries using 'Select All'.
But how can we set data driven subscription for such a parameter in a report to include all countries ?

Thanks,
Amar


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1411006
Posted Monday, January 28, 2013 2:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:35 AM
Points: 25, Visits: 153
If i understood correctly... in your parameter make default values as you are choosing for Available values.

In the parameter in general--> check the allow multiple values.
Post #1412662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse