SSRS installation

  • Brad Allison

    Hall of Fame

    Points: 3473

    It has been a while since I have had to use SSRS and have gone through some iterations of both machines and SQL upgrades.  Where and how do I get the application to create reports?  I thought it was through Visual Studio and I do have a copy of 2017 installed, but under my SSDT I only have SSIS.  I am looking for SSRS.  Thanks for the information

  • Michael L John

    One Orange Chip

    Points: 25770

    Brad Allison - Monday, December 3, 2018 11:09 AM

    It has been a while since I have had to use SSRS and have gone through some iterations of both machines and SQL upgrades.  Where and how do I get the application to create reports?  I thought it was through Visual Studio and I do have a copy of 2017 installed, but under my SSDT I only have SSIS.  I am looking for SSRS.  Thanks for the information

    Did you install all of the SSDT pieces?

    It's under "Business Intelligence", not SQL, if that helps.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Brad Allison

    Hall of Fame

    Points: 3473

    It kind of helps, but I only have SSIS there.  How do I get the rest of the SSDT features?

  • Michael L John

    One Orange Chip

    Points: 25770

    Brad Allison - Monday, December 3, 2018 11:24 AM

    It kind of helps, but I only have SSIS there.  How do I get the rest of the SSDT features?

    Go to control panel, and modify the installation.  There are 4 checkboxes in the installation, make sure you select all of them.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Brad Allison

    Hall of Fame

    Points: 3473

    And when I do that through the control panel, the Visual Studio installer comes up and under Data Tools, I do not have the option for Reporting Services.

  • Michael L John

    One Orange Chip

    Points: 25770

    Brad Allison - Monday, December 3, 2018 11:55 AM

    And when I do that through the control panel, the Visual Studio installer comes up and under Data Tools, I do not have the option for Reporting Services.

    I think you may be missing something.

    Here is MS's link to download SSDT
    https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

    It has a screen shot that clearly shows the 4 check boxes.  Did you select the correct instance of Visual Studio to modify?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Brad Allison

    Hall of Fame

    Points: 3473

    Yep. got it and thanks!  Redownloading it brought up the options of components to install.

  • Michael L John

    One Orange Chip

    Points: 25770

    Brad Allison - Monday, December 3, 2018 12:10 PM

    Yep. got it and thanks!  Redownloading it brought up the options of components to install.

    Glad to help!

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply