O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding data to a chart

What we're going to do here is look at the relative percentage of product categories that are sold in store and online. If you noticed we have an OnlineOrderFlag column in our dataset. A product is either sold in store or online.

To add data to the chart, click in the chart area to display the Chart Data dialog box.

Adding data to a chart

In the previous illustration, we put the Category field of our dataset as our chart data value. The value aggregate [Count(Category)] just below that indicates that we're doing a count operation on that field.

We can do other aggregate functions such as Average, Sum, Max, Min, and other aggregates. Choose any function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required