Data Formatting
You can set data formatting for the report via XML configuration file.
Values Formatting
To set values formatting the <format type="number"> tag is used. The following parameters of values formatting can be set:
- thousandsSeparator - thousands separator, by default it is space.
- decimalSeparator - decimal separator, by default it is ".".
- decimalPlaces - how many decimals to show in the fractional part on a number, afler the decimal separator, by default it is -1, which means "no formatting".
- maxDecimalPlaces - to show not more decimals than this property in the fractional part on a number, by default it is -1, which means "no formatting".
- maxSymbols - max number of symbols in cell. By default it is 20.
- currencySymbol - the symbol which is shown near the value (currency symbol, hours, percent, etc.), by default it is empty string.
- currencySymbolAlign - the alignment of the currency symbol. It can be left or right, by default it is left.
- nullValue - how to show null values in grid, by default it is empty string.
- infinityValue - how to show infinity values in grid, by default it is "Infinity" string.
<format type="number">
<param name="thousandsSeparator"><![CDATA[ ]]></param>
<param name="decimalSeparator"><![CDATA[.]]></param>
<param name="decimalPlaces">-1</param>
<param name="maxDecimalPlaces">-1</param>
<param name="maxSymbols">20</param>
<param name="currencySymbol"></param>
<param name="currencySymbolAlign">left</param>
<param name="nullValue"><![CDATA[]]></param>
<param name="infinityValue"><![CDATA[Infinity]]></param>
</format>