Export separate pdfs from SSRS generated report

pdf-generationreporting-servicesssis-2012

Is it possible for SSRS to name and separate pdf exported files based on parameter groupings? Right now, when I run the report, it only gives me one pdf with 100+ pages. However, at every page-break, I'd like SSRS to create a new pdf file, and it'd be a real time-saver if it would also insert the pdf's filename based on the grouping selection.

Is this possible in SSRS, or do i need to use SSIS for this functionality?

I'm using 'Visual Studio 2010' for SSRS, and 'SQL Server 2012' for integration services

Best Answer

You would be able to do all of what you want in SSRS - if you have the Enterprise edition that has Data-Driven Subscriptions.

https://msdn.microsoft.com/en-us/library/ms159150(v=sql.130).aspx

You would have a parameter for the grouping (your page-break) - for example UserID.

In your data-driven query (NOT the report but a different query used to fire the subscription), you would have a field for your grouping - your UserID in our example. Another field could have your ReportName that is derived from your data - ex.

UserID, 'ReportName for ' + UserName + ' on ' + GetDate() as ReportName

When the data-driven query runs, it will create a record for each UserID which in turn will fire a report for each UserID using it as the parameter to limit the report to just that userID. You could even have that report only e-mailed to that user.

There are ways to run data-driven subscritptions without the Enterprise Edition using SSIS but the do take a bit of work.

http://geoffbi.blogspot.com/2012/04/data-driven-subcriptions-in-standard.html

Related Solutions

Single page display in HTML rendering : SSRS

Short answer: Set the InteractiveHeight = 0

According to Microsoft:

Soft page breaks are calculated at run time by the control. Although it is not recommended, you can disable soft page breaks by setting InteractiveHeight to 0.

InteractiveHeight and InteractiveWidth are used by the HTML rendering extension to provide the equivalent of PageHeight and PageWidth. Because the HTML output format dynamically resizes a report to accommodate drilldown, drillthrough, and show/hide features, the report server uses different properties to support pagination on dynamic pages.

EDIT Comment Answer:
In the Layout mode, bring up Properties panel. At the top of the Properties panel is a drop down to select which control's properties you are looking at, select Report You will then find “Interactive Size” that includes Interactive Height property.

SSRS Report Content Blank

I had the same problem and by following Alex Zakharov's suggestion I found a parameter that had almost 700 rows with them all selected by default. Deselecting a few rows resolved my issue immediately, but that was unsatisfactory for a production release.

Looking for the log files suggested by lrb (\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles\) I found the following error message:

ERROR: HTTP status code --> 500
-------Details--------
System.Web.HttpException: The URL-encoded form data is not valid. ---> 
System.InvalidOperationException: Operation is not valid due to the current state of the object.
at System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded()

Solution

This led me to this answer to find and update the web.configs, add the lines of code below and then restart the service.

<appSettings>
    <!-- default is 1000 -->
    <add key="aspnet:MaxHttpCollectionKeys" value="2000" />
</appSettings>

I had to update in 2 places, because SSRS has separate websites for report manager and report server: \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\web.config

\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\web.config

Best Answer

Related Solutions

Single page display in HTML rendering : SSRS

SSRS Report Content Blank

Solution

Related Topic