Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Thursday, January 24, 2013 2:39 AM


Group: General Forum Members
Last Login: Thursday, March 26, 2015 3:34 AM
Points: 133, Visits: 567
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 ?


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: Tuesday, June 30, 2015 8:31 AM
Points: 25, Visits: 169
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