= $P{dateStart}
AND SEND_DT <= $P{dateEnd}
AND ($X{IN,CH.CAMPAIGN_INITIATIVE,param_CAMPAIGN_INITIATIVE_2} OR $X{IN,'--ALL INITIATIVES--',param_CAMPAIGN_INITIATIVE_2})
) AS PERCENT
FROM (
SELECT TARGET_ID,COUNT(PROMO_HIST_ID) AS SENT_IND
FROM S_V_F_PROMOTION_HISTORY_EMAIL PH
INNER JOIN S_V_D_CAMPAIGN_HIERARCHY CH ON PH.TOUCHPOINT_EXECUTION_ID = CH.TOUCHPOINT_EXECUTION_ID
WHERE 1=1
AND SEND_DT >= $P{dateStart}
AND SEND_DT <= $P{dateEnd}
AND ($X{IN,CH.CAMPAIGN_INITIATIVE,param_CAMPAIGN_INITIATIVE_2} OR $X{IN,'--ALL INITIATIVES--',param_CAMPAIGN_INITIATIVE_2})
GROUP BY TARGET_ID
) A
GROUP BY
SEND_RANK
) X
RIGHT OUTER JOIN
(
SELECT 1 AS SEND_RANK, '1' AS SENT_IND
UNION
SELECT 2 ,'2-5'
UNION
SELECT 3 ,'6-10'
UNION
SELECT 4 ,'11-15'
UNION
SELECT 5 ,'16-20'
UNION
SELECT 6 ,'21-30'
UNION
SELECT 7 ,'31-50'
UNION
SELECT 8 ,'51-75'
UNION
SELECT 9 ,'76-100'
UNION
SELECT 10, '101 OR MORE'
) Z
ON Z.SEND_RANK = X.SEND_RANK
ORDER BY Z.SEND_RANK ASC]]>
<band height="87" splitType="Stretch">
<staticText>
<reportElement x="652" y="0" width="100" height="20" uuid="17f9a6b4-43bd-4f27-80d0-f310c9fd403b"/>
<text><![CDATA[Version: 1.1.0]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="328" height="40" forecolor="#FFFFFF" backcolor="#812990" uuid="c7de8123-f522-4d55-8199-26ecf6080857"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="24" isBold="true"/>
</textElement>
<text><![CDATA[Average Emails Received]]></text>
</staticText>
<staticText>
<reportElement x="0" y="60" width="118" height="20" uuid="0f8513fa-66d3-4f8c-8fc4-e88aaa1fa6c8"/>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[Date Range:]]></text>
</staticText>
<textField>
<reportElement x="118" y="60" width="634" height="20" uuid="2e35e0cd-fdd0-4774-8165-cf6649d28806"/>
<textElement>
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("MMM dd, yyyy").format($P{dateStart}) + " to " + new SimpleDateFormat("MMM dd, yyyy").format($P{dateEnd})]]></textFieldExpression>
</textField>
<textField>
<reportElement x="118" y="40" width="626" height="20" uuid="b7797c28-e7d6-46fb-9de3-98b8dc357727"/>
<textElement>
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[""+$P{param_CAMPAIGN_INITIATIVE_2}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="40" width="118" height="20" uuid="9517976a-be71-45e7-b59a-970b8026446a"/>
<textElement>
<font isBold="true"/>
</textElement>
<text><![CDATA[Campaign Initiative(s):]]></text>
</staticText>
</band>