Visual Studio 2010 Reporting Services Projects?

So, it seems that Visual Studio 2010 does not support SSRS projects. At least n开发者_高级运维ot old ones.. Does anyone know what the status on this situation is and whether one can author new SSRS reports using VS2010 or if one should just use VS2008 BIDS?

SQL Server 2008 R2 = SQL Server 2010 (ish)

"R2 doesn't integrate with Visual Studio 2010 as it targets VS 2008 only" read more here:

http://prologika.com/CS/blogs/blog/archive/2010/03/16/bids-integration-story-in-r2-the-good-the-bad-and-the-ugly.aspx

You need the BIDS (Business Intelligence Development Studio) installedm, which is part of SQL tools.

However, as usual for VS/SSRS it max be an implicit upgrade of your reports

And some stuff on the VS team blog

SQL Server Business Development uses the Visual Studio shell. Because SQL 2008 and VS2010 were under development at the same time, they had to use the VS2008 shell.

Microsoft has released the shell as a component that anyone can use and redistribute.

According to the release notes of the upcoming release of SQL Server 2012,

In SQL Server 2012, SQL Server Data Tools (SSDT) is an add-in to Visual Studio 2010. Report server projects created in SQL Server 2008 R2 can be opened directly into SQL Server Data Tools (SSDT). Projects created in SQL Server 2008 are automatically upgraded when opened in SQL Server Data Tools (SSDT). For ease of managing your existing and new report server projects, you can continue to add projects created in SQL Server 2008 R2 and SQL Server 2008 to a SQL Server 2012 business intelligence solution.

You can also continue to open and edit reports that use the 2005 and 2008 RDL schemas in SQL Server Data Tools (SSDT). However, if you add a report item that is not compatible with the schema used by a report, the report will be automatically upgraded to the 2010 RDL schema.

What's New (Reporting Services)

With Service Pack 1 and SQL 2012 SSDT Shared Components you can now work on SSRS reports in VS2010 and still deploy them to 2008 and 2008 R2 SQL Servers.

SP1: http://www.microsoft.com/en-us/download/details.aspx?id=23691