Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey