Tutorials Reporting ServicesThe 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.
