ActiveReports 11
Bar Chart
ActiveReports 11 > ActiveReports User Guide > Samples and Walkthroughs > Walkthroughs > Section Report Walkthroughs > Chart > Bar Chart

Bar charts are useful in comparing items across categories. This walkthrough illustrates how to create a simple bar chart using the ActiveReports chart data region.

The walkthrough is split up into the following activities:

Note: This walkthrough uses the Northwind database. By default, in ActiveReports, the Northwind.mdb file is located at
[User Documents folder]\GrapeCity Samples\ActiveReports 11\Data\NWIND.mdb.

When you complete this walkthrough you get a layout that looks similar to the following at run time.

To add an ActiveReport to the Visual Studio project

  1. Create a new Visual Studio project.
  2. From the Project menu, select Add New Item.
  3. In the Add New Item dialog that appears, select ActiveReports 11 Section Report (code-based) and in the Name field, rename the file as BarChart.
  4. Click the Add button to open a new section report in the designer.

See Adding an ActiveReport to a Project for information on adding different report layouts.

To add the Chart control to the report

  1. From the toolbox, drag the Chart data region to the body of the report.
  2. If the chart wizard appears, click Cancel.
    Tip: If you do not want the chart wizard to appear each time you add a chart, clear the Auto Run Wizard checkbox. You can still access the wizard via the command verbs (see below).
  3. On the design surface, select the grey area outside the report and in the Properties window, set the PrintWidth property to 6.5.
  4. In the Properties window, set the following properties.
    Property Name Property Value
    Location 0, 0 in
    Size 6.5, 3.5 in
  5. In the Report Explorer, select Detail1 and go to the properties window to set the Height property to 3.5.

To connect the Chart to a data source

  1. Select the Chart control and at the bottom of the Properties window, select the Data Source command. See Properties Window for further details on accessing commands.
    Tip: If the verb is not visible, right-click an empty space in the Properties Window and select Commands to display verbs.
  2. In the Chart DataSource dialog box that appears, click the Build button.
  3. In the Data Link Properties window, select Microsoft Jet 4.0 OLE DB Provider and click the Next button.
  4. Click the ellipsis button (...) to browse to the Northwind database. Click Open once you have selected the file.
  5. Click the OK button to close the window and fill in the Connection String.
  6. In the Query field, enter the following SQL query.
    SQL Query
    Copy Code
    SELECT ShipCountry, SUM(Freight) AS FreightSum FROM Orders GROUP BY ShipCountry
  7. Click OK to save the data source.

To configure the appearance of the Chart

  1. Select the Chart control and at the bottom of the Properties window, select the Customize command. See Properties Window for further details on accessing commands.
  2. In the Chart Designer dialog that appears set the following. 

    Chart Areas

    1. Click the Axes bar on the left to expand it.
    2. Click Axis X, and on the Common tab in the pane to the right, type Country in the Title textbox and set the Font size to 12.
    3. On the Labels tab, select the Staggered Labels checkbox to avoid overlapping labels and set the Text angle property to 45.

    4. Click Axis Y on the left, and on the Common tab in the pane to the right, type Freight in the Title textbox and set the Font size to 12.

    Titles

    1. Click the Titles bar on the left to expand it. In the list of titles, the header is selected by default.
    2. In the Caption textbox, type Simple Bar Chart and increase the Font size to 14.
    3. In the list of titles to the left, select the footer and delete it by clicking the Delete icon on top of the list.

    Series

    1. Click the Series bar on the left. The Series1 is selected by default.
    2. In the Data Binding box, set X (Name) to ShipCountry, and set Y to FreightSum.
    3. In the list of series to the left, select Series2 and Series3 and delete them by clicking the Delete icon on top of the list.

    Legend

    1. Click the Legend bar on the left to expand it. The defaultLegend is selected by default.
    2. On the Common tab, clear the Visible checkbox to hide the legend.
  3. Click Finish to exit the Chart Designer.

To view the report

OR

See Also

Concepts