Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be wary of people who tell you how honest they are
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

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:

  1. Launch Visual Studio 2017
  2. Go to Tools Menu
  3. Select Extensions and Updates
  4. In the Extensions and Updates dialog box, select the Online option
  5. Click in the Search Visual Studio Marketplace dialog box, top right hand corner
  6. Type in Report
  7. Press return
  8. Select Microsoft Rdlc Report Design for Visual Studio
  9. Press the Download button
  10. Select Microsoft Reporting Services Project
  11. Press the Download button
  12. Press the Close button
  13. Close Visual Studio 2017

    The extensions will install

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

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

6 + 55 =