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 9 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.

1. From the toolbox, drag the ChartControl 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.

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.

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.

• Click the preview tab to view the report at design time.

OR

• Open the report in the Viewer. See Using the Viewer for further information.