running 2005 rdl on a RS 2000 server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bhorwatt - 28 Apr 2006 16:18 GMT

We have written some RS 2005 reports on a development server which now needs
to have SQL Server 2005 re-installed due to 'Database Services' not
installing successfully with SP1. Some of the 2005 reports are currently in
use and I wanted to install them on a RS 2000 report manager on another
server during the downtime.

I am receiving the error 'report definition not valid' which relates to the
schema definition when I try to import these reports into Visual Studio 2003.
Changing 2005 to 2003 in the schema def does not work. Is it possible to
run a RS 2005 report in RS 2000 Report Manager? The report does not use any
of the new features available in RS 2005.

Reply to this Message

Bruce L-C [MVP] - 28 Apr 2006 22:48 GMT

No it is not possible natively. You might be able to hand edit the RDL (in
notepad) to make it work. I have heard that this might be possible.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> We have written some RS 2005 reports on a development server which now
> needs
[quoted text clipped - 12 lines]
> any
> of the new features available in RS 2005.

Reply to this Message