Skip to main content

Data source headers

Customise the headers of a data source​

After you've created a data source, you can override the title of any of its headers (columns). This works for any data source type, including constant data sources, which have a single header named Value by default.

This is especially useful when working with multiple data sources containing similarly-named attributes, e.g. Title, Geometry, Description. By customising the headers with more specific titles, it makes it easier to select the correct ones when adding controls to the layout of a report document!

For AQS data sources, you can also customise how a header reports data that points to multiple values, e.g. the Team Members attribute on a Teams item.

Change header settings​

To change the header settings of a data source in the Report Builder:

  1. On the Data Sources tab, select a saved data source, then Header settings.

    alt text

  2. Select a header from the list. Each header has its attribute/property code listed beneath its current title.

    alt text

  3. Fill in the following fields as needed and then select Save.

    • Title - enter a distinct name that clearly identifies this header to anyone who works on the document layouts of this report. If necessary, they can edit the layout so the header appears with another title when a report is generated.

    • Aggregation types - only applies to headers representing a join attribute on an AQS data source:

      • Count - display the total number of items that the join attribute points to (used by default).

      • Take One - display the value of the attribute on a single random item that the join attribute points to.

      For example, imagine a header that represents the Title attribute of multiple Jobs items, linked to by an asset's Tasks attribute. If set to "Count", the header displays X items. If set to "Take One", the header displays JOB-XXXX.

  4. Select Save in the Headers list, then Save at the bottom of the data source to finish.