ReportRegularColumn Structure

Use the ReportRegularColumn structure to return column properties for a regular column used in an analysis.

The ReportRegularColumn structure is used in ReportEditingService Service.

Note:

System wide default column properties that apply to any of the report columns are returned in the report column properties.

ReportRegularColumn Structure Fields

Fields Description

String ID

Specifies the column identifier of the report column

String tableHeading

Specifies the table heading of the report column

String columnHeading

Specifies the column heading of the report column

Boolean hidden

If set to TRUE, the column is hidden. If set to FALSE, the column is displayed.

String sqlFormula

Specifies the column formula of the report column

Boolean measure

If set to TRUE, the report column is a measure. If set to FALSE, the report column is an attribute column.

aggrRule ReportColumnAggrRule

If the column contains aggregated data, this value specifies the type of aggregation used in the column.

ColumnAggregationRule Values

This structure specifies the default aggregation rule for the column.

The following list shows the aggregation functions available:

  • Default

  • Server

  • Sum

  • Average

  • Count

  • CountDistinct

  • Max

  • Min

  • None

  • ServerAggregate

  • Unknown