Solution: Linked Reports in SSRS Print with Incorrect Size or Orientation
When deploying reports to an SSRS server, the server creates a record in the Catalog table. this table holds the report location, the binary data for the report, as well as parameter and property information, among other things. On deployment, various report properties are extracted and added to the Properties column of the Categories table in the ReportServer database. A sample is displayed below:
SSRS appears to use the data stored in the Properties column to detect paper size and orientation when printing the report.
When creating a linked report, a new row is created in the Categories table, with the LinkSourceId column set to the Id column of the original report you’re linking from. The Properties column is initialized with the following:
For some unknown reason, SSRS does not copy over the Properties data. When printing a linked report, SSRS uses the Properties data from the linked report. Since there is no property data, it uses defaults, generally 8.5×11.
Unfortunately, there is no facility in the Report Manager to directly set there properties, so one of the following needs to occur:
Solution 1: Setting Report Properties Through the ReportService.asmx Web Service
A post on Brian Weckler’s blog provides VB.NET code for connecting to the ReportService.asmx service and manually setting the properties:
Solution 2: Updating the Linked Report Record in the Database
The property field can be directly updated in the catalog table.
If anyone has any better solutions, please let me know!