SSRS Workstation Setup

Review the following instructions for setting up your workstation to develop SSRS reports with Synergetic.

Ensure that you have the .Net Framework 3.5 installed on your computer.

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 they were written in.

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.