I have some reports created with VS .Net 2003.  The reports are running on a SQL RS 2000 server.  Now I have VS 2005.  When I tried to open the reports in VS 2005 it informed me that its going to update the reports.  If VS 2005 updated the reports, would the reports be broken when they run on the SQL RS 2000 server?  Is there anything I should be aware of? 

Thanks.

I ran into this error but didn't have time to go back.

What do I need to do when upgrading to SQL 2005 is not possible at this time?  Keep using VS .NET 2003?

Thanks.

Actually,

The only way to go back and forth is allow VS to do the upgrade to 2005, but to go backwards you'll need to edit the reports from 2005 to still use them in RS 2000 in notepad....

What you need to do is change the namespace referenced at the top of the XML file from ...

xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"

TO

xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"

and delete COMPLETELY the two sections with "InteractiveHeight" and "InteractiveWidth"

You can now upload the report to the RS 2000 instance.

Jason,

When I upload a report saved in VS 2005 to a SQL 2000 RS server, I got The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) .  Is there a way to go around or VS 2003 is the only choice to edit the report?

Thanks