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 7 Page Report and in the Name field, rename the file as rptMultipleLayout.
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 CustomerData.
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 OrdersList. 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 customerorders

4. Click the Validate DataSet icon at the top right hand corner above the Query box to validate the query.
   
   
5. Click OK to close the dialog. Your data set and queried fields appear as nodes in the Report Explorer.

1. Click the design surface to select the page, go to the properties window and set the FixedLayout - Grouping property to =Fields!SalesID.Value. See Grouping in a FixedPage to understand grouping further.
2. In the Report Explorer, right-click the Embedded Images node to select Add Embedded Image.
   OR
   Alternatively, you can also select the Embedded Images option by clicking the Add (+) icon at the top on the Report Explorer.
   This opens the Open dialog where you can select an image to embed in the report.
3. Drag and drop the embedded image, which now appears as a node in the Report Explorer, onto the Page 1 design surface and in the properties window set its Location property to 0in, 0in.
4. From the Visual Studio toolbox, drag the following controls from the ActiveReports 7 Page Report tab, drop it onto the Page 1 design surface and set the following properties in the properties window.

   Controls

   Control	Properties
   Textbox	Color: DarkSlateBlue Font: Normal, Arial, 11pt, Bold Location: 0in, 1in Size: 2in, 0.25in TextAlign: Center Value: 5473 Sidelong Street
   Textbox	Color: DarkSlateBlue Font: Normal, Arial, 11pt, Bold Location: 0in, 1.25in Size: 2in, 0.25in TextAlign: Center Value: Siler City, NC. 27344
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 0in, 2in Size: 1in, 0.25in TextAlign: Right Value: Sales Date :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 0in, 2.25in Size: 1in, 0.25in TextAlign: Right Value: Sales ID :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 3in, 2in Size: 1.5in, 0.25in TextAlign: Right Value: Customer Name :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 3in, 2.25in Size: 1.5in, 0.25in TextAlign: Right Value: Address :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 3in, 2.50in Size: 1.5in, 0.25in TextAlign: Right Value: City :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 3in, 2.75in Size: 1.5in, 0.25in TextAlign: Right Value: Country :
   Textbox	Font: Normal, Arial, 10pt, SemiBold Location: 0in, 4in Size: 1.5in, 0.25in TextAlign: Right Value: Account Number:
   Table	BorderStyle: Solid FixedSize: 6.5in, 2in Location: 0in, 5in OverflowName: OverflowPlaceHolder1 Note: Set this property after you add the OverflowPlaceHolder1 control to the design surface to handle the data that exceeds the fixed size of the Table data region. RepeatHeaderOnNewPage: True Size: 6.5in, 0.75in

5. From the Report Explorer drag and drop the following fields onto the Page 1 design surface and set the following properties in the properties window.

   Fields

   Field	Properties
   SaleDate	Format: D Location: 1in, 2in Size: 2in, 0.25in TextAlign: Left
   SalesID	Location: 1in, 2.25in Size: 2in, 0.25in TextAlign: Left
   FirstName	Location: 4.5in, 2in Size: 2in, 0.25in TextAlign: Left
   Address1	Location: 4.5in, 2.25in Size: 2in, 0.25in TextAlign: Left
   City	Location: 4.5in, 2.5in Size: 2in, 0.25in TextAlign: Left
   Country	Location: 4.5in, 2.75in Size: 2in, 0.25in TextAlign: Left
   AccountNumber	Location: 1.5in, 4in Size: 2in, 0.25in TextAlign: Left

6. Hover your mouse over the columns of the Table Details row to access the field selection adorner and set the following fields in the table cells along with their properties.

   Cell	Field	Properties
   Left Cell	Title	BorderStyle: Solid TextAlign: Center
   Middle Cell	Quantity	BorderStyle: Solid TextAlign: Center
   Right Cell	Price	BorderStyle: Solid Format: c TextAlign: Center

   This automatically places an expression in the details row and simultaneously places a static label in the header row of the same column.

7. Select the Table Header row and set the following properties in the properties window.

   Property Name	Value
   BackgroundColor	Silver
   Font	Normal, Arial, 11pt, Bold
   RepeatOnNewPage	True
   TextAlign	Center

8. Set the properties of the following cells on the Table Footer row through the properties window.

   Cell	Properties
   Middle Cell	Font: Normal, Arial, 10pt, Bold TextAlign: Right Value: Total:
   Right Cell	Font: Normal, Arial, 10pt, Bold Format: c TextAlign: Center Value: =Sum(Fields!Price.Value)

9. In the Report Explorer, expand the Common Values node and drag and drop the Page N of M (Section) field onto the Page 1 design surface and set its Location property to 0in, 8in in the properties window.

1. Click the New tab to add a new page to the report layout. This page is named Page 2 by default.
2. From the Visual Studio toolbox, drag the following controls from the ActiveReports 7 Page Report tab, drop it onto the Page 2 design surface and set the properties in the properties window.

   Controls

   Control	Properties
   Textbox	Font: Normal, Arial, 12pt, Bold Location: 0in, 1in Size: 2.625in, 0.25in TextAlign: Right Value: Account Details:
   Textbox	Font: Normal, Arial, 12pt, Bold Location: 2.625in, 1in Size: 3.25in, 0.25in Value: =Fields!FirstName.Value + ", " + Fields!AccountNumber.Value
   OverflowPlaceHolder	Location: 0in, 2in
   Textbox	Location: 1.75in, 5in Size: 3in, 0.25in TextAlign: Center Value: Thank You For Your Business!

3. In the Report Explorer, expand the Common Values node and drag and drop the Page N of M (Section) field onto the Page 2 design surface and set its Location property to 0in, 8in in the properties window.

• Click the preview tab to view the report.

OR

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