0)
AND (vw_employee_month.pay_group_id = '$P!{paygroupid}')
$P!{organd})
UNION
(SELECT vw_employee_banking.entity_id, vw_employee_banking.employee_id, vw_employee_banking.entity_name,
vw_employee_banking.bank_branch_code,
vw_employee_banking.bank_name,
vw_employee_banking.bank_branch_name,
vw_employee_banking.base_amount,
vw_employee_banking.bank_account,
vw_employee_banking.period_id,
vw_employee_banking.period_year, vw_employee_banking.period_month,
vw_employee_banking.bank_header,
vw_employee_banking.bank_address
FROM vw_employee_banking
WHERE (vw_employee_banking.period_id = '$P!{filterid}')
AND (vw_employee_banking.base_amount > 0)
AND (vw_employee_banking.pay_group_id = '$P!{paygroupid}')
$P!{organd})) as eb
ORDER BY eb.employee_id;]]>
<band height="269" splitType="Stretch">
<textField pattern="MMMMM dd, yyyy" isBlankWhenNull="false">
<reportElement key="textField-2" x="46" y="113" width="209" height="16" uuid="c7991a27-c320-41d7-84b5-3208595a66d0"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
</textField>
<image scaleImage="RetainShape">
<reportElement key="image-1" x="7" y="7" width="775" height="102" uuid="2520b014-4d59-45fc-ab07-1ac5cfa393e2"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<imageExpression><![CDATA[$P{reportpath} + "logo.jpg"]]></imageExpression>
</image>
<staticText>
<reportElement key="element-92" x="7" y="113" width="37" height="16" forecolor="#000000" uuid="3a3b0a5f-620c-4bd3-9310-d30435087509"/>
<box leftPadding="2" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10" isBold="false" pdfFontName="Helvetica"/>
</textElement>
<text><![CDATA[Date :]]></text>
</staticText>
<textField isBlankWhenNull="false">
<reportElement key="textField-4" x="7" y="135" width="770" height="130" uuid="ed11ffb2-33a4-4b1b-84c2-b1af681898d3"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement markup="html">
<font fontName="Times New Roman"/>
</textElement>
<textFieldExpression><![CDATA["Ref: HR/BK/" + $F{period_id} +
"<br>" + $F{bank_address} +
"<br><br>Dear Sir/Madam," +
"<br><br><b>RE: <u>Payroll Payments for " + $F{period_month}.trim() + ", " + $F{period_year} + "</u></b>" +
"<br><br>" + $F{bank_heading}]]></textFieldExpression>
</textField>
</band>
HR and OD Manager]]>