V1
V1

Banded List

The Banded List is a collection of free-form bands. By default, it is composed of three bands: a header, a footer and a detail band. Bound report controls in the detail band repeat for every row of data. The header and footer rows render once at the beginning and end of the Banded List and are a good place for titles and grand totals.

Some properties of the Banded List control are described below. Note that you need to enable Advanced Properties Mode to view all properties.

Data

Data Set Name: Select a dataset to associate with the banded list. The drop-down list is populated with all of the datasets in the report's dataset collection.

Data Set Parameters: Add data set parameters to filter the data to display in reports at preview.

Filters: You need to provide following values to add a new filter to the collection:

  • Filter Expression: Enter the expression to use for evaluating whether data should be included in the group.

  • Operator: Select from the following operators to decide how to compare the expression to the left with the value to the right.

    • Equal - Only choose data for which the value on the left is equal to the value on the right.
    • Like - Only choose data for which the value on the left is similar to the value on the right. For more information on using the Like operator, see the MSDN Web site.
    • NotEqual - Only choose data for which the value on the left is not equal to the value on the right.
    • GreaterThan - Only choose data for which the value on the left is greater than the value on the right.
    • GreaterThanOrEqual - Only choose data for which the value on the left is greater than or equal to the value on the right.
    • LessThan - Only choose data for which the value on the left is less than the value on the right.
    • LessThanOrEqual - Only choose data for which the value on the left is less than or equal to the value on the right.
    • TopN - Only choose items from the value on the left which are the top number specified in the value on the right.
    • BottomN - Only choose items from the value on the left which are the bottom number specified in the value on the right.
    • TopPercent - Only choose items from the value on the left which are the top percent specified in the value on the right.
    • BottomPercent - Only choose items from the value on the left which are the bottom percent specified in the value on the right.
    • In - Only choose items from the value on the left which are in the array of values specified on the right. Selecting this operator enables the Values list at the bottom.
    • Between - Only choose items from the value on the left which fall between the pair of values you specify on the right. Selecting this operator enables two Value boxes instead of one.
  • Value: Enter a value to compare with the expression on the left based on the selected operator. For multiple values used with the Between operator, the lower two value boxes are enabled.

  • Filter Values: When you choose the In operator, you can enter as many values as you need in this list.

Layout

Style: Choose from the list of available styles and set to apply a style to the control.

Page Break: Specify where the page breaks on each instance of the list:
   Start - Inserts page break at start of the list.
   End - Inserts page break at end of the list.
   StartAndEnd - Inserts page break at both start and end of the list.

Prevent Orphaned Header: Indicates whether the orphaned header is displayed on the next page.

Prevent Orphaned Footer: Indicates whether the orphaned footer is displayed on the next page.

New Section: Select to indicate whether this banded list is in its own section with regards to pagination.

Keep Together: Indicates if the data inside the banded list is kept together on a single page if possible.

Consume White Space: Indicates that all white space in the banded list is consumed during report rendering when the banded list’s contents grow rather than preserving the minimum white space between the contents and the bounds of the banded list.

Clicking the banded list reveals the properties for each band - a header, a footer and a detail band.

Repeat On New Page: Repeats the header band on every page when the related details span multiple pages.

Can Grow: Select True to allow the data region to grow vertically to accommodate data.

Can Shrink: Select True to allow the data region to shrink if there is not enough data to fill it.

Page Break: Specify where the page breaks on each instance of the list:
   Start - Inserts page break at start of the list.
   End - Inserts page break at end of the list.
   StartAndEnd - Inserts page break at both start and end of the list.

Keep Together: Select True to have ActiveReportsJS attempt to keep all of the data in the band together on one page.

Details

Layout

Can Grow: Select True to allow the data region to grow vertically to accommodate data.

Can Shrink: Select True to allow the data region to shrink if there is not enough data to fill it.

Page Break: Specify where the page breaks on each instance of the list:
   Start - Inserts page break at start of the list.
   End - Inserts page break at end of the list.
   StartAndEnd - Inserts page break at both start and end of the list.

Keep Together: Select True to have ActiveReportsJS attempt to keep all of the data in the band together on one page.

Layout

Print At Bottom: Select to have the footer band print at the bottom of the page.

Repeat On New Page: Repeats the footer band on every page when the related details span multiple pages.

Can Grow: Select True to allow the data region to grow vertically to accommodate data.

Can Shrink: Select True to allow the data region to shrink if there is not enough data to fill it.

Page Break: Specify where the page breaks on each instance of the list:
   Start - Inserts page break at start of the list.
   End - Inserts page break at end of the list.
   StartAndEnd - Inserts page break at both start and end of the list.

Keep Together: Select True to have ActiveReportsJS attempt to keep all of the data in the band together on one page.

Group

Name: Enter a name for the group that is unique within the report. You can only use underscore (_) as a special character in the Name field. Other special characters such as period (.), space ( ), forward slash ('/'), back slash ('\'), exclamation (!), and hyphen (-) are not supported.

Group Expressions: Enter an expression to use for grouping the data. When a detail grouping is set, the value repeats for each distinct result of the grouping expression instead of for each row of data.

Page Break: Specify where the page break occurs relative to grouping on the list:
   Start - Inserts page break at start of the list.
   End - Inserts page break at end of the list.
   StartAndEnd - Inserts page break at both start and end of the list.

Parent: Enter an expression to use as the parent group in case of recursive hierarchies.

Label: Enter an expression to use as a label to represent this item in the table of contents (document map).

New Section: Indicates if the group constitutes its own page numbering section.