Reporting Services 2005 on SQL Server 2000

Hi,

I'm quite new to the Reporting Services 2005 and think I've made a slight(!) mistake. When I was on a training course to learn ASP2, I was told that I could create the Reports in SSRS2005 tool for VS2005 and that would work perfectly well with my copy of SQL Server 2000 - As VS2005 came with a 'runtime' so it could read the data off any objectdatasource.

Do I need SQL Server 2005 installed to run reports created in SSRS2005? We only have SQL Server 2000 and have no plans at present to upgrade.

If anyone has any advice, I'd be grateful, I guess I could always reinstall VS2003 and then recreate the reports in the Reporting Services for SQL Server 2000 and then link the two together.

Thanks,

Barnaby

Hi,

You can not publish SSRS 2005 reports to a SQL Server 2000 server as the RDL schema is changed in SSRS 2005 from SSRS 2000.

Directly from MSDN -

You cannot publish a report that has the SQL Server 2005 report definition namespace to a SQL Server 2000 report server.

Now to change the reports to SSRS 2000 chack this post(doin reverse might help, not sure) -

http://www.developmentnow.com/g/115_2007_4_0_0_964434/Converting-2000-rdl-files-to-2005.htm