jrscullin

September 12, 2017

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

Posts posted by jrscullin

I am getting an invalid JRXML when publishing

Activity

Products

Explore