How do I open SSRS (.rptproj) files in Visual Studio 2013?

C#Reporting ServicesVisual Studio-2013

C# Problem Overview


How do I open .rptproj in Visual Studio 2013 Pro? When I try to open SSRS projects originally created in VS2008, in VS2013 I get:

Unsupported
This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them. 
For more information on enabling these project types or otherwise migrating your assets, please see the details in the "Migration Report" displayed after clicking OK.

C# Solutions


Solution 1 - C#

It can be opened with Microsoft SQL Server Data Tools - Business Intelligence for VS2013:

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

The download is live again as of 6/2/14

Solution 2 - C#

You should install Business Intelligence Studio, it comes as part of MS SQL Server installation.

Business Intelligence Development Studio (BIDS) — is a part of MS SQL Server. BIDS is a IDE for rdl reports development based on Visual Studio Shell. BIDS allows you to open .rptproj files. If you install BIDS on the same box with your regular Visual Studio, you will be able to open .rptproj and .csproj files from one IDE.

The issue is that SQL Server installations include BIDS based on previous version of Visual Studio Shell, i.e. SQL Server 2008 R2 will provide you BIDS integrated to Visual Studio 2008, while SQL Server 2012 BIDS will be based on Visual Studio 2010.

As far as I know, there is no BIDS that integrates into VS2013.

There is version for VS2012.

SQL Server 2014 will ship BIDS based on VS2012 as well.

I believe we will see BIDS for VS2013 not earlier than in SQL Server 2016.

Solution 3 - C#

SSRS is not a part of VS2013, it is part of SQL Server. You need the BI Dev Studio installed in order to be able to open SSRS projects (rptproj). It uses VS2013 just as a shell similar to what other products do...

Solution 4 - C#

For Visual Studio 2017 you need to download an install SSDT for VS 2017 (standalone installer) with SQL Server Reporting Services.

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionDenisView Question on Stackoverflow
Solution 1 - C#ElephantikView Answer on Stackoverflow
Solution 2 - C#shytikovView Answer on Stackoverflow
Solution 3 - C#Z.D.View Answer on Stackoverflow
Solution 4 - C#OgglasView Answer on Stackoverflow