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.
| Table of Contents |
|---|
Ensure that you have the .Net Framework 3.5 installed on your computer.
| 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
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
...
| Code Block |
|---|
setup.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=BIDS /INSTANCENAME=MSSQLSERVER |
...
Install the Visual Studio 2010 Shell and optionally Service Pack 1
...
SSDT (VS 2015 Shell)
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 Microsoft via 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.
