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

17
votes

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.

4
visual-studio-2010visual-studioreporting-servicesssrs-2008projects-and-solutions
I'm confused. with your solution marked. Those templates (rptproj) can be openen in VS 2010 ? @szymon say that templates for SSRS added to vS 2008 not VS 2010. Did you tried?. – Kiquenet

4 Answers

10
votes

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

6
votes

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.

5
votes

As it turns out, I had incomplete information. My colleague had SQL Server 2012 installed as well on his machine. That SQL install is what made the SQL Server XXX Services show up on his Visual Studio 2010 install.

From what I gather, SQL Server 2008 R2 install would give the older version of Visual Studio the capability to open that SQL version of .rptproj projects. That is, SQL 2008 R2 would give Visual Studio 2008 to open SQL Server 2008 R2 .rptprojects, while SQL Server 2012 gives the option to open SQL Server 2008 R2 .rptprojects.

2
votes

Just to add, I was able to do it with the following steps as shown in this question. Now you can use Visual Studio 2010 to edit reports.

Are SSRS Reports supported in Visual Studio 2010 or 2012?