Importing Reports From SSRS 2008 R2 To SSRS 2008

April 3, 2012

no comments

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:

<ReportSections> 

<ReportSection>

</ReportSection>
</ReportSections>

4. Copy ReportServerUrl:

<rd:ReportServerUrl>http://sql.company.com/ReportServer</rd:ReportServerUrl>

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*