ReportDimension Table
The following table describes the attributes used to add a dimension to a static report.
Attribute name | Data type | Constraint | Default | Description |
ReportID | int | NOT NULL | None | ID of the report the dimension is associated with. |
AggregationType | tinyint | None | 0 | Maps to aggregation types used by the CalcRenderer object. |
DimensionType | tinyint | NOT NULL | None | 0 = Column 1 = Row 2 = Measure |
DisplayName | nvarchar (128) | NULL | None | Name displayed in the user interface. |
FieldName | nvarchar (128) | NOT NULL | None | Field name in report query result. |
Ordinal | tinyint | NOT NULL | None | Used to specify the user interface rendering order. |