# Create Address Labels in Page Report

This topic explains how to create an address label report using a List data region.

## Content

With Page reports, you can create an address label report using a List data region.

> type=note
> **Note**: The report connects to NWIND.db file that can be downloaded from [GitHub](https://github.com/activereports/Samples19/tree/main/Data/).

The final report will look as shown.

![Address Labels Page Report](https://cdn.mescius.io/document-site-files/images/b298aea2-8cb8-4a0f-be88-4f54aa263ebd/images/tutorial-page-create-address-labels-final.png)

### Create a Report

In the ActiveReports Designer, create a new Page Report.

### Bind Report to Data

1. As you create a new report, the **Report Data Source** dialog appears for you to configure the report data connection. You can also access this dialog by right-clicking the Data Sources node in the Report Explorer and then selecting the **Add Data Source** option.
2. In the dialog, select the **General** page and enter a name for the data source.
3. Select 'SQLite Provider'. See [Configure ActiveReports using Config file](/activereportsnet/docs/devops/customization/configure-ar) for more information.
4. Enter the following Connection String similar to the following based on the location of the nwind.db file:

    ```plaintext
    data source= C:\data\nwind.db;
    ```
5. Click OK.
6. In the **DataSet** dialog that appears, set the Name as 'DataSet1'.
7. Go to the **Query** page and enter the following query in the Query textbox :

    ```sql
    Select * from Customers order by ContactName
    ```
8. Click the **Validate** **DataSet** icon ![Validate DataSet Icon](https://cdn.mescius.io/document-site-files/images/b298aea2-8cb8-4a0f-be88-4f54aa263ebd/images/design-reports/validate-query-button.png) at the top right hand corner above the Query box to validate the query. If there is no warning, it means the query is validated. Then click **OK** to close the dialog.

### Design Report Layout

1. Drag and drop **List** data region onto the design surface.
2. Go to Report Explorer, expand **DataSet1** node and drag and drop the following fields inside the List data region, one below the other, with their **Value** property set to the following fields:
    * =Fields!ContactName.Value
    * =Fields!Address.Value
    * =Fields!City.Value
    * =Fields!Phone.Value
3. From the toolbox, drag and drop the **Barcode** control below =Fields!Phone.Value field, inside the List data region, and set its **Value** property to =Fields!PostalCode.Value.
4. Select **List** data region and from the Properties panel, set the following:
    * **GrowDirection**: Column
    * **RowsorColumnsCount**: 4
5. Ensure that the **DataSetName** property of the List data region is set to 'DataSet1'.
6. You will also need to adjust the **FixedSize** and the **Size** of the List data region to accommodate the data in the specified columns and control the number of records displayed on each page.
7. Set the **BackgroundColor** property of the list to say, 'MistyRose'.
    ![Address Labels Page Report at Design](https://cdn.mescius.io/document-site-files/images/b298aea2-8cb8-4a0f-be88-4f54aa263ebd/images/tutorial-page-create-address-labels-design.png)
8. Improve the appearance of the report.

### Preview Report

The final report is shown at the beginning of this page.

## See Also

[List](/activereportsnet/docs/report-authors/report-controls/report-controls-page-rdl-report/list)

[Overflow Placeholder (Page report only)](/activereportsnet/docs/report-authors/report-controls/report-controls-page-rdl-report/overflowplaceholder)