id

a unique ID that allows the columnGroup to be referenced by the application and by the report.

type

specifies the format, width and alignment of the column.Types are:

1. PERCENT
2. MONEY - rounds to the nearest dollar
3. CURRENCY - shows 2 decimal places
4. DESCRIPTION
5. TOTAL
6. NUMBER
7. VALUE
8. TITLE
9. TEXT
10. DATE - formats as a date, left aligned by default
11. TIME - formats as time, right aligned by default
12. DURATION - formats as hours, minutes and seconds

titleBackgroundColor

defines the background color of the column title.

data

defines the subject formula.

metric

defines the metric formula.

title

defines the column title.

period

defines the period of the column:

1. YTD (year to date)
2. MONTH
3. WEEK
4. DAY

addPeriods

adds/removes the specified number of periods.

width

how much of the page width the column utilizes.

backgroundColor

defines the background color using hex codes.

opacity

gives the background colour an opacity as a decimal between 0 and 1.

total

Specifies how the total will be calculated for this column.  Totals are only displayed for numeric type columns.  The default is SUM.  Options are:

1. SUM
2. AVERAGE
3. MIN
4. MAX

format

Allows the format of the cell to be set.  The format uses a .NET formatting code for decimals and dates. Examples are:

1. Decimals: N, 0.#, 0.00
2. Date/time: d MMM yyyy, HH:mm
3. Duration: h:mm (for 1:30) or h.m (for 1.5)

A format string may contain three parts separated by ; to specify the format of positive numbers, negative numbers and zero.  For example:

1. ‘N;(N);-’ - this will display negative numbers using brackets and zero values as a dash

wrap

Controls the wrap on a cell.  By default, cells will not wrap and overflow will be hidden. Options are:

1. wrap - words wrap to the next line
2. no-wrap - words do not wrap to the next line

vertical-align

Sets the vertical alignment of text in a cell.  By default, all text is middle aligned.  Options are:

1. top
2. bottom
3. middle