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.
Ensure that you have the .Net Framework 3.5 installed on your computer.
| Table of Contents |
|---|
| Warning |
|---|
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. |
...
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:
Standalone
...
SSDT (VS 2015 Shell) - Recommended
This is the recommended method of installation as it is quite straight forward.
Ensure that you have the latest version of SQL Server Management Studio v17 installed on your worksation available from SQL Server Management Studio v17
Download and run the SSDT installer for VS 2015 from Microsoft
Select the SQL Server Reporting Services (optionally you can also install Analysis and Integration Services) and click Next.
Accept the License Terms to begin the download and installation.
Once the Setup is complete, restart your computer.
You should now have an entry for SQL Server Data Tools 2015 in your Start Menu
To ensure you're ready to develop reports, click on File > New Project and ensure that Business Intelligence and Reporting Services show
SSDT (VS 2017 Shell)
Download and run the SSDT standalone installer available from Microsoft.
| Tip |
|---|
When installing SSDT on Windows 10 and choosing Install new SQL Server Data Tools for a new Visual Studio 2017 instance. Make sure to clear any checkbox and install the new Visual Studio instance first. After the new instance is installed,reboot the computer and open the SSDT installer again to continue the installation. |
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 selecting Install a new SQL Server Data Tools instance installs instance installs SSDT with a minimal version of Visual Studio.
Visual Studio 2017
SQL Server 2014 - 2016
...
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:
SQL Server 2012 (old method)
Install the SQL Server Data Tools add-on that is part of the SQL Server 2012 Installation Media
Select Management SQL Server Data Tools and Management Tools - Complete or Complete
Alternatively run the following command line using the SQL Server Installation Media to install.
Code Block setup.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=BIDS /INSTANCENAME=MSSQLSERVER
Install the Visual Studio 2010 Shell and optionally Service Pack 1
- Install the SSDT Package available from Microsoft
...