O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to design reports manually

The wizard in Report Builder is much more powerful than the one included in SSDT. For example, it can generate charts, something the SSDT wizard cannot do.

It can be useful though to know how to generate a report within Report Builder manually. This will give you exposure to some of the behind-the-scenes functionality of Report Builder, which you'll find isn't much different from SSDT.

Getting ready...

Open Report Builder, if it is not open, to bring up the Getting Started window, or go to File | New in order to bring up the New Report or Dataset window. Both windows will achieve the same goal letting us start a new report.

How to do it...

  1. Select Blank Report.
  2. In the Report Data tool area on the left, right-click on Data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required