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

Setting up data sources

While simulated data is nice, you'll obviously want to use your real data in your reports. The Mobile Report Publisher uses datasets stored in the Report Portal to supply data to the reports.

Getting ready

The easiest way to create a dataset is with Report Builder. For a detailed explanation, see the Working with published datasets recipe in Chapter 4, Authoring Reports with Report Builder, to learn how to create them. In this section, we'll supply just the basic steps.

How to do it....

  1. Open Report Builder.
  2. Select New Dataset.
  3. Select the WideWorldImportersDW data source, or browse to the one stored on your report server's data sources you saved previously.
  4. Click on the Create button.
  5. Click on Edit as Text.
  6. Paste in the following ...

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