SSRS 2008: Cascading Parameters in a Data Driven Subscription

[JoeMiller]

I’ve made a report that has two parameters “TeamID” and “TechID”. When you select a value(s) for Team ID it then limits the TechID parameter to just the members of the selected Team and defaults to selecting all TechID’s. This works perfectly via the Report Manager interface. What I’m trying to do now is make a data driven subscription for this report and supply the TeamID, which I was hoping would then default the TechID’s just like the Report Manager UI. When setting up the subscription I leave the “Use Default” checkbox on for the TechID parameter. However, when I try to save the subscription it errors saying:

This report requires a default or user-defined value for the report parameter 'TechID'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet)

Any body know of a way to make this cascading parameter work in my data driven subscription?

Joe


Joe Miller
joe.miller@flotech.net