jrscullin

I am getting an invalid JRXML when publishing

jrscullin posted a topic in Products

I get an error publishing a report that runs within Studio. error and jrxml below: org.apache.http.client.HttpResponseException: Invalid JRXML at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:106) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:125) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:52) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:49) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:550) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:328) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:184) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:62) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:303) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) JRXML <?xml version="1.0" encoding="UTF-8"?>  <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="ac_advanced_product_fee_tax_report_v" pageWidth="10040" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="10000" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="daf84dcd-cb3b-4db2-965c-2ed36fa438f5"> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.1" value="pageHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.2" value="pageFooter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.3" value="columnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1" value="columnHeader"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="AirCard Data Adapter"/> <property name="ireport.jasperserver.reportUnit" value="/Reports/AC_ADVANCED_PRODUCT_FEE_TAX_REPORT"/> <property name="ireport.jasperserver.url" value="https://opdev04.multiservice.com:8443/jasperserver-pro-5.6.1/services/repository/"/> <property name="ireport.jasperserver.user" value="jrscullin-ac|aircard"/> <style name="Crosstab Data Text" hTextAlign="Center" hImageAlign="Center"/> <style name="BandStyle"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{ROWCOUNT}.intValue()%new Integer(2).intValue() == 0)]]></conditionExpression> <style backcolor="#91E7EE"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{ROWCOUNT}.intValue()%new Integer(2).intValue() != 0)]]></conditionExpression> <style backcolor="#FFFFFF"/> </conditionalStyle> </style> <parameter name="VERSION_NUMBER" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["V1.1.GED.0.0"]]></defaultValueExpression> </parameter> <parameter name="TEMPLATE_VERSION_NUMBER" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["V1.1.AR.1.3"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[WITH columns AS (SELECT /*+ materialize */ * FROM (SELECT 1101 position, 19 type_group, 12000656 phrase FROM DUAL UNION ALL SELECT 1102, 18, 12000655 FROM DUAL UNION ALL SELECT 1103, 0, 12000262 FROM DUAL UNION ALL SELECT 1104, 1, 12001175 FROM DUAL UNION ALL SELECT 1105, 2, 12001176 FROM DUAL UNION ALL SELECT 1106, 4, 12003897 FROM DUAL UNION ALL SELECT 1107, 5, 12003899 FROM DUAL UNION ALL SELECT 1108, 6, 12003900 FROM DUAL UNION ALL SELECT 1109, 7, 12003900 FROM DUAL UNION ALL SELECT 1110, 8, 12004956 FROM DUAL UNION ALL SELECT 1111, 9, 12005101 FROM DUAL UNION ALL SELECT 1114, 16, 12004249 FROM DUAL UNION ALL SELECT 1115, 17, 12008345 FROM DUAL UNION ALL SELECT 1116, 24, 12008790 FROM DUAL UNION ALL SELECT 1118, 20, 12017394 FROM DUAL UNION ALL SELECT 1119, 21, 12017459 FROM DUAL UNION ALL SELECT 1120, 22, 12017460 FROM DUAL)), allp AS (SELECT rri.product_id, ring.product_group FROM r_product_ri rri, r_product_grouping ring, r_product_group_ri rgi WHERE rri.product_id = ring.product_id AND rgi.product_group = ring.product_group), allt AS (SELECT rri.tax_type_id, ring.tax_type_group FROM r_tax_type_ri rri, r_tax_type_grouping ring, r_tax_type_group_ri rgi WHERE rri.tax_type_id = ring.tax_type_id AND rgi.tax_type_group = ring.tax_type_group), allf AS (SELECT rri.fee_type_id, ring.fee_type_group FROM r_fee_type_ri rri, r_fee_type_grouping ring, r_fee_type_group_ri rgi WHERE rri.fee_type_id = ring.fee_type_id AND rgi.fee_type_group = ring.fee_type_group), allnsn AS (SELECT rri.product_id, pdm.nsn_code, pdm.desc_code, pdm.contract, pdm.discounted, pdm.ground_service FROM r_product_ri rri, product_to_desc_map pdm WHERE rri.product_id = pdm.product_id(+)), da AS (SELECT rri.product_id, da.entry_ts FROM r_product_ri rri, dml_audit da WHERE da.table_id = 7 AND da.operation = 'I' -- this Substr just takes all characters infront of the | da.primary key is in product_id|card_type AND rri.product_id = SUBSTR (da.primary_key, 1, INSTR (da.primary_key, '|', 1, 1) - 1) -- takes all characters after the | (i.e. the card type should be 7 or 8) AND ( SUBSTR (da.primary_key, INSTR (da.primary_key, '|', -1, 1) + 1) = 7 OR SUBSTR (da.primary_key, INSTR (da.primary_key, '|', -1, 1) + 1) = 8)), la_nsn_w_noncon AS ( SELECT product_id, 1001 position, 12017628 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.nsn_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'N') GROUP BY product_id), la_nsn_w_discount AS ( SELECT product_id, 1002 position, 12017629 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.nsn_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'N') GROUP BY product_id), la_nsn_w_noncon_gs AS ( SELECT product_id, 1003 position, 12031293 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.discounted = 'N' AND aln.ground_service = 'Y') GROUP BY product_id), la_nsn_w_discount_gs AS ( SELECT product_id, 1004 position, 12031294 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.discounted = 'Y' AND aln.ground_service = 'Y') GROUP BY product_id), la_nsn_w_contract AS ( SELECT product_id, 1005 position, 12017630 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'Y' AND aln.nsn_code IS NOT NULL) GROUP BY product_id), la_desc_w_noncon AS ( SELECT product_id, 1006 position, 12017631 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'N') GROUP BY product_id), la_desc_w_discount AS ( SELECT product_id, 1007 position, 12017632 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'N') GROUP BY product_id), la_desc_w_noncon_gs AS ( SELECT product_id, 1008 position, 12031295 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'Y') GROUP BY product_id), la_desc_w_discount_gs AS ( SELECT product_id, 1009 position, 12031296 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'Y') GROUP BY product_id), la_desc_w_contract AS ( SELECT product_id, 1010 position, 12017633 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'Y' AND aln.desc_code IS NOT NULL) GROUP BY product_id), all_nsn_desc AS (SELECT * FROM la_nsn_w_noncon UNION ALL SELECT * FROM la_nsn_w_discount UNION ALL SELECT * FROM la_nsn_w_noncon_gs UNION ALL SELECT * FROM la_nsn_w_discount_gs UNION ALL SELECT * FROM la_nsn_w_contract UNION ALL SELECT * FROM la_desc_w_noncon UNION ALL SELECT * FROM la_desc_w_discount UNION ALL SELECT * FROM la_desc_w_noncon_gs UNION ALL SELECT * FROM la_desc_w_discount_gs UNION ALL SELECT * FROM la_desc_w_contract), products AS (SELECT (SELECT FW_Phrase_P.Text (12000593) FROM DUAL) source, rpr.product_id code, (SELECT FW_Phrase_P.Text (rpr.phrase) FROM DUAL) descr, rpr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (rpcr.phrase) FROM DUAL) classification, rpr.internal int, DECODE (rctpra.product_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_product_ri rctpra, r_product_category_ri rpcr, r_product_ri rpr, da WHERE rpr.product_category_id = rpcr.product_category_id AND rpr.product_id = rctpra.product_id(+) AND rctpra.card_type(+) = 7 AND da.product_id(+) = rpr.product_id), fees AS (SELECT (SELECT FW_Phrase_P.Text (12000994) FROM DUAL) source, rftr.fee_type_id code, (SELECT FW_Phrase_P.Text (rftr.phrase) FROM DUAL) descr, rftr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (12000994) FROM DUAL) classification, rftr.internal int, DECODE (rctfra.fee_type_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_fee_ri rctfra, r_fee_type_ri rftr, (SELECT rri.fee_type_id, da.entry_ts FROM r_fee_type_ri rri, dml_audit da WHERE da.table_id = 8 AND rri.fee_type_id = da.primary_key AND operation = 'I') da WHERE rftr.fee_type_id = rctfra.fee_type_id(+) AND rctfra.card_type(+) = 7 AND rftr.fee_type_id = da.fee_type_id(+)), taxes AS (SELECT (SELECT FW_Phrase_P.Text (12000993) FROM DUAL) source, rttr.tax_type_id code, (SELECT FW_Phrase_P.Text (rttr.phrase) FROM DUAL) descr, rttr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (12000993) FROM DUAL) classification, rttr.internal int, DECODE (rcttra.tax_type_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_tax_ri rcttra, r_tax_type_ri rttr, (SELECT rri.tax_type_id, da.entry_ts FROM r_tax_type_ri rri, dml_audit da WHERE da.table_id = 9 AND rri.tax_type_id = da.primary_key AND operation = 'I') da WHERE rttr.tax_type_id = rcttra.tax_type_id(+) AND rcttra.card_type(+) = 7 AND da.tax_type_id(+) = rttr.tax_type_id), rownums AS (SELECT rownum row_num, code FROM (SELECT code FROM products UNION ALL SELECT code FROM fees UNION ALL SELECT code FROM taxes ORDER BY code ) ) SELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, a.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, VALUE FROM (SELECT * FROM products UNION ALL SELECT * FROM fees UNION ALL SELECT * FROM taxes) a JOIN rownums r ON a.code = r.code JOIN all_nsn_desc b ON a.code = b.product_id UNION ALL SELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, p.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allp.product_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN products p JOIN rownums r ON p.code = r.code LEFT JOIN allp ON allp.product_ID = p.code AND allp.product_group = c.type_group UNION ALL SELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, f.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allf.fee_type_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN fees f JOIN rownums r ON f.code = r.code LEFT JOIN allf ON allf.fee_type_id = f.code AND allf.fee_type_group = c.type_group UNION ALL SELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, t.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allt.tax_type_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN taxes t JOIN rownums r ON t.code = r.code LEFT JOIN allt ON allt.tax_type_id = t.code AND allt.tax_type_group = c.type_group ORDER BY code, position]]> </queryString> <field name="ROW_NUM" class="java.math.BigDecimal"/> <field name="SOURCE" class="java.lang.String"/> <field name="CODE" class="java.math.BigDecimal"/> <field name="DESCR" class="java.lang.String"/> <field name="SG_TEXT" class="java.lang.String"/> <field name="CLASSIFICATION" class="java.lang.String"/> <field name="INT" class="java.lang.String"/> <field name="VALID_AIR" class="java.lang.String"/> <field name="CREATION_TIME" class="java.sql.Timestamp"/> <field name="POSITION" class="java.math.BigDecimal"/> <field name="PHRASE" class="java.lang.String"/> <field name="VALUE" class="java.lang.String"/> <field name="TIMERUN" class="java.lang.String"/> <pageHeader> <band height="30"> <textField> <reportElement x="0" y="0" width="752" height="15" uuid="f75a3009-092b-49e7-b543-b5abf7ef1a07"/> <textElement textAlignment="Center" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA["AIR Card" + "u00AE"]]></textFieldExpression> </textField> <staticText> <reportElement x="150" y="15" width="452" height="15" uuid="8814dd0a-d26e-4401-a4cf-73c2091170ef"/> <textElement textAlignment="Center" verticalAlignment="Middle"> </textElement> <text><![CDATA[Advanced Product Fee Tax Report]]></text> </staticText> <textField pattern=""> <reportElement x="0" y="15" width="150" height="15" uuid="767b64ad-222c-4e3c-8750-346bf5f4a602"/> <textElement verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$F{TIMERUN}]]></textFieldExpression> </textField> <elementGroup> <textField> <reportElement x="602" y="15" width="108" height="15" uuid="d0c8b612-ad9b-4e32-9421-96e9281a173e"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="710" y="15" width="42" height="15" uuid="e9bdf76b-9c48-461a-b2b9-7bb05e509c02"/> <textElement verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </elementGroup> </band> </pageHeader> <pageFooter> <band height="20"> <textField> <reportElement mode="Opaque" x="225" y="0" width="302" height="20" uuid="e9ffbf79-fdca-4010-b204-a62a9930306f"/> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> </textElement> <textFieldExpression><![CDATA["US Government AIR Card" + "u00AE" + " Information//FOUO/"]]></textFieldExpression> </textField> <textField evaluationTime="Page"> <reportElement x="527" y="0" width="225" height="20" uuid="d187ece2-2027-48ad-85a4-f4cea6803c6d"/> <textElement textAlignment="Right" verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[" "]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="0" width="225" height="20" uuid="c9c86107-efa7-482f-90fb-db428d5bce8e"/> <textElement verticalAlignment="Middle"> </textElement> <textFieldExpression><![CDATA[$P{JASPER_REPORT}.getName() + " " + $P{VERSION_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="45" splitType="Stretch"> <crosstab> <reportElement x="0" y="0" width="10000" height="45" uuid="45eb6ab0-08ef-439f-8532-68a1a1295809"> <printWhenExpression><![CDATA[$V{REPORT_COUNT} > 0]]></printWhenExpression> </reportElement> <crosstabHeaderCell> <cellContents> <box> <pen lineWidth="3.0" lineStyle="Double"/> <topPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> <bottomPen lineWidth="3.0" lineStyle="Double" lineColor="#999999"/> <rightPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="50" height="30" uuid="cd075cb8-6149-43f8-9974-2b7da70b6b37"/> <box topPadding="2" leftPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[item Type]]></text> </staticText> <staticText> <reportElement x="50" y="0" width="40" height="30" uuid="fbe76095-55a3-4e22-85d8-8d2348ab4511"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[item Code]]></text> </staticText> <staticText> <reportElement x="90" y="0" width="150" height="30" uuid="41c03cad-3161-4a24-884d-3b13dcda342b"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[Product Description]]></text> </staticText> <staticText> <reportElement x="240" y="0" width="120" height="30" uuid="069d1d65-cd3a-4c7e-a8b6-3754ae7f2850"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[settlegate Text]]></text> </staticText> <staticText> <reportElement x="360" y="0" width="80" height="30" uuid="0c79ccc5-c15e-4748-a414-fb52ad7c28ce"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[Classification]]></text> </staticText> <staticText> <reportElement x="440" y="0" width="50" height="30" uuid="a4acf2c2-724f-4cf1-9df6-e1feb932e285"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> </textElement> <text><![CDATA[internal]]></text> </staticText> <staticText> <reportElement x="490" y="0" width="50" height="30" uuid="0d6c1bb4-97aa-4075-b8fc-50e333d0b7f2"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> </textElement> <text><![CDATA[Valid For AIR]]></text> </staticText> <staticText> <reportElement x="540" y="0" width="82" height="30" uuid="ae3a9079-76d1-4213-98d6-edc39ac28576"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> </textElement> <text><![CDATA[Creation Time]]></text> </staticText> </cellContents> </crosstabHeaderCell> <rowGroup name="ROWCOUNT" width="0"> <bucket class="java.math.BigDecimal"> <bucketExpression><![CDATA[$F{ROW_NUM}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents/> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents/> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="CODE" width="622"> <bucket class="java.math.BigDecimal"> <bucketExpression><![CDATA[$F{CODE}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="3" width="50" height="15" uuid="0dc746d5-72a9-48ac-ae29-0890315d03ef"/> <box topPadding="2" leftPadding="2" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{SOURCE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="50" y="3" width="40" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{CODE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="90" y="3" width="150" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{DESCR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="3" width="120" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{SG_TEXT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="360" y="3" width="80" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{CLASSIFICATION}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="440" y="3" width="50" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> </textElement> <textFieldExpression><![CDATA[$V{INT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="3" width="50" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> </textElement> <textFieldExpression><![CDATA[$V{VALID_AIR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="540" y="3" width="82" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" leftPadding="3" bottomPadding="2"/> <textElement> </textElement> <textFieldExpression><![CDATA[$V{CREATION_TIME}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents/> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="PHRASE" height="30"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{PHRASE}]]></bucketExpression> <orderByExpression><![CDATA[$V{POSITION}]]></orderByExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box> <bottomPen lineWidth="3.0" lineStyle="Double" lineColor="#999999"/> </box> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="120" height="30" uuid="0b4d14c5-f77a-4033-9f61-b226208a997b"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> </textElement> <textFieldExpression><![CDATA[$V{PHRASE}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents/> </crosstabTotalColumnHeader> </columnGroup> <measure name="SOURCE" class="java.lang.String"> <measureExpression><![CDATA[$F{SOURCE}]]></measureExpression> </measure> <measure name="DESCR" class="java.lang.String"> <measureExpression><![CDATA[$F{DESCR}]]></measureExpression> </measure> <measure name="SG_TEXT" class="java.lang.String"> <measureExpression><![CDATA[$F{SG_TEXT}]]></measureExpression> </measure> <measure name="CLASSIFICATION" class="java.lang.String"> <measureExpression><![CDATA[$F{CLASSIFICATION}]]></measureExpression> </measure> <measure name="INT" class="java.lang.String"> <measureExpression><![CDATA[$F{INT}]]></measureExpression> </measure> <measure name="VALID_AIR" class="java.lang.String"> <measureExpression><![CDATA[$F{VALID_AIR}]]></measureExpression> </measure> <measure name="CREATION_TIME" class="java.sql.Timestamp"> <measureExpression><![CDATA[$F{CREATION_TIME}]]></measureExpression> </measure> <measure name="POSITION" class="java.math.BigDecimal"> <measureExpression><![CDATA[$F{POSITION}]]></measureExpression> </measure> <measure name="VALUE" class="java.lang.String"> <measureExpression><![CDATA[$F{VALUE}]]></measureExpression> </measure> <crosstabCell width="120" height="18"> <cellContents> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="3" width="120" height="15" uuid="20dedff2-32fd-40e2-8f2a-edc9fe88e347"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> </textElement> <textFieldExpression><![CDATA[$V{VALUE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" columnTotalGroup="PHRASE"> <cellContents/> </crosstabCell> </crosstab> <staticText> <reportElement x="0" y="0" width="752" height="20" uuid="db2a4df4-57be-443b-90f3-ae6d2efbdb40"> <printWhenExpression><![CDATA[$V{REPORT_COUNT} == 0]]></printWhenExpression> </reportElement> <textElement verticalAlignment="Middle"> </textElement> <text><![CDATA[No data returned.]]></text> </staticText> </band> </summary> </jasperReport>

Sign In

jrscullin

Posts

Joined

Last visited

Content Type

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by jrscullin

I am getting an invalid JRXML when publishing

Activity

Products

Explore