Using SQL Server Data Tools

Another development environment you can utilize for your reports is SQL Server Data Tools. This tool is no longer part of the installation media for SQL Server and has to be downloaded separately. Data Tools can work independently or together with the installation of Visual Studio. If you don't run Visual Studio, there will be a small Visual Studio shell installed on your development machine and you can start working on your business intelligence projects. Data Tools is an integrated development tool that is used not only for Reporting Services, but also for other business intelligence tools for Microsoft SQL Server.

For Reporting Services, we'll use the Report Server Project Wizard or Report Server Project templates. ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.