Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to upgrade a Reporting Services project to Visual Studio 2019

We recently upgraded our Visual Studio 2015 to VS 2019. When I open one of our VS 2015 solution files in Visual Studio 2019 I'm not prompted to migrate and I receive the following error:

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

  • Financial Reporting, "Z:\Folders by Department\Finance\Reporting\Visual Studio 2019\Projects\Financial Reporting\Financial Reporting\Financial Reporting.rptproj"

How can I migrate this project?

like image 302
Joe Avatar asked May 29 '19 14:05

Joe


People also ask

How do I install Microsoft Reporting Services projects in Visual Studio 2019?

SQL Server Reporting Services is in SQL Server, but the Projects in Visual Studio are extensions. In order to install the extension, you need to install the SSDT first with the Visual Studio Installer, and then in the Visual Studio go to Extensions to install the SSRS extension. P.D.

How do I open the Reporting Services project in Visual Studio 2019?

From the Tools menu, select Extensions and Updates > Online. In the center column, select Microsoft Reporting Services Projects > Download from the displayed extensions. For SSDT, See Download SQL Server Data Tools (SSDT).

Does Visual Studio 2022 support SSRS?

Visual Studio 2022 has been out for some eight months now, but it still lacks full support for SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), a top feature request.

How do I edit RDL report in Visual Studio 2019?

Right click Reports and add an existing item. Select an existing RDL file to add it to the project. Double click it to open it. You will now be able to see and edit the report in Visual Studio.


1 Answers

From my research it appears that as of Visual Studio 2017, .rptproj are not supported out of the box. You need to install the Microsoft Reporting Services Projects package in order to open this file type in Visual Studio 2017 or Visual Studio 2019:

The [package contains the] Microsoft RDL report designer, projects and wizards for creating professional reports. This package provides support for the .rptproj type and is designed for the most recent versions of Microsoft Reporting Services.


The RDLC Report Designer that came with previous versions of Visual Studio is also now a VSIX installation package - Microsoft RDLC Report Designer.

like image 67
Stephen Kennedy Avatar answered Oct 10 '22 17:10

Stephen Kennedy