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

GR7 picture GR7 · Dec 21, 2012 · Viewed 31.7k times · Source

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

Szymon picture Szymon · Nov 19, 2013

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).

enter image description here