13 August | SQL Reporting Services Missing in Action in Visual Studio 2017 |  |
Recently I have had a number of clients contacting me because on upgrading to Visual Studio 2017, they cannot migrate their SQL Server Reporting Services Project
The Issue:
What I found in both cases is a curious thing.
In previous versions of Microsoft Visual Studio, the Business Intelligence suite of which SQL Reporting Services sits in included.
However for some unknown reason the latest versions of Visual Studio (2015 - 2017) does not!
So when my clients try to migrate from lower version of SQL Server Reporting Services to SSRS 2017 with Visual Studio it results in an error message, which although states a lot, really is of limited use!
When I have gone in and seen what projects I can create in Visual Studio 2017, noticeably the SQL Server Reporting Services Project and Project Wizard are missing.
Solution:
It appears that Microsoft has moved over to Extensions
Download and install the required SQL Server Reporting Services Extensions from:
Microsoft Reporting Services Projects
Microsoft RDLC Report Designer for Visual Studio
To install these extensions:
- Launch Visual Studio 2017
- Go to Tools Menu
- Select Extensions and Updates
- In the Extensions and Updates dialog box, select the Online option
- Click in the Search Visual Studio Marketplace dialog box, top right hand corner
- Type in Report
- Press return
- Select Microsoft Rdlc Report Design for Visual Studio
- Press the Download button
- Select Microsoft Reporting Services Project
- Press the Download button
- Press the Close button
- Close Visual Studio 2017
The extensions will install
- Open Visual Studio 2017
SQL Server Reporting Services will be installed
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |
|
|
1 | kfy | 10 March |
| That was super helpful! Thank you! |
2 | Joolz | 22 August |
| Thank you that was really helpful |
3 | Training Dept | 22 August |
| Glad you got it to work :) |
4 | Jim Denney | 05 December |
| Still no wizards. This version of VS is really screwed up. |
5 | Harnish | 10 April |
| Thanks... In my case it's disable. I enable it and reopen VS2017. |
6 | glt | 23 June |
| In my case, I built an SSRS project last week, deployed it, and this week tried to re-open. It says "incompatible" in the project name and I can no longer seem to work with it. Why does Microsoft keep screwing with things that work? I'm just about ready to move everything off of MS SQL platform. Too bad, it's been very reliable for us for a very long time. But this might be the last straw. |
7 | Mizokunimto | 09 March |
| Thank you man you saved me a lot of time.
Very appreciated. |
8 | Choo Tim | 04 March |
| Very helpful indeed. |
|