Add a sparkline to a drilldown matrix SQL Server


show more Adding a sparkline to a drilldown matrix from information stored in your SQL Server is a great way to connect two datasets. You can then use very basic, automatically-generated sparkline charts to compare multiple sets of data from within the datasets. Learn how to perform this advanced technique for organizing and presenting data in this online video. show less
please wait ...

Adding a sparkline to a drilldown matrix

I'm beginning here in Report Builder once again with a blank report and a data source pointing to the regular AdventureWorks database. I am going to add a matrix to this report and add a sparkline into that matrix so that we will have multiple sparklines automatically generated for whatever rows are returned from the database. Now, most of our work in this example will be in preparing the dataset. I am going to take the same idea that I used in the previous example, of getting total sale broken down by year and month, but this time I'm going to start joining this together with the salesperson and region data so I can have a matrix that drills down to multiple levels of information.

So I'll create a new dataset. I will call this SalesInfo. Jumping into the Query Designer, I will first go and get a very similar set of data to what we've got in the previous example, into the SalesOrderHeader and select OrderDate and TotalDue. But what I also want here is information about wha...

Adding a sparkline to a drilldown matrix
Video duration: 14m 34s 3h 44m Advanced

Viewers:

Adding a sparkline to a drilldown matrix from information stored in your SQL Server is a great way to connect two datasets. You can then use very basic, automatically-generated sparkline charts to compare multiple sets of data from within the datasets. Learn how to perform this advanced technique for organizing and presenting data in this online video.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...