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 RDL Report and in the Name field, rename the file as Sales.rdlx.
4. Click the Add button to open a new RDL report in the designer.
5. In the Solution Explorer, select Sales.rdlx and set the Build Action property to Content and the Copy to Output Directory property to Copy Always.

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 Reels.
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 Parameters node and select the Add Parameter option or select Parameter from the Add button.
2. Under Name, enter EmployeeID.
3. Under Data type, select Integer.
4. Click OK to close the dialog.

When you add a query parameter using the syntax required by your database you must add a parameter to the Parameters page to ensure that the parameter value is passed to the query from the Report Parameters collection.

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 EmployeeSales. This name appears as a child node to the data source icon in the Report Explorer.
3. On the Parameters page under Parameter Name enter EmployeeID.
4. Under Value enter =Parameters!EmployeeID.Value
5. On the Query page of this dialog, in the Query field enter the following SQL query.

   SQL Query	Copy Code
   SELECT * FROM EmployeeSales

6. Click the Validate DataSet icon at the top right hand corner above the Query box to validate the query.
   
   
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 a Table data region onto the body of the report and go to the properties window to set the DataSetName property to EmployeeSales.
2. Click inside the table to display the column and row handles along the top and left sides of the table.
3. Right-click the handle above the rightmost column and select Insert Column to the Right to add another column. 
4. Click the column handle at the top of each column in turn to select it, and in the property grid, set the Width property as indicated in the table.

   Column	Width
   First	1.5in
   Second	1.5in
   Third	1.2in
   Fourth	1.55in

   Tip: In most cases it is easier to resize existing columns before adding new columns because this prevents the table from growing horizontally and pushing the report width beyond what will fit on paper.

5. Right-click the handle to the left of the table detail row and select Insert Group to open the Table-Groups dialog.
6. Under Expression select =Fields!EmployeeID.Value. This groups all details from each employee.
7. Change the Name to Employee and click OK to close the dialog. A grouping row is added to the table.

   Note: You cannot change the name of a table group until after you have set the expression.

8. Right-click the handle to the left of the table detail row and select Edit Group to access the Table-Detail Grouping dialog.
9. Under Expression select =Fields!SaleID.Value and click OK to close the dialog. This lists the total amount of each sale instead of listing each item sold within each SaleID.
10. Right-click the handle to the left of the grouping row and select Insert Row Below. We will use this new row for static labels that repeat at the top of each new group.
11. Right-click any handle to the left of the table and select Table Header to toggle off the table header.
12. Right-click any handle to the left of the table and select Table Footer to toggle off the table footer.
13. In the Report Explorer, select the Body node and go to the Properties window to set the Size property to 5.75in, 1in so that it fits inside the subreport control on the main report.

1. In the Report Explorer, from the EmployeeSales dataset, drag the following field onto the first group header row of the table.

   Data Field	Column Name	Property Name
   Name	TableColumn1	FontWeight: Bold

2. Use the Shift key and the mouse to select the first two cells in the first group header row, right-click and select Merge Cells. This allows the employee name to span two columns in the table.
3. Using the handle to the left of the first group header row, select the row and set the BackgroundColor property to LightSteelBlue.
   

   Tip: Even if you do not want to use colors in your finished report, it is often helpful to do so during the design of a report to make identification of the various sections easier for troubleshooting when you preview it.

4. Enter the following text into the cells in the second group header row of the table.

   Data Field	Column Name	Property Name
   Sale Date	TableColumn1	FontWeight: Bold TextAlign: Right
   Sale Number	TableColumn2	FontWeight: Bold TextAlign: Right
   Quantity	TableColumn3	FontWeight: Bold TextAlign: Right
   Total	TableColumn4	FontWeight: Bold TextAlign: Right

5. Using the handle to the left of the second group header row, select the row and set the BackgroundColor property to LightGray.
6. In the Report Explorer, drag the following fields from the EmployeeSales dataset onto the detail row of the table.

   Data Field	Column Name	Property Name
   Sale Date	TableColumn1	Format: Short date
   SaleID	TableColumn2
   Quantity	TableColumn3
   Total	TableColumn4	Format: Currency

7. In the detail row of the table, select the textbox with the Quantity data field and go to the Properties window to change the Value property to =Sum(Fields!Quantity.Value). This adds the Sum aggregate to the expression for the field and shows a summary of the quantity field for each SalesID.
8. In the detail row of the table, select the textbox with the Total data field and go to the Properties window to change the Value property to =Sum(Fields!Total.Value). This adds the Sum aggregate to the expression for the field and shows a summary of the total field for each SalesID.
9. In the Report Explorer, from the EmployeeSales dataset, drag the following fields onto the group footer row of the table.

   Data Field	Column Name	Property Name
   Quantity	TableColumn3	Value: =Sum(Fields!Quantity.Value)
   Total	TableColumn4	Format: Currency Value: =Sum(Fields!Total.Value)

10. Enter the following text into the indicated cell in the group footer row of the table.

    Text	Column Name	Property Name
    Employee Total:	TableColumn2	FontWeight: Bold TextAlign: Right

11. Using the handle to the left of the group footer row, select the row and in the BackgroundColor property select LightGray.
12. Go to the preview tab, enter 1035 for the Employee ID, and click the View Report button. You get a layout that looks similar to the following at design time and at runtime.

    Design Time Layout	Runtime Layout

13. From the File menu, select Save and save this file. This report functions as the subreport you use in the main report.

1. From the Visual Studio Project menu, select Add New Item.
2. In the Add New Item dialog that appears, select ActiveReports 9 Page Report and in the Name field, rename the file as Employees.rdlx.
3. Click the Add button to open a new fixed page report in the designer.
4. From the Report menu, select Convert to RDL Report.

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 Reels.
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 EmployeeInfo. 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 * FROM EmployeeInfo

4. Click the Validate icon to validate the query and to populate the Fields list.
5. Click OK to close the dialog. Your data set and queried fields appear as nodes in the Report Explorer.

The following steps demonstrate how you can add controls and create the main report:

To add a static label to the top of the main report

To add a List data region that repeats data for each city

To nest a second List data region that repeats data for each store within the city 

To nest a third List data region that repeats data for each employee in the store

To add a Subreport control to the main report

• Click the preview tab to view the report.

OR

• See Using the Viewer to display report in the Viewer at runtime.

Note: Click the + to the left of Sales Record to see the subreport.