July 17, 2006 at 9:03 am
Has anyone found a sucessfull way to create data driven subscriptions using multivalue subscriptions?
From what little I have read, it is not supported. Does anyone know if this is coming in a future service pack?
July 20, 2006 at 8:00 am
This was removed by the editor as SPAM
May 12, 2011 at 5:14 am
If you're referring to multi values for a single parameter I've had the same problem.
I see that when you setup the default parameters for a report you can have multiple values by putting the values on the subsequesnt lines... however when I enter a CR (CHAR(13)) or LF (CHAR(10)) in between the values in the data driven field this still doesn't work.
The only (messy) way I've found to get around this is to create a linked report and setting the deault parameters with the ones you need. Which, I know, kind of defeats the purpose of a data-driven subscription.
Dave
May 12, 2011 at 6:50 am
Create a permanent single column blank table for your multiple parameters. In the data driven portion of the subscription truncate the table then write the chosen or default parameters to that table. Then in your dataset query make your code something like this:
WHERE ColumntoSlice IN (SELECT SingleColumn from SingleColumnTable)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply