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 Page Report and in the Name field, rename the file as ProfitsByGenre.
4. Click the Add button to open a new fixed page report in the designer.

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

1. In the Report Explorer, right-click the Data Sources node and select the Add Data Source option or select Data Source from the Add button.
   
2. In the Report Data Source Dialog that appears, select the General page and in the Name field, enter a name like ReportData.
3. On this page, create a connection to the Reels database. See Connect to a Data Source for information on connecting to a data source.

1. In the Report Explorer, right-click the data source node and select the Add Data Set option or select Data Set from the Add button.
2. In the DataSet Dialog that appears, select the General page and enter the name of the dataset as ProfitsByGenre. This name appears as a child node to the data source icon in the Report Explorer.
3. On the Query page of this dialog, in the Query field enter the following SQL query.

   SQL Query	Copy Code
   SELECT Profit, SalesID, SaleDate, GenreName FROM SalesByGenre WHERE (SalesID < 1090) AND (GenreName = "Comedy" OR GenreName = "Drama" OR GenreName = "Adventure") ORDER BY SalesID

4. Click the Validate DataSet icon at the top right hand corner above the Query box to validate the query.
   
5. On the Fields page, add a new field by clicking the Add (+) button above the fields list.
6. Set the Name to Month and the Value of the new field to =Fields!SaleDate.Value.Month
   This parses out the month from the date field.
7. Click OK to close the dialog. Your data set and queried fields appear as nodes in the Report Explorer.

1. From the toolbox, drag the Chart control onto of the report design surface.
2. In the wizard Select a Chart Type that appears, select the chart type Column and go to the Properties Window to set the following properties:

   Property Name	Property Value
   Location	0in, 0in
   Size	6.5in, 4.5in

3. Double-click inside the chart to display the UI along the top, right, and bottom of the chart to drop fields in.
4. From the Report Explorer, drag the Month field into the area below the chart labeled "Drop category fields here." This automatically binds the Month field to the X axis.
5. Right-click the month category group and select Edit to open the Chart Data - Category Groups dialog.
6. In the dialog that appears on the General page, go to the Label field and enter the following expression: =MonthName(Fields!Month.Value) and click OK to close the dialog.
7. From the ReportExplorer, drag the Profit field into the area above the chart labeled "Drop data fields here." This plots the profits to the Y axis of the chart.
8. In the Report Explorer, drag the GenreName field into the area to the right of the chart labeled "Drop series fields here." This sets the series to be charted in the chart area.
9. Right-click the genre series group and select Edit to open the Chart Data - Series Groups dialog.
10. In the dialog that appears on the General page, go to the Label field and enter the following expression: =Fields!GenreName.Value. This shows genre names in the legend.
11. Click OK to close the dialog.
12. Select the chart and at the bottom of the Properties Window, select the Chart Data command. See Properties Window for further details on accessing commands.
13. In the Chart Data dialog that appears, under Series Values go to the Value field and make sure it is set to =Sum(Fields!Profit.Value).

1. Select the chart and at the bottom of the Properties Window, select the Chart appearance command.
2. In the Chart Appearance dialog that appears set the following:

   Title Page

   On the Title page enter Profits by Genre in the Chart title text box and change the Size property to 14pt.

   Palette Page

   On the Palette page and select Light in the drop down list. This is a good color choice because it differentiates between genres without highlighting one of them unintentionally.

   Plot Area Page

   On the Plot Area page set the Background Fill Color > Fill Color to Silver.
3. Click OK to close the dialog.
4. Select the X-Axis label in the chart and at the bottom of the Properties Window, select the Property dialog command.
5. In the Chart X-Axis - Title dialog that appears set the following properties:

   Title Page

   On the Title page, in the X-Axis Title field remove the default "Axis X" text.

   Labels Page

   On the Labels page, set the Size property to 10pt.
6. Click OK to close the dialog.
7. Select the Y-Axis label in the chart and at the bottom of the Properties Window, select the Property dialog command.
8. In the Chart Y-Axis - Title dialog that appears set the following properties:

   Title Page

   On the Title page, in the Y-Axis Title field remove the default "Axis Y" text.

   Labels Page

   On the Labels page and in the Format code field, select Currency in the Format drop-down list. Set the Size property to 10pt.

   Scale Page

   On the Scale page and in the Minimum field enter 0 (zero). This sets the currency labels to start at zero on the Y axis.
9. Click OK to close the dialog.

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