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

Creating a KPI with shared datasets

We have seen the way of creating a KPI with hard coded values. With this recipe, let's see how we can set values from a source rather hard coding them.

Getting ready

The Chapter07 solution has a shared dataset called DataSetSales. We will use this dataset for creating our KPI. This dataset is a parameterized dataset on the Year column and Month Number column, and it returns the following dataset for the year 2015:

Getting ready

Figure 7.35

Note

Note that values returned from this dataset may vary based on the loaded records into the WideWorldImportersDW database.

Since you need this dataset for creating the KPI, make sure that ...

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