CODEWITHSUNDEEP
reporting-servicesreportbuilder
TS00
TS00

Reputation: 219

SSRS generate one pdf per record automatically

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.

Upvotes: 4

Views: 4275

Answers (2)

user1578107
user1578107

Reputation: 665

If you have Enterprise SKU of SQL Server, look at data driven subscriptions. Another option could be creating report with one record per page, and then splitting resulting PDF into individual PDFs using some free tools.

Upvotes: 0

Chris Latta
Chris Latta

Reputation: 20560

I'd write a report that takes a parameter and generates the report for one record. Deploy to your Reporting Services server.

Then I'd 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. It's quite easy to run reports programmatically and Microsoft have some code to get you started.

Upvotes: 1

Related Questions