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 - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.