Post reply

Generate SSRS Report and then Email Report from a single Stored Procedure

  • April 21, 2013 at 8:46 pm

    #276705

    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

    #1608578

    What you are describing is "Data Driven Subscriptions" which is available with Enterprise Edition.

  • April 22, 2013 at 4:08 am

    #1608627

    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