Reviews
SQL Server Reporting ServicesReport Builder 2.0 - Create a Chart
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.
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:

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.
SQL Server Reporting Services
- Leaning SQL Server 2008 Reporting Services
- Working with the Report Builder
- Report Builder 2.0 - User Interface Description
- Report Builder 2.0 - Data Regions
- Report Builder 2.0 - Matrix
- Report Builder 2.0 - List
- Report Builder 2.0 - Chart
- Report Builder 2.0 - Gauge
- Report Builder 2.0 - Subreports
- Report Builder 2.0 - Report Designer
- Report Builder 2.0 - Report Designer Pane
- Report Builder 2.0 - Server Status and Tools
- Report Builder 2.0 - Modifying a Basic Report
- Report Builder 2.0 - Imported MS Access Report
- Report Builder 2.0 - Creating Reports with Charts and Gauges
- Report Builder 2.0 - Create a Datasource
- Report Builder 2.0 - Dataset Based on Excel File
- Report Builder 2.0 - Format a Column
- Report Builder 2.0 - Create a Chart
- Report Builder 2.0 - Add Gauges
- Report Builder 2.0 - Add a Report Item
- Report Builder 2.0 - Add a Gauge to Display Average
- Report Builder 2.0 - Create a Bookmark







