Skip to main content

Creating Header and Summary Rows

  • Updated

Creating Header and Summary Rows

Header and Summary rows allow you to display data column summary information on the first (excluding the Column Header row) and/or last rows of a data table. You can customize these rows by adding individual Column Cell elements.

The easiest way to display summary information is to use special summary elements with each Data Table Column to be summarized and then create a header and/or summary row, as follows:

  1. Ensure that each Data Table Column to be summarized has a child Data Column Summary element, as shown above.
  2. Set its attributes to produce the desired summary of the desired column, as shown above.


  3. Select the parent Data Table element and add a Header Row or Summary Row element to the definition, as shown above.
  4. Set its Caption attribute to display a title in the first column of the header/summary row.
  5. When using a Summary Row and interactive paging, set its Last Page Only attribute to True to show the summary only on the last page of the data table, otherwise it will appear at the bottom of every page.

The example above show the typical result, with the summary row at the bottom.

The cells generated for the summary row automatically inherit the formatting and alignment of the columns above them.

A standard header or summary row works well when every data column contains summary information. However, for data tables with numerous columns and/or columns with non-numeric data, a customized header or summary row may be a better solution. Here's how to create a customized header:


  1. Ensure that each Data Table Column to be summarized has a child Data Column Summary element.
  2. Select the parent Data Table element and add a Header Row element to the definition.
  3. Beneath it, add one or more Column Cell elements.
  4. Add Label elements beneath the Column Cell elements to display the summary data and use the @Data token to retrieve the summarized values, using on the ID of the Data Column Summary elements you added. For example, @Data.avgDiscount~.

The formatting and alignment of the data table columns is not inherited when using Column Cell elements, so you must set these individually.

In the example shown above, the Header Row element has three Column Cell child elements, but the data table has four columns. This is handled by setting the first Column Cell element's Column Span attribute to span 2 columns, allowing for the difference.

Related articles