Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – working with charts in Reporting Services


In this example, we will add a chart for the sales information in the Sales by Product and Territory report from the first example of this chapter. For simplicity, we will just create a stacked column chart with the default configuration from the existing dataset with the help of the following steps:

  1. Open the report designer for the Sales by Product and Territory report.

  2. Click on an empty area in the report designer and then go to the Properties window and choose a Body object.

  3. Change the size of the Body object with these parameters: Width to 5in and Height to 5in.

  4. Drag-and-drop a Chart object from Toolbox into the report designer under the matrix object.

  5. Choose Chart type as 3-D Stacked Column.

  6. Change the title of the chart to Sales by Product and Territory.

  7. Click on the chart shape and you will see the Chart Data pane appear on the right-hand side of the chart, as shown in the following screenshot:

  8. From the Report Data pane, drag-and...