Datafield Sub-Elements
Elements, attributes, and possible values
<datafield>
Path: <datacolumn><datafield>
Contains the data field settings of the data column.
If extra fields are used on a drill-down sheet, do not define this element for the actual data columns. Otherwise drill-down data will not be shown correctly. For the comment column, this element can be defined.
Attributes
datasource: Defines the type of the column.
Possible values
report
input
celldrilldown
tr
type: Defines the type of data in the column.
Possible values:
numeric: The column contains numeric data.
extra: The column contains extra field data.
formulas: The column contains a formula.
comment: The column is used for comments.
trlink: The column is used in transparent reporting.
invdata: The column contains inventory data.
presentationtype: Defines how the data in the column is displayed on the template. The 'type' attribute defines how the data is saved.
Possible values:
formulas
Example:
<datafield presentationtype="formulas" type="numeric" datasource="input">
<numeric amount="unit" period="periodical"/>
</datafield>
In this example, the formula comes from the Excel sheet and its result is saved as a unit periodical figure.
<invdata>
Path: <datacolumn><datafield><invdata>
Defines the settings for a column that contains inventory data (<datafield type="invdata">).
Attributes
field: Defines the type of the field.
Possible values:
amount: The column is used for entering the inventory value sum.
margin: The column is used for entering the margin percent for the periods.
taxpcent0: The column is used for entering the tax percent for period 0.
taxpcent: The column is used for entering the tax percent used for other periods.
<extra>
Path: <datacolumn><datafield><extra>
Defines the code of the extra field (the DATAEXDEF_UDID value from the FMDATAEXDEF[TT] table). Used if <datafield type=extra>.
Attributes
field: Defines the extra field udid in the database.
<formulas>
Path: <datacolumn><datafield><formulas>
Contains the definitions of formulas in the data column
<formula>
Path: <datacolumn><datafield><formulas><formula>
Defines the formula for saving data. Note that in formulas defined in the XML file, the separator must be comma (not semicolon).
Attributes
type
Possible values:
all
Example:
AVERAGE([datacolumn_1]:[datacolumn_3],[datacolumn_6]:[datacolumn_8]) IF(([datacolumn1]
[ datacolumn2])=0,"",([datacolumn1][ datacolumn2]))
<numeric>
Path: <datacolumn><datafield><numeric>
Defines the settings of the column if <datafield type=numeric>.
Attributes
amount: Defines whether the amounts in the column are in unit or group currency. If the <currency> element is in use (in <datacolumn> or <area> settings), the value may be converted to a third currency or from unit currency to group currency. For more information, see <currency> and Currency Conversion.
Possible values:
unit
group
period: Defines whether the data in the column is periodical or cumulative.
Possible values:
periodical
cumulative
Variable %PERIOD REPRESENTATION%: The option selected in the report template Advanced Options tab will be used.
Examples for Datafield Settings
Example 1: Periodizing type sum
Example 2: Periodizing type pattern
Example 3: Periodizing type periodizable
Example 4: Report