Creating RS 2005 with Visual Studio 2003

Hi All,

My company is condidering upgrading to SQL Server 2005 and/or Visual Studio 2005. We may decide we want to upgrade one without upgrading the other. My concern is the Reporting Services compatibility.

My understanding is that if we decide to upgrade to Visual Studio 2005, we would have to upgrade to Reporting Services 2005 because VS 2005 cannot create reports that are compatible with RS 2000. But if we decide we want to upgrade to RS 2005, we can continue to create the reports in VS 2003 because RS 2005 supports RS 2000 rdl files.

Is this correct?

Thanks!

Yes, you are wright.

But you cannot use the new feature from RS2005 (see http://www.sqlservercentral.com/columnists/kAli/microsoftreportingservices2005featuresandenhanceme.asp )

|||

SQL Server 2000 Report Designer requires Visual Studio 2003. It does not run in Visual Studio 2005.

Note: reports designed with the RS 2000 report designer / VS 2003 can be directly published to a RS 2005 report server (they will be auto-upgraded on publishing on the server).

SQL Server 2005 uses Visual Studio 2005. If you do not have Visual Studio 2005 installed, Setup will install the version of the Visual Studio shell that is necessary for running Report Designer. You cannot use SQL Server 2005 Report Designer to publish reports to a SQL Server 2000 report server.

-- Robert

|||

Thank you both for your answers!

So basically, we'd be ok upgrading to SQL Server 2005 and staying with VS 2003, but can't upgrade to VS 2005 without upgrading SQL Server - unless we want to run VS 2003 AND VS 2005.

|||Correct.