<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="multi_group" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="af2ac93f-7e43-4e3a-ba7e-a1023aa60887">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<queryString language="SQL">
		<![CDATA[SELECT province, city, suburb FROM sa_provinces a
  right join sa_cities b on a.id = b.province_id
  right join sa_suburbs c on b.id = c.city_id
order by province, city, suburb]]>
	</queryString>
	<field name="province" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="city" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="suburb" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="province">
		<groupExpression><![CDATA[$F{province}]]></groupExpression>
		<groupHeader>
			<band height="23">
				<textField>
					<reportElement uuid="ff8dabf9-bb6e-4adf-8209-eaf1902bdac4" x="0" y="0" width="131" height="20"/>
					<textElement/>
					<textFieldExpression><![CDATA[$F{province}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="city">
		<groupExpression><![CDATA[$F{city}]]></groupExpression>
		<groupHeader>
			<band height="23">
				<textField>
					<reportElement uuid="609ad15c-b383-479a-8045-765b45196965" x="46" y="1" width="144" height="20"/>
					<textElement/>
					<textFieldExpression><![CDATA[$F{city}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="22" splitType="Stretch">
			<textField>
				<reportElement uuid="d1b64180-e0ca-4988-874a-98c69f6d23d6" x="131" y="0" width="178" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{suburb}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
