April 21, 2013 at 8:46 pm
Can someone please offer assistance?
I need to create a Stored Procedure that will generate a SSRS reports a number of times with different parameters and then email them to different individuals listed in another table based on parameters that were used when generating each version of the SSRS Report.
Is it possible to generate an SSRS report from a Stored Procedure?
April 21, 2013 at 10:30 pm
What you are describing is "Data Driven Subscriptions" which is available with Enterprise Edition.
April 22, 2013 at 4:08 am
If you don't have enterprise edition...I've acheived this using SSIS. Loop through a table of parameters and output reports (using a script task). Then used another loop and table of e-mail address to send each report.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy