Post reply

Report Bursting in SSRS

  • January 9, 2006 at 4:28 am

    #111286

    HI Gurus,

    Is their any option to burst the report?

    if yes, how can we achieve it?

    Eaggerly waiting for your reponse

    Regards,

    Chetan

     

     

  • January 10, 2006 at 4:02 pm

    #613950

    No, there is no report bursting capability in Reporting Services. We came up against the same issue and had to re-work how the report is produced.

    You can approach it a couple of ways,

    1) Continue to produce one large report and have it saved to the file system. Then have a seperate application that "bursts" the report and distributes it. Although I have heard of numerous issues regarding large reports in Reporting Services.

    2) If you have Enterprise Edition, use a data-driven subscription.

    3) If you don't have the Enterprise Edition you can simulate a data-driven subscription making calls to the web service. This is the approach we took. I wrote a little C# console app that gets the list of report recipents from the database and the iterates through this list rendering and distributing each report individually. Takes 40-60 minutes to render and distribute 900+ reports by email.

     

    --------------------
    Colt 45 - the original point and click interface

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

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