Learn How to Create a Column Chart In SQL Server


show more A column chart takes two data sets from your SQL Server and uses vertical columns to turn that data into a graphic representation. This makes column charts an ideal way of presenting two different sets of information. Learn the different steps for creating a column chart in this advanced technical video. show less
please wait ...

Creating a column chart

I am going to begin with a column chart. This might not always be the one that you want, but it's a great one for getting to grips with how to create charts in Reporting Services. And just to save some time, I'm starting here with a blank report where I've defined a data source pointing to the regular AdventureWorks database-- not the LT or DW one, just the regular one. So, the next thing I need to do is create a dataset. I am going to create one called SalesInfo. It will be embedded in a report, and I will select the AdventureWorks data source. Jumping into Query Designer, what I'm going to do is start drilling down into this database. I am going to go in to the Sales section.

But instead of going into Tables, I am going to go into Views, because there are some views in the AdventureWorks database that have already been predefined to join several tables together to provide some useful information. What I'm interested here is a view called vSalesPerson. This has already...

Creating a column chart
Video duration: 8m 35s 3h 44m Advanced

Viewers:

A column chart takes two data sets from your SQL Server and uses vertical columns to turn that data into a graphic representation. This makes column charts an ideal way of presenting two different sets of information. Learn the different steps for creating a column chart in this advanced technical video.

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