Post reply

Generate one PDF per record

  • November 22, 2012 at 4:21 am

    #285284

    Hi all,

    I've built a report which displays data from a db. This works fine, rendering the report correctly.

    My query returns ~40,000 records. I would like to automatically generate a pdf file for each record, named using one of the fields returned by the query.

    How do I automate this? I have Report Builder 3, and Visual Studio.

    Thanks.

  • November 26, 2012 at 3:01 pm

    #1562440

    SSRS only lets you create 1 PDF Per Report Execution.

    So if your report returns 40,000 Pages, It will still only export 1 PDF File.

    You can create a report that takes the record in you want, and export the pdf for that 1 record, and run it 40,000 times.

    to get it to run 40,000 times you can create a service or winapp that gets a list of all 40000 records and loops thru the recordset calling the report for each ID.

    You can perhaps Create the 1 PDF with 40,000 pages and automate someother program to create 1 PDF file per page.

  • November 26, 2012 at 10:08 pm

    #1562494

    Or, send it to WORD as a "merge file" and let it do it. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 27, 2012 at 1:05 am

    #1562541

    Thanks for the replies guys, much appreciated.

    I've gone with the 'single report being called over and over' approach, using this example:

    http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render.aspx

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

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