SQL Server 2016 Reporting Services Cookbook

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 ...