Are rpts created w/ SQL 2005 CTP compatible with RS 2000?

We have been developing reports for an application using SQL 2005 CTP
version. Turned out that we cannot install it in the production
environment. We can however install SQL 2000 RS. Does anyone know if
reports developed in SQL 2005 CTP can be deployed to SQL 2000 RS? I was
going to try it today but after SP2 to the SQL 2000 RS. The RS 2000 SP2
doesn't run because of the different version in the databases used by RS.
I'd like to know if the reports would work on 2000 or not before spending
more time trying to figure out how to make RS 2000 SP2 work. Thanks a lot
for any help.No, you can do this the other way. RS 2000 reports in RS 2005 but not the
other way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bob" <bobatkpmg@.yahoo.com> wrote in message
news:ej%233sQ5pFHA.3104@.TK2MSFTNGP12.phx.gbl...
> We have been developing reports for an application using SQL 2005 CTP
> version. Turned out that we cannot install it in the production
> environment. We can however install SQL 2000 RS. Does anyone know if
> reports developed in SQL 2005 CTP can be deployed to SQL 2000 RS? I was
> going to try it today but after SP2 to the SQL 2000 RS. The RS 2000 SP2
> doesn't run because of the different version in the databases used by RS.
> I'd like to know if the reports would work on 2000 or not before spending
> more time trying to figure out how to make RS 2000 SP2 work. Thanks a lot
> for any help.
>|||I wonder if a bit of XSLT could remedy this problem.|||Yes, you could use an XSLT to change the namespace in the RDL files from
2005/01 to 2003/10. In addition, you need to make sure that you remove all
RS 2005 specific additions to the XSD. Specifically, you have to remove the
InteractiveWidth and InteractiveHeight elements. Furthermore, you cannot use
any new RS 2005 RDL features (e.g. Fixed headers).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lancehunt@.gmail.com> wrote in message
news:1124810278.462665.127660@.g43g2000cwa.googlegroups.com...
>I wonder if a bit of XSLT could remedy this problem.
>