problem with setting the subscription for a multivalue parameter as 'All' in a SSRS Report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » problem with setting the subscription for a...

problem with setting the subscription for a multivalue parameter as 'All' in a SSRS Report

Rate Topic

Display Mode

Topic Options

Author

Message

H4K

Posted Thursday, January 24, 2013 2:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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

sql_reporting

Posted Monday, January 28, 2013 2:31 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:42 PM
Points: 25, Visits: 126

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 »

Permissions