Importing Reports From SSRS 2008 R2 To SSRS 2008

Tuesday, April 3, 2012

When importing an RDL report from SSRS 2008 server to the newer SSRS 2008 R2 version, the server will automatically upgrade it to latest version. But when attempting to import the other way around it won’t work as the older server doesn’t recognize the newer format. In order to successfully import an RDL from 2008 R2 to the previous SSRS 2008 version, you need to downgrade the RDL file format. 1. Change schema: <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> 2. Remove <rd:SecurityType> element under the <DataSources> element: <rd:SecurityType>None</rd:SecurityType> 3. Remove <ReportSections> and <ReportSection> elements: ...
no comments