From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Adding charts to reports

Adding charts to reports - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Adding charts to reports

If you want to get even more graphical, we can add a chart to our reports. Now I'm going to add a chart. This can either come before our table here or afterwards. I'm going to put it afterwards. I'll click Insert and then if you notice, we have a Chart option here. We can directly insert it and then format it, or the Chart Wizard will help us through some of that. So the question is, is the data that we want on the chart already in the data set, and let's say for our purposes it will be. What I'm going to do is show a bar chart of the sales that we've made based on the Region or the Province that we've done it in. I'm going to click Next, and it will ask is it a Column, is it a Line, is it a Pie, and this of course is going to be a choice that you'll make more based on what the data actually is and how many data points you're expecting to have. The best thing is just experiment with these. Try several different ones. I'm going to pick a Column to begin with, and click Next. What it's…

Contents