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 reports with multiple data regions

There is an old saying, A picture is worth a thousand words. Unfortunately, all too often, a picture needs a little helping text to explain it. In the reporting world, it is common to want to display multiple objects, most commonly a chart and a table or matrix, on the same report, both sourced from the same data. This technique is known as having multiple data regions on the same report.

Getting ready

For this report, we want to plot the total sales by year for each of the sales territories in our sales fact table. This will naturally fit well into a chart, in order to quickly perform a comparison between territories. However, the management also needs to know the exact values for each territory by year. ...

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