Wednesday, March 15, 2006

MS Reporting Services and SQL Server 2005 and Visual Studio 2005

For the record, and in case anyone lands here in a frustrated search for info:
You can't write Microsoft Reporting Services reports for SQL Server 2000, using Visual Studio 2005.

It goes like this:
Visual Studio 2005 - SQL Server 2005 with Reporting Services
Visual Studion 2003 - SQL Server 2000 with Reporting Services.

So, if you're moving on to VS 2005, but have reporting services projects, that must run on SQL Server 2000, don't get rid of VS2003 just yet...

Here's a thread on Reporting Services newsgroups...