[{"id":"a20f26ac-cd31-4e4d-9454-1e035b0f1587","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3604b8ce-1da0-413f-8274-7df0f7173573","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"7fce7040-1bb1-4a61-9fb7-2e19d569de50","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"0eb72dd3-8f8f-4039-93a8-500bbde2301e","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ac046cee-82b9-4edf-a642-ae6d7cb21ebf","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"75b66fd4-b740-443d-bc6e-1782048b60a6","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"dde44832-bb5c-45f3-8ebf-3badbc613cd9","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"43de3664-261b-4cf9-9945-fb519251f4c7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2f064d57-b088-4bc5-a628-4e0d7e1a0c65","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f290406b-ced1-4c52-abad-979160a79f6b","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1864834b-08ce-43f1-891b-c3cca6e04e95","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f96cfec1-420c-4ca7-ab0a-cab482731073","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3f2ea860-c764-43d8-ae3f-6e3b0314ce67","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"81eb70e8-f770-4384-9167-bc7c755ad052","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d0dff477-9f56-483a-a9fc-cab648905b41","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"793a62d7-460d-4699-9304-edb2941268ac","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2d6ebfad-f7d1-4cc5-8ba1-fdace3472056","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c8c7b5d5-f5bd-4b68-a12f-3aae9804a844","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"577a09da-dea1-42db-812f-4eeaa9274ece","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8ddd80d5-886f-41b8-8e3f-f73aa8146c8d","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e0909540-8bde-4587-bb4d-02445746db2a","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"464b8e03-462d-4aed-8818-05d32ec3bf00","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f235557b-9781-471f-bf03-38bae6e3e953","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"fd5d021d-0210-4d74-ba42-1a39ef14a385","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"548568fe-dbd1-4da5-a489-d9b3edf75329","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a0c823ed-e22b-493b-aded-4d201c0fa480","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d19bc9cd-ff53-4b0d-ab7e-a68c1497c4c6","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"94759fce-692f-4779-b5f3-fce5c58f242c","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"27658163-a479-432f-a192-dbed286beb3e","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
A Banded List
report item is a data region that visualizes the bound data by producing a series of sections called bands
. A band is the container for data visualizers such as a TextBox or Image arranged in a free-form layout fashion.
You can use the banded list to build a Banded Report
. Visit the Get Started With Banded Reports tutorial for more information.
You can add a Banded List
into a report by either double-click the corresponding item in the toolbox or drag-and-drop it to a report page area.
Expand to watch adding the Banded List in action
The following diagram depicts the default structure of the banded list designer that appears if you click anywhere inside its bounding box.
You can use one of two methods to load the general banded list configuration into the properties panel
Select the banded list item in the report explorer.
Click the Root handler
in the banded list designer.
The general configuration includes Base Report Item properties, Common Style Properties, Data Region properties, Visibility, Page Break, and the following specific properties.
If a banded list starts at the bottom of the page, then its header band could appear by itself. You can turn on the Prevent Orphaned Header
switch to move a "lonely" header to the next page so that it appears together with other sections.
Sometimes the footer band could appear by itself on the top of the page. You can turn on the Prevent Orphaned Footer
switch to move a previous section to the next page so that it appears together with a "lonely" footer.
The Keep together
flag determines whether a banded list always appears on a single page if it fits.
The Consume White Space
flag indicates whether banded list sections that can shrink in size should eliminate the whitespace.
The banded list consists of sections called bands
. Several band types serve different purposes but share common properties. You can click the Band Handler
in the banded list designer or anywhere inside the bounding box of a band to load its configuration into the properties panel.
The Height
is the vertical size, in length units, of a band at the design-time.
The Action
property determines the interactive action that occurs when a report reader clicks within the space occupied by a band.
The Can Grow
flag indicates whether a band can increase its height at preview-time to accommodate growing content, such as a long text.
The Can Shrink
flag indicates whether a band can shrink in height if there is more available space than the content takes. This property works together with the Consume White Space flag.
The Keep Together
flag indicates whether a band always appears on a single page if it fits.
The Page Break
property determines the location of page breaks generated by band instances.
None
- no page breaks are generated.
Start
- each band instance inserts the page break before displaying the content.
End
- each band instance inserts the page break after displaying the content .
StartAndEnd
- the combination of the Start
and End
options.
The Visibility configures a band's static or dynamic visibility.
The Header
appears at the beginning of a banded list. Also, if its Repeat On New Page
switch is on, it prints on every page taken by the banded list content. You could use the header band to display the title or the logo of a banded report. For instance, the Get Started with Banded Reports
demo contains the Employee Directory
textbox in the header band.
The Group Header
appears at the beginning of a group instance. Also, if its Repeat On New Page
switch is on, it prints on every page taken by the banded list content. You could use the group header band to display the group's field value or summary value. For instance, the Get Started with Banded Reports
demo groups employees by the department name and has the group header that prints on every page and contains the {DepartmentName}
textbox.
The Details
section repeats for each bound data set record that passed through the data set filters and data region filters. For instance, in the Get Started with Banded Reports
demo, the details band displays the name, title, email, phone and photo of each employee.
If a banded list has the grouping configured, then the details bands appear between the header and footer of the enclosing group instance.
The Group Footer
appears at the end of a group instance. Also, if its Repeat On New Page
switch is on, it prints on every page taken by the banded list content. You could use the group footer band to display summary values. Also, you could turn on the Print At Bottom
switch to ensure that the group footer always prints at the bottom of the page.
The Footer
band appears at the end of a banded list. Also, if its Repeat On New Page
switch is on, it prints on every page taken by the banded list content. You could use the footer band to display grand totals. Also, you could turn on the Print At Bottom
switch to ensure that the footer band always prints at the bottom of the page.
The banded list allows you to group Details
bands by one or multiple criteria. For instance, the Get Started with Banded Reports
demo groups the employee list by the department name. We recommend using the Group Editor
in the banded list designer to configure grouping.
You can use one of two methods to add a banded list group.
Right-click the <Details>
text in the Group Editor
and select the Group -> Insert Group
item in the context menu.
Drag and drop a field that you want to group by from the Data panel to the Group Editor
.
Expand to watch adding grouping by drag-and-drop in action
You can arrange data in a banded list with several nested groups. For instance, in the Get Started with Banded Reports
demo, employees within each department could be grouped by the job title.
To insert a child group, right-click the parent group name in the Group Editor
and select the Group -> Insert Group
item in the context menu. Alternatively, you can drag-and-drop a field from the data panel to the group editor that indicates the position of a newly added group relative to existing groups with the <New Group>
placeholder.
Also, you could delete a group or remove or add its header or footer by using the corresponding items of the context menu.
The Group Editor
enumerates group names that you can click to load their configuration into the properties panel.
The Group Name
is the group Id
that displayed in the group editor.
The Group Expressions
is the collection of bound field references or more advanced expressions. Distinct values of group expressions generate Group Instances
that consist of optional Group Header
and Group Footer
and the Details
bands. For instance, the Get Started with Banded Reports
demo has the {DepartmentName}
group expression. Consequently, the banded list generates 17 group instances.
The Label
expression determines the text of a group instance link in the Report Map. The Get Started with Banded Reports
demo uses this property.
The Filters Editor allows you to filter out certain group instances. For example, if we want to exclude the Sales
department from the Get Started with Banded Reports
demo's output, then we can add the following filter for the DepartmentName
group.
The Sort Expressions
is the collection of items that allows you to sort group instances. Each item consists of the expression and the sort direction. For example, in the Get Started with Banded Reports
demo, we could sort the DepartmentName
group instances in ascending or descending alphabetical order by using the {DepartmentName}
sort expression and required sort direction.
If a group instance starts at the bottom of the page, its Header
band could appear by itself. You can switch on the Prevent Orphaned Header
flag to move "lonely" group headers to the next page so that they appear together with the first Details
band of the group instance.
Sometimes, the Group Footer
band could appear by itself on the top of the page. You can switch on the Prevent Orphaned Footer
flag to move the last Details
band of the group instance to the next page so that it appears together with a "lonely" group footer.
The Keep together
flag ensures that the group instance always appears on a single page if it fits.
The Page Break
property determines the location of page breaks generated by group instances.
None
- no page breaks are generated.
Start
- each group instance inserts the page break before the Group Header
or the first Details
band.
End
- each group instance inserts the page break after the Group Footer
or the last Details
band.
StartAndEnd
- the combination of the Start
and End
options.
Between
- each group instance starts on the new page. The Get Started with Banded Reports
demo uses this option.
The Visibility property determines static or dynamic visibility of group instances.
The New Section
flag determines whether each group instance has its page numbering. Check the Global References documentation for more information.