Calling different report parameters in a data-driven subscription
is it possible to change specific report parameters in a data-driven subscription on a per subscriber basis? For instance I have a report with 3 parameters, when scheduling Joe I would like to select value A for parameter 1, User harry should have value B for parameter 2 I'm using sql server 2005 enterprise, when reading the MS data-driven subscription example I can only enter users and export formatBusiness Intelligence professional
October 27th, 2010 10:01am
You can write a stored procedure in your DB and get different values for different parameters on the fly. So where you write the query refer the stored procedure and pass userid of the user as a parameter for the stored proc to get different results.
October 27th, 2010 10:08am