Posted on 7/19/2011 7:31:00 PM by Levin, Aric

Development  Dynamics CRM  SQL 

Visual Studio 2010 and Report Builder 3.0 RDL reports use a new schema that is not supported by SQL Server 2008 Reporting Services. They are designed to work only with SSRS 2008 R2. Currently there is no way to publish a VS2010 Report on SQL Server 2008 without some modifications to the RDL code.

Visual Studio 2010 and Report Builder 3.0 RDL reports use a new schema that is not supported by SQL Server 2008 Reporting Services. They are designed to work only with SSRS 2008 R2. Currently there is no way to publish a VS2010 Report on SQL Server 2008 without some modifications to the RDL code.

In order to publish the RDL in SSRS 2008, the following steps have to be performed:

1. Open the RDL file (not project) with Visual Studio or an Xml Editor.

2. Replace the report namespace occurrences from 2010 to 2008:

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" 
  xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" 
  xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">


Should be replaced with:

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" 
  xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2008/01/componentdefinition" 
  xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

 

3. Report the following Xml Tags (Keep the Xml between the Tags)

<ReportSections>
  <ReportSection>
  </ReportSection>
</ReportSections>


4. Save the Xml file and publish the report. This should now work with SSRS 2008. 


Navigate to original post to enter comments