SQL Server Reporting Services (SSRS)–How to open SSRS Project

Ever try to open an older SQL Server Reporting Services (SSRS) project and do not know what product it opens with? SSRS and how to add/manage reports always seems to be a problem. Well, Visual Studio 2017 has an extension that you can use to open the older rptproj files. Give it a go.

- March 3, 2019

Rest of the Story:

When you're trying to open your SSIS or SSRS solution, you will get a message that the migration has failed or 'The application which this project type is based on was not found.'

You can open rptproj files with Visual Studio 2017 with an extension.  Follow the following steps to get going.

  • Open ‘Microsoft Visual Studio 2017‘.
  • In the menu bar, expand ‘Tools‘, then choose ‘Extensions & Updates‘. to install an extension.
  • Search for ‘Microsoft Reporting Services Projects‘, and install this extension.
  • To complete the installation, shut down all windows and instances of Microsoft Visual Studio 2017. Then the installer will start.
  • Try to open your solution or projects (*.rptproj) again.