Showing posts with label compatible. Show all posts
Showing posts with label compatible. Show all posts

Thursday, February 9, 2012

Are SRS 2005 Reports Backwards Compatible?

I have a customer that is running SRS 2000 and unfortunately I only have SRS
2005 and Visual Studio 2005 in a test environement. Is it possible to
develop the reports in SRS 2005 and save them somehow that they can be
deployed on a 2000 instance of SRS?
If not, can I create the reports on in Visual Studio 2005 while I am hitting
their SRS 2000 instance?No on both accounts.
RS 2000 report designer only runs in VS 2003.
Theorectically you could hand edit the RDL and remove RS 2005 specific
elements but I wouldn't want to try to do that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack Bender" <JackBender@.discussions.microsoft.com> wrote in message
news:DAC028CC-5F46-4F00-B14E-D6EE44A43913@.microsoft.com...
>I have a customer that is running SRS 2000 and unfortunately I only have
>SRS
> 2005 and Visual Studio 2005 in a test environement. Is it possible to
> develop the reports in SRS 2005 and save them somehow that they can be
> deployed on a 2000 instance of SRS?
> If not, can I create the reports on in Visual Studio 2005 while I am
> hitting
> their SRS 2000 instance?

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.
>