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."
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.
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
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