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>
