All geek questions in one place

SSRS automatically generates one PDF file

I built a report that displays data from db. This works great by reporting correctly.

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

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

Thanks.

+4
source share
2 answers

I would write a report that takes a parameter and generates a report for one record. Deploy it to the Reporting Services server.

Then I would write a quick program that looks at your data and passes each unique record value to the report as a parameter and saves it as a PDF with a unique name. It's easy to run reports programmatically and Microsoft has the code to get you started .

+1
source

If you have Enterprise SKU SQL Server, view subscription-based data . Another option would be to create a report with one record per page, and then split the resulting PDF file into separate PDF files using some free tools.

0
source

Source: https://habr.com/ru/post/1447744/

More articles:


All Articles