InteractiveHeight, SSRS 2005 rdl schema and an instance of SSRS 2008

Got an awesome bug yesterday. QA guys reported that when they had tried to deploy my reports MP to OpsMgr installation powered by SSRS 2008 SP1, they got the following error:

Failed to deploy reporting component to the SQL Server Reporting Services server.
The operation will be retried.

Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘<skipped>’. Failed to deploy report ‘<skipped>.report’. The value provided for the PageHeight field is not valid for its type. It cannot be converted from a string value to the type that is required. —> Microsoft.ReportingServices.Diagnostics.Utilities.ElementTypeMismatchException: The value provided for the PageHeight field is not valid for its type. It cannot be converted from a string value to the type that is required

Okay, what’s wrong with the PageHeight? Centimeters? Dots? Something else? Has the schema changed? Does SSRS 2008 supports SSRS 2005 rdl schema?
I have spent several hours for setting up the lab running SSRS 2008 and some time for googling and investigating. Well, everything was okay with PageHeight set to 29.7cm (A4). SSRS 2008 supports SSRS 2005 rdl schema and everything looks good. But where is the bug? The answer was simple: SSRS 2008 doesn’t allow zero as a value for InteractiveHeight when report is defined using SSRS 2005 rdl schema. So what options do we have to fix this? Not so many, actually:
  1. Switch to native (SSRS 2008) schema. (Doesn’t work for me – I have to support both because customers still may use SSRS 2005.)
  2. Set InteractiveHeight to something really big.  (I have chosen this option and set it to 594cm = 20 A4 pages).
Probably, there are some other options here, possibly this have been fixed since  SQL 2008 SP1 release. Will try to find time to check later.

Leave a Comment