SSRS - generate one PDF per record automatically
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 22nd, 2012 6:18am

Take a look at the data driven subscriptions: http://msdn.microsoft.com/en-us/library/ms169673.aspxBest Regards, Dattatrey Sindol (Datta) | Blog | Facebook | Twitter | "Please mark the post as answered if it solves your problem."
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 12:00pm

Hi Datta, Thanks for your reply. I've read about data driven subscriptions, but I can see how I can use them to generate one output file per record. Have I missed something?
November 22nd, 2012 12:57pm

In lesson 3, step 3 you define subscription query - report will be executed for each row from this query.
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 4:51pm

Hi Tsoo, Base on my research, there is no such function to generate PDF for each record in Reporting Services currently. If you have full experience about programing, you can write a quick program that loops through your data and passes each unique record value to the report as a parameter and saves it as a PDF with a unique name. If you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Thank you for your understanding. Regards, Charlie LiaoCharlie Liao TechNet Community Support
November 23rd, 2012 4:21am

Thanks Charlie. I'm going to do this in C#, as per this example: http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render.aspx
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2012 4:36am

hi, As per your requirement instead of executing the report for each record and getting pdf print of it, may be you can try giving a page break for each ID value if you don't have any page number restriction in the report footer or so with which you can get output print with each record on one page .. one after the other on single report execution. Cheers, Arun Gangumalla Please mark as helpful or answered if it resolves your issue to help others in finding solutions easily.
November 26th, 2012 3:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics