Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Chapter 20Advanced Mobile Report Solutions

WHAT'S IN THIS CHAPTER?

• Introducing the Chart data grid visual control
• Correlating two datasets in a control
• Using parameters in a shared dataset
• Drill through to a mobile report with dataset parameters
• Drill through to a paginated report with dataset parameters
• Adding custom maps and managing shapes

This chapter develops two themes. First, you learn to use some of the most advanced mobile report features, which include the Chart data grid, drillthrough navigation, and maps. Second, since you now have the skills to create mobile reports without detailed instructions, you'll do some of the easy work on your own.

DESIGNING A CHART DATA GRID MOBILE REPORT

In Chapter 17 I mentioned that there are cases for which you will need to design datasets specifically suited for certain controls and this is one of those cases. The Chart data grid control requires two datasets; one to populate the rows of the grid and another for the chart. This is a classic master/detail relationship where a pair of key values is used to correlate the two datasets.

Exercise: Chart Data Grid

The exercises in Chapters 18 and 19 have provided you with all the basic skills to create mobile reports. To move a little faster through this exercise, I am not providing all the detail steps for skills you have already learned. You can use the completed datasets and report in the Samples project.

Create Datasets

You will create four shared datasets. These include two ...