Report Column

This tag is used to define a report column.

Attributes

Name	Description	Values
fieldname	The column field name.	Any
width	The column width.	Any. The total of all fields should be 100.
widthType	The column width type.	PERCENTAGE
header	The column header.	Any
alias	The column alias.	Any. This will determine the value of the fieldname.
hidden	Defines if the column is hidden or not.	1 = Yes

Example

Column

Column

<column>
	<fieldname>ACCOUNTSRECEIVABLE.ACCRECNUM || ' - ' ||
	CASE
	WHEN CONTACTINFORMATION.CITYPE = 'COMPANY'
	THEN CONTACTINFORMATION.CICOMPANYNAME
	WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 1
	THEN CONTACTINFORMATION.CIFIRSTNAME || ' ' || CONTACTINFORMATION.CILASTNAME
	WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 2
	THEN CONTACTINFORMATION.CILASTNAME|| ' ' || CONTACTINFORMATION.CIFIRSTNAME
	WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 3
	THEN CONTACTINFORMATION.CIFIRSTNAME || ' ' || COALESCE (CONTACTINFORMATION.CIMIDDLENAME || ' ','') || '' || CONTACTINFORMATION.CILASTNAME
	WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 4
	THEN CONTACTINFORMATION.CILASTNAME|| ' ' || COALESCE (CONTACTINFORMATION.CIMIDDLENAME || ' ','') || '' || CONTACTINFORMATION.CIFIRSTNAME
	END
	</fieldname>
	<alias>ACCOUNTSRECEIVABLE</alias>
	<width>9</width>
	<widthType>PERCENTAGE</widthType>
	<header>Accounts Receivable</header>
</column>