Skip to end of banner
Go to start of banner

SSRS Workstation Setup

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Review the following instructions for setting up your workstation to develop SSRS reports with Synergetic. The latest tools are compatible with older versions of SQL Server.

Reports developed using SSDT are not backwards compatible with older version of SQL Server and Reporting Services. They will only work on the current or newer version of SQL Server and Tools they were written in.

SQL Server 2017

You can either install Visual Studio 2017 or use a Stand-alone version of SSDT (that includes the Visual Studio Shell)

Visual Studio

In the Visual Studio Installer, select Data storage and processing workload, and then select SQL Server Data Tools.

If Visual Studio is already installed, you can modify the installation via the Visual Studio Installer to include the SSDT workload: 

Data storage and processing workload

Standalone

To install Reporting Services project support (as well as Analysis and Integration Services), run the SSDT standalone installer.

If you happen to already have Visual Studio installed the installer will detect this and lists available Visual Studio instances to add the SSDT tools to. If Visual Studio is not installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio.

SQL Server 2014 - 2016

Coming Soon

SQL Server 2012

  1. Install the SQL Server Data Tools add-on that is part of the SQL Server 2012 Installation Media
    Select Management Tools - Complete or run the following command line to install.

    setup.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=BIDS /INSTANCENAME=MSSQLSERVER

  2. Install the Visual Studio 2010 Shell and optionally Service Pack 1

  3. Install the SSDT Package available from Microsoft 


  • No labels