Post reply

How to render same report multiple times using Report Subscription for various parameter values

  • September 9, 2011 at 12:51 am

    #247533

    Dear All,

    I am having one ssrs report with 1 report parameter named Region .There are total 60 Regions.I need to automate this report using report subscription.My task is to generate individual report pdf for each region.So i need to generate 60 report pdfs.Please let me know how to achieve this task.

    Thanks in Advance...

    Regards,

    Seshu.

  • September 9, 2011 at 1:13 am

    #1379031

    If you're using the Enterprise Edition you can simply crteate a Data driven subscription. In the query window write a query to select all the values

    SELECT RegionName from yourTable

    and then choose the option "Get parameter value from database" and select "RegionName"

    [font="Verdana"]Markus Bohse[/font]

  • September 12, 2011 at 10:11 pm

    #1380401

    Thanks Markus.As suggested by you i tried it through Data Driven Subscription and able to generate reports individually for each region.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply