Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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. 
like image 644
Denis Avatar asked Mar 24 '14 14:03

Denis


People also ask

How do I create an RDL report in Visual Studio 2013?

Creating a report definition file (RDL)In the Solution Explorer pane, right-click on the Reports folder. If you don't see the Solution Explorer pane, select View menu > Solution Explorer. Select Add > New Item. In the Add New Item window, select the Report icon.


2 Answers

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

like image 148
Elephantik Avatar answered Sep 28 '22 13:09

Elephantik


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.

like image 37
shytikov Avatar answered Sep 28 '22 13:09

shytikov