File: sales2.xml

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<REPORT>
	<TITLE>Sales Report</TITLE>
	<BACKGROUND_COLOR>#FFFFFF</BACKGROUND_COLOR>
	<PAGE BORDER="1" SIZE="25" CELLSPACING="0" CELLPADDING="5" WIDTH="500">
		<HEADER>
			<ROW>
				<COL COLSPAN="5">John Doe Enterprises</COL>
			</ROW>
			<ROW>
				<COL COLSPAN="5">Sales Report</COL>
			</ROW>
		</HEADER>		
		<FOOTER>
			<ROW>
				<COL ALIGN="RIGHT" COLSPAN="4">page total</COL>
				<COL ALIGN="LEFT" NUMBERFORMATEX="2" TYPE="EXPRESSION">$this->getSum("value")</COL>
			</ROW>
		</FOOTER>		
	</PAGE>
	<GROUPS>
		<GROUP NAME="maingroup">
			<FIELDS>
				<ROW>
					<COL>id</COL>
					<COL>name</COL>
					<COL>city</COL>
					<COL>product</COL>
					<COL>value</COL>
				</ROW>
			</FIELDS>
		</GROUP>
	</GROUPS>
</REPORT>