1. Create a new Visual Studio project.
2. Select Add New Item from the Project menu.
3. Select ActiveReports 8 Page Report in the Add New Item dialog.
4. Rename the file to Sales.rdlx in the Name field and click Add. You now have a fixed page report called Sales.rdlx in the report designer.
5. Select Convert to CPL Report from the Report menu.

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

1. Right-click the Data Sources node in the Report Explorer and select Add Data Source option,

   OR

   Select Add Data Source on the Report Explorer using the Add button drop-down.

2. Enter a name for the data source in the Name field in Report Data Source Dialog, for example, SubReels.

3. Create a connection to the Reels database on this tab. See Connect to a Data Source for information on connecting to a data source.

1. Right-click the Parameters node in the Report Explorer and select the Add Parameter option,

   OR

   Select Parameter from the Add button drop-down.

2. Enter EmployeeID under Name.
3. Select Integer under Data type.
4. Click OK to close the dialog.

Add a parameter to the Parameters tab when adding a query parameter using the syntax required by your database. This will ensure that the parameter value is passed to the query from the Report Parameters collection.

1. Right-click the Data Source node in the Report Explorer and select the Add Data Set option

   OR

   Select Data Set from the Add button drop-down.

2. Enter a name for the dataset on the General page in the DataSet Dialog, for example, EmployeeSales. This dataset is a child node to the data source icon in the Report Explorer.
3. Enter EmployeeID under Parameter Name on the Parameters tab.
4. Enter =Parameters!EmployeeID.Value under Value on the Parameters tab.
5. Enter the following SQL query in the Query field on the Query tab of this dialog:

   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.

1. Drag a Table data region from the toolbox onto report body.
2. Set DataSetName property to EmployeeSales in the properties window.
3. Click inside the table to display the column and row handles along the top and left sides of the table.
4. Right-click the handle above the right most column and select Insert Column to the Right to add another column.
5. 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.35in
   Second	1.35in
   Third	1.35in
   Fourth	1.35in

   Tip: Usually it is easier to resize existing columns before adding new columns. This prevents the table from growing horizontally and pushing the report width beyond what fits on paper.

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

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

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

1. Drag the following field from the EmployeeSales dataset in the Report Explorer onto the first group-header row of the table.

   Data Field	Column Name	Property Name
   Name	TableColumn1	FontWeight: Bold

2. Select the first two cells in the first group header row using the Shift key and mouse.
3. Right-click and select MergeCells. This allows the employee name to span two columns in the table.
4. Select the row using the handle to the left of the first group header row, and set the BackgroundColor property to LightSteelBlue.
   

   Tip: It is often helpful to use colors when designing a report. Colors make identification of the various sections easier for troubleshooting while previewing.

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

   Value	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

6. Select the second group header row using the handle to the left of the table, and set the BackgroundColor property to LightGray.
7. Drag the following fields from the EmployeeSales dataset in the Report Explorer onto the detail row of the table. 

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

8. Select the textbox with the Quantity data field in the detail row of the table.
9. Change its Value property to =Sum(Fields!Quantity.Value) in the Properties pane. This adds the Sum aggregate to the expression for the field and shows a summary of the quantity field for each SalesID.
10. Select the textbox with the Total data field in the detail row of the table.
11. Change its Value property to =Sum(Fields!Total.Value) in the Properties pane. This adds the Sum aggregate to the expression for the field and shows a summary of the total field for each SalesID.
12. Drag the following fields from the EmployeeSales dataset in the Report Explorer onto the group footer row of the table. Notice that the value of fields dragged onto the group footer row automatically use the Sum aggregate function.

    Data Field	Column Name	Property Name
    Quantity	TableColumn3
    Total	TableColumn4	Format: Currency

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

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

14. Select the row using the handle to the left of the group footer row, and set the BackgroundColor property to LightGray.
15. Select the preview tab and enter, for example, 1035 for the Employee ID on the left, 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

16. Select Save on the File menu to save this file. This report functions as the subreport you use in the main report.

1. Select Add New Item from the Project menu.
2. Select ActiveReports 8 Page Report in the Add New Item dialog.
3. Rename the file to Employees.rdlx in the Name field and click Add. You now have a fixed page report called Employees.rdlx in the report designer.
4. Select Convert to CPL Report from the Report menu.

1. Right-click the Data Sources node in the Report Explorer and select Add Data Source option,

   OR

   Select Add Data Source on the Report Explorer using the Add button drop-down.

2. Enter a name for the data source in the Name field in Report Data Source Dialog, for example, MainReels.

3. Create a connection to the Reels database on this tab. See Connect to a Data Source for information on connecting to a data source.

1. Right-click the Data Source node in the Report Explorer and select the Add Data Set option

   OR

   Select Data Set from the Add button drop-down.

2. Enter a name for the dataset on the General page in the DataSet Dialog, for example, EmployeeInfo. This dataset is a child node to the data source icon in the Report Explorer.

3. Enter the following SQL query in the Query field on the Query tab of this dialog:

   SQL Query	Copy Code
   SELECT * FROM EmployeeInfo

4. Click the Validate DataSet icon to validate the query and to populate the Fields list.
5. Click OK. 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.