How to design reports with the wizard

In this section, we'll create a report using the wizard built into Report Builder. We will recreate the same report from Chapter 2, Advanced Reports with SQL Server Data Tools , in order to compare the way a report is created in Report Builder with the way you create reports in SSDT.

Getting ready

To get to the wizard, simply open Report Builder. If you already have Report Builder open, simply select the File tab and click on New.

How to do it...

  1. On the Getting Started dialog, click on Table or Matrix Wizard:

    How to do it...

    Figure 4.04

  2. On the next page of the wizard, ensure that the Create a dataset option is selected and then ...

Get SQL Server 2016 Reporting Services Cookbook 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.