In this article we will discuss how to create a band layout report with the Band Report Wizard.

To create a new report with this wizard:

Standalone Report Designer:

Select File | New | from the Telerik Report Designer File menu;

Click on the Band Report Wizard template. Create file dialog opens;

Choose a file name and directory. Click Save and the Band Report Wizard opens.

Visual Studio:

Create a new class library or use an existing one.
Verify that the targeted .NET framework version is .NET4(+), Full profile as Client profile is not supported.

Right-click the project context menu and select
Add | New Item | Telerik Report Q2 2015 Wizard
.
Enter a name for the report class and click the Add button to close the dialog. Select report wizard form opens.

Select the Band Report Wizard option from the list and click OK.

On the Choose Data Source page of the
Report Wizard, select Add New Data Source.

On the Choose Your Data Connection page
select a connection for the AdventureWorks database from the drop
down list. If there is no existing connection, choose a data provider and click
Browse to create a new connection.
When done click the Next button.

The Save the Connection String step
appears, where you can save the connection string in the application
configuration file if you want with the name you want. Click Next.

In the Add Table dialog select
"Product", "ProductInventory", "ProductPhoto" and "ProductProductPhoto"
from the list of tables. Note: You can hold down the control key
and click each of the tables to select them all at one time.

Click the Add button to close
the dialog.

On the Query Builder select
the fields shown in the figure below. In the Product
table select "Name", "ProductNumber" and "ReorderPoint".
In ProductPhoto select the "ThumbNailPhoto" column.
In the ProductInventory table select the "Quantity"
column.

Click the OK button to
close the dialog.

The Configure Data Source Command
step would show the generated statement. Clicking the
Next button would lead you to
the Preview Data Source Results
step, where you can preview the data. Click finish to return
to the Choose Data Source page
of the Report Wizard. On the next page choose
Standard Report Type and click the
Next button.

In the Add Table dialog select
"Product", "ProductInventory", "ProductPhoto" and "ProductProductPhoto"
from the list of tables. Note: You can hold down the control key
and click each of the tables to select them all at one time.

Click the Add button to close
the dialog.

On the Query Builder select
the fields shown in the figure below. In the Product
table select "Name", "ProductNumber" and "ReorderPoint".
In ProductPhoto select the "ThumbNailPhoto" column.
In the ProductInventory table select the "Quantity"
column.

Click the OK button to
close the dialog.

The Configure Data Source Command
step would show the generated statement. Clicking the
Next button would lead you to
the Preview Data Source Results
step, where you can preview the data. Click finish to return
to the Choose Data Source page
of the Report Wizard. On the next page choose
Standard Report Type and click the
Next button.

The Design Data Layout page
of the Report Wizard allows you to assign database fields
to sections of the report. The Report Wizard automatically
places and formats the database fields in the appropriate
report sections.

Select from the Available Fields
list on the left side of the page.

Select "Name", "ProductNumber", "ReorderPoint"
and "Quantity".

After selecting each field, click the
Detail button to add those
columns to the detail listing of the report.

Click the Next button.

On the Choose Report Layout
page of the Report Wizard unselect the
Adjust
report items to fit available space
checkbox.
Click the Next button.

On the Choose Report Style
page of the Report Wizard select "Civic" from the
Style Sheets list on the left
side of the page. Notice the style changes in the Preview
portion on the right side of the page.