Exforsys

Home arrow Reviews arrow SQL Server Reporting Services

Report Builder 2.0 - Create a Chart

Author: Packt Publishing     Published on: 10th Jun 2009

Create a chart to display the data

The chart you will be creating will be based on the data. You will be using the chart template to begin creating the chart. You will be using the placeholders on the chart to associate data with the details you will be displaying in the chart.

Ads

1. Return to the design view of the report by clicking on the Design button of the Run tab.

2. Enlarge the length of the report body by dragging down the bottom side of the report to create space for the chart.

3. Click on Insert | Chart | Insert Chart and then click in the space you created.

4. The Select Chart Type window gets displayed as described earlier. Accept the default choice and click on the OK button.

This adds a chart template to the report as shown. All objects shown on the chart can be configured.

5. On double-clicking inside the chart, the drop data fields appear on the three sides of the chart as shown:

6. Click on Time in the Report Data and drag it over and drop it on the Drop category fields here.

7. Click on First in Report Data and drag it over and drop it on the Drop data fields here.

8. Repeat the previous step for the Report Data fields Second_ and Third.

9. The design of the chart now appears as shown in the following screenshot showing the drop fields. The chart in the design view is not the data from the source but shows how the chart would look when rendered.

10. Run the report from the "ribbon".
The chart in the report is displayed as shown:

Ads

The chart data region has a large number of properties which allows you to fine tune the formatting of the chart. All properties are accessible in the design. The best place to obtain information is the online documentation (Help menu). In addition to the regular properties, the properties that you can assign using expressions provide even more options to format.



 
This tutorial is part of a SQL Server Reporting Services tutorial series. Read it from the beginning and learn yourself.

SQL Server Reporting Services

 

Comments