= $P{Start Date}
AND a.activity_start_time <= date_add($P{End Date}, INTERVAL "23:59:59" HOUR_SECOND)
AND a.arch_short_name LIKE "act.customerAccount%item"
GROUP BY location.name
ORDER BY a.activity_start_time ASC]]>
<band height="79" splitType="Stretch">
<textField pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField" x="137" y="54" width="100" height="17"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement/>
<textFieldExpression class="java.util.Date"><![CDATA[$P{End Date}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement key="textField-1" x="363" y="36" width="100" height="18"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right"/>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField evaluationTime="Report" isBlankWhenNull="false">
<reportElement key="textField-2" x="467" y="36" width="73" height="18"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement/>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-1" x="20" y="0" width="520" height="24"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center">
<font size="18" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Distinct Active Clients By Year By Practice Location]]></text>
</staticText>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField" x="137" y="36" width="100" height="18"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement/>
<textFieldExpression class="java.util.Date"><![CDATA[$P{Start Date}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-48" x="38" y="37" width="87" height="17"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[Start Date]]></text>
</staticText>
<staticText>
<reportElement key="staticText-48" x="38" y="54" width="87" height="17"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[End Date]]></text>
</staticText>
</band>