Why doesn't Data Driven Subscription in SSRS 2005 like my Stored Procedure?
- by bert
I'm trying to define a Data Driven Subscription for a report in SSRS 2005.
In Step 3 of the set up you're asked for:
" a command or query that returns a list of recipients and optionally returns fields used to vary delivery settings and report parameter values for each recipient"
This I have written and it returns the data without a hitch. I press next and it rolls onto the next screen in the set up which has all the variables to set for the DDS and in each case it has an option to "Select Value From Database"
I select this radio button and press the drop down. No fields are available to me.
Now the only way I could vary the number of parameters returned by the SP was to have the SP write the SQL to an nvarchar variable and then at the end execute the variable as sql. I have tested this in the Management Studio and it returns the expected fields. I even named them after the fields in SSRS but the thing won't put the field names into the dropdowns.
I've even taken the query body out of the Stored Proc, verified it in SSRS and then tried that. It doesn't work either.
Can anyone shed any light into what I'm doing wrong?
