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  Development Tools  Reporting Services Development  Need help with Data driven subscription

Author  Topic  barb Starting Member 1 Post Posted - 2014-06-16 : 15:16:04 Hi, I am trying to create a data driven subscription for my Report which contains cascading parameters. Param1 -> default values from query Param2 -> read from database Param3 -> default values Param 4 -> default value Param5 -> multivalued parameter with default values from query (allowed values depend on Params 1-4) But when I create data driven subscription Param5 is Not getting Updated and Will get an Error saying : This report requires a default or user-defined value for the report parameter 'Param5'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet) Kindly suggest any solution or workaround. Thanks! Barb