Specifies the data, metric and dimension of the row data. A row can also have a column defined to override the data, metric or type of the column in the grid. This allows the data to come from a different source for that individual row in the column specified by the same id.
Attributes
id | a unique ID that allows the row to be referenced by the application and by the report. |
type | specifies the. Types are: - PERCENT
- GROUPS
- ACCOUNTS
- TOTAL
- VALUE
- DIMENSION
- TITLE - displays a title in the first column. Can either use data formula to load the title, or specify the title in the title attribute
- ROWGROUPTOTAL - adds a row that totals values in each column in the rowGroup
- SECTIONTOTAL - adds a row that totals values in each column in the section
- PAGETOTAL - adds a row that totals values in each column across the page
- REPORTTOTAL - adds a row that totals values in each column over the entire report
|
sortByColumn | sorts the rows by the specified column id if the type of row is ACCOUNTS or a dimension is specified. |
sortBy | sorts the rows by the specified data formula. This allows the row to be sorted by a value that isn’t displayed in a column. |
sortOrder | orders the row list either: - ASCENDING
- DESCENDING
|
value | row type VALUE looks for the value to be specified in the element. |
lineType | defines whether the data is DEBIT or CREDIT. |
description | the description that will display in the column of type DESCRIPTION. |
data | defines the data. |
style | defines the style for the row. |
metric | defines a metric for the data if undefined in the column. |
hideIfAllZero | If true, then the row will not be displayed if there is at least one numeric value and all numeric values are zero. If false, then the row will always be displayed. Defaults to true. |
title | If the rowtype is TITLE, then a title can be specified in the title attribute. |
Example
<moxydoc:rows>
<moxydoc:rowGroup id="Ops">
<moxydoc:row type="ACCOUNTS" data="EXP" sortByColumn="TotalCol" sortOrder="DESCENDING" lineType="DEBIT" />
<moxydoc:row type="TOTAL" description="NOPBT" data="REV.TRA - EXP + EXP.TAX" style="TOTAL1" />
<moxydoc:column id="description" data="INV#CON" />
<moxydoc:row type="PERCENT" description="Other Revenue" data="REV.OTH" />
<moxydoc:row type="TOTAL" description="Net Profit" data="if(REV.OTH[COUNT]=0,0,REV - EXP)" style="TOTAL1"/>
<moxydoc:row type="ROWGROUPTOTAL" style="TOTAL3" />
</moxydoc:rowGroup>
</moxydoc:rows>
Click to see Comments