How do I open an .rptproj in Visual Studio 2010?

Question

I have a Visual Studio 2010 solution that contains an .rptproj type of project. One of my colleagues is able to open that solution in Visual Studio 2010 SP1 just fine. I've seen it work. However, when I try to do it, I get

"this type of project is not supported by this version of the application"

I am able to open the solution from SQL Server Business Intelligence Studio 2008 just fine.

We both have VS2010 Ultimate SP1 and SQL Server 2008 R2 Enterprise. Full installs for both products. When you go to his Help -> About dialog on Visual Studio, it lists

• SQL Server Analysis Services
• SQL Server Reporting Services
• and SQL Server Integration Services

On my VS2010, those do not show up, but they do on my the SQL Server BI Studio About dialog. I tried uninstalling everything and reinstallling it, but to no avail.

Answer 1

What I had to to do is to install Business Intelligence Development Studio from SQL Server 2008 installer (specifically, I used 2008 R2). See the screenshot below.

That added the templates for SSRS to Visual Studio 2008.

Note, you have to have VS 2008 SP 1 installed (at least for SQL Server 2008 R2).

Answer 2

SQL Server Data Tools is a free add on to Visual Studio / SQL Server that supports reporting projects, so this may give you what you need. I have only used it for Database projects and not reporting projects, so I am not certain if it will be the solution in this scenario, but give it a shot. When we upgraded to Visual Studio 2010 back in 2010, this did not exist, so we moved our reporting into a separate VS2008 solution, so that's always a (non-ideal) solution.