In Wyn Enterprise, Banded List is a collection of free-form bands where you can place other report controls. By default, the Banded List consists of three bands: a header, a footer, and a details band. You can add multiple numbers of bands to the Banded List. A report control bound to the Banded List in the details band repeats itself for every row of data. The header and footer bands render data once at the beginning and end of the Banded List. The header and footer are used to place details such as titles and grand totals.
In this help article, you will find information on the following:
The Banded List control is described below,
To add a Banded List control to a report, navigate to the Report Designer and follow the below instructions:
Drag and drop the Banded List control onto the design area from the Designer Toolbar.
Using the Inspector Panel on the right side of your screen, customize the appearance of the Banded List control. See the Inspector Panel Properties section for more information on the properties of the Banded List control. You can also customize the properties of the Header, Details, and Footer bands using the Inspector Panel.
In the below example, a Banded List is created for a product order summary. The header band has a textbox with a static value, Products, the details band has a table with Product ID, Product Name, and Units Ordered, and the footer band has the sum of total units ordered.
The banded list control on the report designer area is shown in the below image:
On preview, the banded list appears in the report as shown in the below image:
With the Banded List control, you can group the Details band. Use one of the following two methods to add groups to a banded list:
From the Groups editor, right-click on the option and select the Group >> Insert Group option from the context menu. Or,
Drag and drop a field you wish to group by from the Data Panel onto the Group Editor.
You can customize the name, group expressions, and other details of the groups by clicking the group and using the Inspector Panel. The Inspector Panel properties of a group are described in the below tables:
In a Banded List, you can arrange the data in nested groups. To insert a child group,
Right-click the parent group name in the Group Editor and select the Group >> Insert Group option from the context menu. Or,
Drag and drop a field from the Data Panel onto the Group Editor. A new group will be added to the Group editor with the existing groups.
To delete or remove a group from the Banded List control, right click on the group name in the Group editor and click the Delete option from the context menu.