November 22, 2012 at 4:21 am
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
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
Or, send it to WORD as a "merge file" and let it do it. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2012 at 1:05 am
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