Crosstab dislays no data, but has the correct formatting

[dchan_1]

I have a crosstab report that appears to be displaying correctly as far as the number of cells, however no data appears to show.  I think this could be a diplay formatting issues but I couldn't identify the correct property to adjust.

I have attached the jrxml and the output of a screenshot of the pivot table vs the what is being displayed in the report.  Any point in the right direction would be greatly appreciated!

--JRXML--

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0  -->
<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="sub_UserID" language="groovy" pageWidth="561" pageHeight="792" columnWidth="561" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isFloatColumnFooter="true" resourceBundle="CCMSv4" uuid="d30a7e1c-142e-4988-a14b-80397c22412a">
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <property name="ireport.jasperserver.url" value="https://chidevmt2.columncloud.com:9443/jasperserver-pro/"/>
    <property name="ireport.jasperserver.user" value="superuser"/>
    <property name="ireport.jasperserver.report.resource" value="/organizations/organization_1/ccms/sub/sub_RP_Statistics.jrxml"/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="BIA QA"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <property name="com.jaspersoft.studio.unit." value="pixel"/>
    <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
    <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
    <property name="ireport.jasperserver.reportUnit" value="/organizations/organization_1/ccms/Reports/Reporting_Party_Report"/>
    <import value="com.columnit.bitools.*"/>
    <template><![CDATA["repo:CCMS_StyleTemplate.jrtx"]]></template>
    <style name="Crosstab_CH" mode="Opaque" backcolor="#F0F8FF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Crosstab_CT" mode="Opaque" backcolor="#005FB3">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Crosstab_CD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <parameter name="Record_Key" class="java.lang.String">
        <defaultValueExpression><![CDATA[]]></defaultValueExpression>
    </parameter>
    <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"/>
    <queryString>
        <![CDATA[sELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.CPD_Description as 'Desc'
    ,p.CHK_Unknown
    ,'CPD' as 'FORM'
    ,'Anonymous' as 'Classification'
FROM COL_COPA_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party%' AND p.CPD_Description LIKE '%Anonymous%' AND p.CHK_Unknown is not null AND p.Status = 0
UNION
SELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.Person_Description as 'Desc'
    ,p.CHK_Unknown
    ,'NON_CPD' as 'FORM'
    ,'Anonymous' as 'Classification'
FROM COL_COPA_Non_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party%' AND p.Person_Description LIKE '%Anonymous%' AND p.CHK_Unknown is not null AND  p.Status = 0
UNION
SELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.CPD_Description as 'Desc'
    ,p.CHK_Unknown
    ,'CPD' as 'FORM'
    ,'Unknown' as 'Classification'
FROM COL_COPA_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party%' AND NOT(p.CPD_Description LIKE '%Anonymous%') AND p.CHK_Unknown is not null AND  p.Status = 0
UNION
SELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.Person_Description as 'Desc'
    ,p.CHK_Unknown
    ,'NON_CPD' as 'FORM'
    ,'Unknown' as 'Classification'
FROM COL_COPA_Non_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party%' AND NOT(p.Person_Description LIKE '%Anonymous%') AND p.CHK_Unknown is not null AND  p.Status = 0
UNION
SELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.CPD_Description as 'Desc'
    ,p.CHK_Unknown
    ,'CPD' as 'FORM'
    ,'Third Party' as 'Classification'
FROM COL_COPA_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party: Third Party' AND p.Status = 0
UNION
SELECT
    c.Record_ID
    ,c.Intake_Opened_Date
    ,year(dateadd(s,c.Intake_Opened_Date,'19700101')) as 'Create Year'
    ,p.Tier_2
    ,p.Person_Description as 'Desc'
    ,p.CHK_Unknown
    ,'NON_CPD' as 'FORM'
    ,'Third Party' as 'Classification'
FROM COL_COPA_Non_CPD p
JOIN COL_CASE_Case c
ON c.Record_Key = p.Parent_Record_Key
WHERE p.Tier_2 LIKE 'Reporting Party: Third Party' AND p.Status = 0]]>
    </queryString>
    <field name="Record_ID" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="Record_ID"/>
    </field>
    <field name="Intake_Opened_Date" class="java.lang.Integer">
        <property name="com.jaspersoft.studio.field.label" value="Intake_Opened_Date"/>
    </field>
    <field name="Create Year" class="java.lang.Integer">
        <property name="com.jaspersoft.studio.field.label" value="Create Year"/>
    </field>
    <field name="Tier_2" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="Tier_2"/>
    </field>
    <field name="Desc" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="Desc"/>
    </field>
    <field name="CHK_Unknown" class="java.lang.Integer">
        <property name="com.jaspersoft.studio.field.label" value="CHK_Unknown"/>
    </field>
    <field name="FORM" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="FORM"/>
    </field>
    <field name="Classification" class="java.lang.String">
        <property name="com.jaspersoft.studio.field.label" value="Classification"/>
    </field>
    <summary>
        <band height="103">
            <crosstab>
                <reportElement x="9" y="3" width="542" height="100" uuid="bb905bc8-fcae-4403-97ba-03f64a4dc936">
                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                    <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/>
                    <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/>
                    <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/>
                    <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/>
                </reportElement>
                <rowGroup name="Classification" width="60" totalPosition="End">
                    <bucket class="java.lang.String">
                        <bucketExpression><![CDATA[$F{Classification}]]></bucketExpression>
                    </bucket>
                    <crosstabRowHeader>
                        <cellContents mode="Opaque" style="Crosstab_CH">
                            <textField>
                                <reportElement x="0" y="0" width="60" height="20" uuid="ad59a582-77ce-4892-acb4-0671cc9a3994"/>
                                <textFieldExpression><![CDATA[$V{Classification}]]></textFieldExpression>
                            </textField>
                        </cellContents>
                    </crosstabRowHeader>
                    <crosstabTotalRowHeader>
                        <cellContents mode="Opaque" style="Crosstab_CT">
                            <staticText>
                                <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="5e099a7c-2a78-40ca-8bf7-042b7c46cbb3"/>
                                <text><![CDATA[Total Classification]]></text>
                            </staticText>
                        </cellContents>
                    </crosstabTotalRowHeader>
                </rowGroup>
                <columnGroup name="Create Year" height="20" totalPosition="End">
                    <bucket class="java.lang.Integer">
                        <bucketExpression><![CDATA[$F{Create Year}]]></bucketExpression>
                    </bucket>
                    <crosstabColumnHeader>
                        <cellContents mode="Opaque" style="Crosstab_CH">
                            <textField>
                                <reportElement x="0" y="0" width="60" height="20" uuid="3a71cf75-3957-4234-a1c9-be8df24f261d"/>
                                <textFieldExpression><![CDATA[$V{Create Year}]]></textFieldExpression>
                            </textField>
                        </cellContents>
                    </crosstabColumnHeader>
                    <crosstabTotalColumnHeader>
                        <cellContents mode="Opaque" style="Crosstab_CT">
                            <staticText>
                                <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="313f9702-312e-4b9a-8f6c-0106dc55d5a3"/>
                                <text><![CDATA[Total Create Year]]></text>
                            </staticText>
                        </cellContents>
                    </crosstabTotalColumnHeader>
                </columnGroup>
                <measure name="Classification_MEASURE" class="java.lang.Integer" calculation="Count">
                    <measureExpression><![CDATA[$F{Classification}]]></measureExpression>
                </measure>
                <crosstabCell width="60" height="20">
                    <cellContents mode="Opaque" style="Crosstab_CD">
                        <textField>
                            <reportElement x="0" y="0" width="60" height="20" uuid="c2eedc58-9b6a-424a-87a2-1dad19d17676"/>
                            <textFieldExpression><![CDATA[$V{Classification_MEASURE}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabCell>
                <crosstabCell width="60" height="20" columnTotalGroup="Create Year">
                    <cellContents mode="Opaque" style="Crosstab_CT">
                        <textField>
                            <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="bf318bae-7b17-49e6-9cae-97fa3c38c1d2"/>
                            <textFieldExpression><![CDATA[$V{Classification_MEASURE}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabCell>
                <crosstabCell width="60" height="20" rowTotalGroup="Classification">
                    <cellContents mode="Opaque" style="Crosstab_CT">
                        <textField>
                            <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="66f55d46-7f5c-4065-a164-0e0b08bbf671"/>
                            <textFieldExpression><![CDATA[$V{Classification_MEASURE}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabCell>
                <crosstabCell width="60" height="20" rowTotalGroup="Classification" columnTotalGroup="Create Year">
                    <cellContents mode="Opaque" style="Crosstab_CT">
                        <textField>
                            <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="4baa910a-7b83-4bfc-ac1b-e841fac656f5"/>
                            <textFieldExpression><![CDATA[$V{Classification_MEASURE}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabCell>
            </crosstab>
        </band>
    </summary>
</jasperReport>