A column defining the treatment of the row data.
Attributes
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: - PERCENT
- MONEY - rounds to the nearest dollar
- CURRENCY - shows 2 decimal places
- DESCRIPTION
- TOTAL
- NUMBER
- VALUE
- TITLE
- TEXT
- DATE - formats as a date, left aligned by default
- TIME - formats as time, right aligned by default
- 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: - YTD (year to date)
- MONTH
- WEEK
- 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: - SUM
- AVERAGE
- MIN
- MAX
|
format | Allows the format of the cell to be set. The format uses a .NET formatting code for decimals and dates. Examples are:
- Decimals: N, 0.#, 0.00
- Date/time: d MMM yyyy, HH:mm
- 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:
- ‘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: - wrap - words wrap to the next line
- 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:- top
- bottom
- middle
|
Example
<moxydoc:columns>
<moxydoc:columnGroup id="Invoice" title="" >
<moxydoc:column id="date" type="DESCRIPTION" title="Date" metric="STARTDATE">
<moxydoc:drilldown report="Session" />
</moxydoc:column>
<moxydoc:column id="location" type="TEXT" metric="LOCATION" title="Location" />
<moxydoc:column id="sessionType" type="TEXT" metric="TYPE" title="Type" />
<moxydoc:column id="contact" type="TEXT" metric="DESCRIPTION" title="Name" />
<moxydoc:column id="duration" type="DURATION" metric="ENDDATE - STARTDATE" title="Duration" />
<moxydoc:column id="cost" type="MONEY" metric="COST" title="Charge" />
</moxydoc:columnGroup>
</moxydoc:columns>
Click to see Comments