Sunday, March 11, 2012

Deploying reports to SSRS 2005 and\or SSRS 2000

We have SQL 2000 & SQL 2005 instances, both with Reporting Services installed. The SQL 2000 instances will be around for a while longer. We would like to upgrade our Visual Studio from 2003 to 2005. Can we deploy reports to either\both of the 2000 or 2005 Report Servers from VS 2005?Since VS 2005 only deals with reports that are in the 2005 RDL format, it can only deploy reports to RS 2005.

RS 2005 supports both 2000 and 2005-era RDL definitions, so you can use VS 2003 or 2005 to deploy to RS 2005.

-Chris|||I thought that RDL was an independent format version and didn't know that it changed with the new VS 2005 or RS 2005.
Thanks.|||RDL is a schema that is currently available in two versions:
* RS 2000 with the RDL schema namespace 2003/10
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition
* RS 2005 with the RDL schema namespace 2005/01
http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition

There are a few additions / changes in RS 2005 (such as fixed headers, new CustomReportItem, CustomProperties) which required a new Xml schema namespace.

You can download more technical information about RDL here: http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx

-- Robert

No comments:

Post a Comment