pdk

Members

View Profile See their activity

Posts
1
Joined
October 13, 2023
Last visited
April 29

pdk's Achievements

Newbie (1/14)

Rare
Rare

Recent Badges

Reputation

Using Json data file given me a blank page, using same configure xml works

pdk posted a topic in Products

The xml and json files are pretty much exactly the same i run the report using the xml file adapter and it works, if i ran it using the json adapter it works. JSON i am selecting the file for the url, test is good, click finish. I also tried selecting create data source using this expression json, /Solution_IV/OP_Inv_Header or /Solution_IV or empty. Always get a blank document. Report ... <?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="OP Invoice" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6299c3bf-c6ee-4b14-8b4e-2a6ebc0c8ac2"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="xml"/> <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"/> <queryString language="JSON"> <![CDATA[/solution-IV/OP_Inv_Header]]> </queryString> <field name="INV_TYPE_SPACED" class="java.lang.String"> <fieldDescription><![CDATA[iNV_TYPE_SPACED]]></fieldDescription> </field> <field name="INV_TYPE_DESC" class="java.lang.String"> <fieldDescription><![CDATA[iNV_TYPE_DESC]]></fieldDescription> </field> <field name="INV_NUM" class="java.lang.String"> <fieldDescription><![CDATA[iNV_NUM]]></fieldDescription> </field> <field name="INV_DATE" class="java.lang.String"> <fieldDescription><![CDATA[iNV_DATE]]></fieldDescription> </field> <field name="PRINT_TIME" class="java.lang.String"> <fieldDescription><![CDATA[PRINT_TIME]]></fieldDescription> </field> <field name="ORDR_CUST_PO" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_CUST_PO]]></fieldDescription> </field> <field name="ORDR_SALES_NUM" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_SALES_NUM]]></fieldDescription> </field> <field name="ORDR_APPLY_TO" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_APPLY_TO]]></fieldDescription> </field> <field name="CUST_CODE" class="java.lang.String"> <fieldDescription><![CDATA[CUST_CODE]]></fieldDescription> </field> <field name="CUST_CONTACT" class="java.lang.String"> <fieldDescription><![CDATA[CUST_CONTACT]]></fieldDescription> </field> <field name="CUST_NAME" class="java.lang.String"> <fieldDescription><![CDATA[CUST_NAME]]></fieldDescription> </field> <field name="CUST_ADDR1" class="java.lang.String"> <fieldDescription><![CDATA[CUST_ADDR1]]></fieldDescription> </field> <field name="CUST_ADDR2" class="java.lang.String"> <fieldDescription><![CDATA[CUST_ADDR2]]></fieldDescription> </field> <field name="CUST_CITY" class="java.lang.String"> <fieldDescription><![CDATA[CUST_CITY]]></fieldDescription> </field> <field name="CUST_STATE" class="java.lang.String"> <fieldDescription><![CDATA[CUST_STATE]]></fieldDescription> </field> <field name="CUST_ZIP_CODE" class="java.lang.String"> <fieldDescription><![CDATA[CUST_ZIP_CODE]]></fieldDescription> </field> <field name="CUST_SHIP_TO_CONTACT" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_CONTACT]]></fieldDescription> </field> <field name="CUST_SHIP_TO_NAME" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_NAME]]></fieldDescription> </field> <field name="CUST_SHIP_TO_ADDR1" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_ADDR1]]></fieldDescription> </field> <field name="CUST_SHIP_TO_ADDR2" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_ADDR2]]></fieldDescription> </field> <field name="CUST_SHIP_TO_CITY" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_CITY]]></fieldDescription> </field> <field name="CUST_SHIP_TO_ZIP_COD" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_ZIP_COD]]></fieldDescription> </field> <field name="SREP_NAME" class="java.lang.String"> <fieldDescription><![CDATA[sREP_NAME]]></fieldDescription> </field> <field name="SHIP_DESC" class="java.lang.String"> <fieldDescription><![CDATA[sHIP_DESC]]></fieldDescription> </field> <field name="TERM_DESC" class="java.lang.String"> <fieldDescription><![CDATA[TERM_DESC]]></fieldDescription> </field> <field name="ORDR_COMMENT" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_COMMENT]]></fieldDescription> </field> <field name="PARM_MSG_LINE1" class="java.lang.String"> <fieldDescription><![CDATA[PARM_MSG_LINE1]]></fieldDescription> </field> <field name="PARM_MSG_LINE2" class="java.lang.String"> <fieldDescription><![CDATA[PARM_MSG_LINE2]]></fieldDescription> </field> <field name="PARM_MSG_LINE3" class="java.lang.String"> <fieldDescription><![CDATA[PARM_MSG_LINE3]]></fieldDescription> </field> <field name="SUB_TOTAL" class="java.lang.String"> <fieldDescription><![CDATA[sUB_TOTAL]]></fieldDescription> </field> <field name="ORDR_DISC_AMT" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_DISC_AMT]]></fieldDescription> </field> <field name="ORDR_FREIGHT" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_FREIGHT]]></fieldDescription> </field> <field name="ORDR_STAX" class="java.lang.String"> <fieldDescription><![CDATA[ORDR_STAX]]></fieldDescription> </field> <field name="BALANCE_DUE" class="java.lang.String"> <fieldDescription><![CDATA[bALANCE_DUE]]></fieldDescription> </field> <field name="CUST_SHIP_TO_STATE" class="java.lang.String"> <fieldDescription><![CDATA[CUST_SHIP_TO_STATE]]></fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="295" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <frame> <reportElement mode="Opaque" x="10" y="269" width="561" height="25" backcolor="#CBCACF" uuid="dc4b15a2-2744-452a-b464-c86a664c3fae"/> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> </frame> <textField> <reportElement x="480" y="0" width="100" height="15" uuid="d329e456-1629-4c2b-aed5-8dbe18ea934a"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{INV_NUM}]]></textFieldExpression> </textField> <textField> <reportElement x="377" y="0" width="100" height="15" uuid="be98c4ff-5ede-4213-9e67-e612b49276ed"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Invoice Number:"]]></textFieldExpression> </textField> <image> <reportElement x="10" y="1" width="140" height="109" uuid="61dc213e-7cd8-488d-ba31-b15ed663cbdd"/> <imageExpression><![CDATA["s4logo.png"]]></imageExpression> </image> <textField> <reportElement x="377" y="15" width="100" height="15" uuid="aa7a2975-4336-4ed6-a59a-686aed6e6516"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Invoice Date:"]]></textFieldExpression> </textField> <textField> <reportElement x="377" y="30" width="100" height="15" uuid="af8f8acf-7923-43d5-b4e2-e40100304790"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["PO Number:"]]></textFieldExpression> </textField> <textField> <reportElement x="379" y="45" width="100" height="15" uuid="dfa2da2e-243a-4e48-a043-d54cac82bf44"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Customer Code:"]]></textFieldExpression> </textField> <textField> <reportElement x="480" y="15" width="100" height="15" uuid="b856f36f-da90-4f5d-916e-fce44958fe1b"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{INV_DATE}]]></textFieldExpression> </textField> <textField> <reportElement x="480" y="30" width="92" height="15" uuid="8f5b88fe-c3ff-42a9-911b-8106f7da1350"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{ORDR_CUST_PO}]]></textFieldExpression> </textField> <textField> <reportElement x="480" y="45" width="100" height="15" uuid="197dff75-31a8-4ea0-bc22-66947fd6efe5"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{CUST_CODE}]]></textFieldExpression> </textField> <textField> <reportElement x="213" y="-5" width="146" height="20" uuid="cd9c6c83-a5d2-4e42-bfa8-5a2e0efafcc7"/> <textElement textAlignment="Center"> </textElement> <textFieldExpression><![CDATA[$F{INV_TYPE_SPACED}]]></textFieldExpression> </textField> <textField> <reportElement x="10" y="130" width="42" height="12" uuid="3fe3599c-fdae-4ee4-8b9a-97d575848d72"/> <textElement> </textElement> <textFieldExpression><![CDATA["Bill to:"]]></textFieldExpression> </textField> <textField> <reportElement x="50" y="130" width="160" height="12" uuid="e2782444-9a75-41a7-8eca-dfcaaa49eae3"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{CUST_CONTACT}]]></textFieldExpression> </textField> <textField> <reportElement x="290" y="130" width="40" height="12" uuid="8ecb882c-1e12-4635-ae13-d495434d2620"/> <textElement> </textElement> <textFieldExpression><![CDATA["Ship to:"]]></textFieldExpression> </textField> <textField> <reportElement x="50" y="142" width="100" height="12" uuid="480db052-a96f-4432-9989-fbba7916da5c"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{CUST_NAME}]]></textFieldExpression> </textField> <textField> <reportElement x="50" y="154" width="150" height="60" uuid="03e610ac-2b3f-4143-b5c1-436c0a8519fb"/> <textElement> </textElement> <textFieldExpression><![CDATA[($F{CUST_ADDR1} == " " ? "" : $F{CUST_ADDR1} + "n") + ($F{CUST_ADDR2} == " " ? "" : $F{CUST_ADDR2} + "n") + (($F{CUST_CITY}.trim().length() == 0) ? "" :$F{CUST_CITY} + ", ") + $F{CUST_STATE} + " " + $F{CUST_ZIP_CODE}.toString()]]></textFieldExpression> </textField> <textField> <reportElement x="340" y="154" width="150" height="60" uuid="762c72b6-eb4f-4a1c-86ed-88510c17e118"/> <textElement> </textElement> <textFieldExpression><![CDATA[($F{CUST_SHIP_TO_ADDR1} == " " ? "" : $F{CUST_SHIP_TO_ADDR1} + "n") + ($F{CUST_SHIP_TO_ADDR2} == " " ? "" : $F{CUST_SHIP_TO_ADDR2} + "n") + (($F{CUST_SHIP_TO_CITY}.trim().length() == 0) ? "" : $F{CUST_SHIP_TO_CITY} + ", ") + $F{CUST_SHIP_TO_STATE} + " " + $F{CUST_SHIP_TO_ZIP_COD}.toString()]]></textFieldExpression> </textField> <textField> <reportElement x="340" y="130" width="160" height="12" uuid="9ffc89a9-9c7b-4217-b19a-7521128ae1a8"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{CUST_SHIP_TO_CONTACT}]]></textFieldExpression> </textField> <textField> <reportElement x="340" y="142" width="160" height="12" uuid="ad89e772-0429-4525-aa83-b45d8b6cd76a"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{CUST_SHIP_TO_NAME}]]></textFieldExpression> </textField> <textField> <reportElement x="75" y="270" width="100" height="12" uuid="2838a7b6-96a9-4cbb-9ef7-41f28933d20d"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{SREP_NAME}]]></textFieldExpression> </textField> <textField> <reportElement x="340" y="280" width="100" height="12" uuid="ae24853a-ca72-4e2d-9917-bf527e4fde96"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{SHIP_DESC}]]></textFieldExpression> </textField> <textField> <reportElement x="75" y="282" width="100" height="12" uuid="5666d107-a8c9-438b-9199-ff78fd70d868"/> <textElement> </textElement> <textFieldExpression><![CDATA[$F{TERM_DESC}]]></textFieldExpression> </textField> <textField> <reportElement x="28" y="282" width="40" height="12" uuid="ac2a765b-f14b-435a-809d-894f2960063b"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Terms:"]]></textFieldExpression> </textField> <textField> <reportElement x="290" y="280" width="46" height="12" uuid="4a9c1c80-1da6-46f4-9efd-e84d485d2436"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Ship Via:"]]></textFieldExpression> </textField> <textField> <reportElement x="10" y="270" width="60" height="12" uuid="4b1a35a0-8f30-47fd-8bb9-1ac2ffab52da"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Sales Rep:"]]></textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="57" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <subreport> <reportElement x="10" y="-2" width="561" height="40" uuid="d198f587-4609-41a7-b9c6-ceb083b987a3"> <property name="local_mesure_unity" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="px"/> </reportElement> <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).dataSource("/Solution-IV/OP_Inv_Detail")]]></dataSourceExpression> <subreportExpression><![CDATA["OP_Invoice_Detail.jasper"]]></subreportExpression> </subreport> </band> </detail> <pageFooter> <band height="94"> <textField> <reportElement x="30" y="60" width="54" height="12" uuid="016e5997-6b6c-4aaf-afe1-7b2e22f65312"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Subtotal"]]></textFieldExpression> </textField> <textField> <reportElement x="19" y="80" width="58" height="12" uuid="fa7ee750-55c8-4ad1-a604-92cb9b9e506c"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA[$F{SUB_TOTAL}]]></textFieldExpression> </textField> <textField> <reportElement x="157" y="80" width="58" height="12" uuid="e82f7c17-a38f-444e-b2e3-b36010954e64"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA[$F{ORDR_DISC_AMT}]]></textFieldExpression> </textField> <textField> <reportElement x="161" y="60" width="54" height="12" uuid="cc1c1c9a-696b-4d60-b097-2005fc1a72fb"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Discount"]]></textFieldExpression> </textField> <textField> <reportElement x="281" y="60" width="54" height="12" uuid="1046fecc-6704-496b-8eb7-8772a1b58104"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Freight"]]></textFieldExpression> </textField> <textField> <reportElement x="281" y="80" width="58" height="12" uuid="bf5cd380-0057-4e60-95cf-f03d91bb219f"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA[$F{ORDR_FREIGHT}]]></textFieldExpression> </textField> <textField> <reportElement x="394" y="80" width="58" height="12" uuid="ead91503-f88e-491a-9eb5-ae2b8be559b9"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA[$F{ORDR_STAX}]]></textFieldExpression> </textField> <textField> <reportElement x="402" y="60" width="54" height="12" uuid="0cd7425c-24c4-43c4-a6a1-ed0d6e0540a8"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Sales Tax"]]></textFieldExpression> </textField> <textField> <reportElement x="502" y="60" width="54" height="12" uuid="4f240c63-20b4-4556-9f87-02c744e82d38"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA["Total Due"]]></textFieldExpression> </textField> <textField> <reportElement x="500" y="80" width="58" height="12" uuid="aa0f741f-7ca3-41f1-92b8-33b3efd734fd"/> <textElement textAlignment="Right"> </textElement> <textFieldExpression><![CDATA[$F{BALANCE_DUE}]]></textFieldExpression> </textField> <textField> <reportElement x="16" y="7" width="384" height="12" uuid="88895951-4ef9-463c-b92c-0fb350cd6f46"> <property name="local_mesure_unitheight" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{ORDR_COMMENT}]]></textFieldExpression> </textField> <textField> <reportElement x="16" y="20" width="383" height="12" uuid="9911486d-eba3-4b85-af20-42352f34bd0c"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{PARM_MSG_LINE1}]]></textFieldExpression> </textField> <textField> <reportElement x="16" y="32" width="383" height="12" uuid="b56ff945-0863-4d16-8432-92e34eecb078"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{PARM_MSG_LINE2}]]></textFieldExpression> </textField> <textField> <reportElement x="16" y="44" width="383" height="12" uuid="4b300c39-0f27-49f2-9cf7-9005fde7d91f"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement> </textElement> <textFieldExpression><![CDATA[$F{PARM_MSG_LINE3}]]></textFieldExpression> </textField> </band> </pageFooter> </jasperReport> JSon File { "Solution-IV": { "OP_Inv_Header": { "INV_TYPE_SPACED": "I N V O I C E", "INV_TYPE_DESC": "Invoice Number:", "INV_NUM": 297, "INV_DATE": "01/03/07", "PRINT_TIME": "10:06 AM", "ORDR_CUST_PO": 2000000, "ORDR_SALES_NUM": "", "ORDR_APPLY_TO": "", "CUST_CODE": "BLARG", "CUST_CONTACT": "John Doe", "CUST_NAME": "Customer Name Here", "CUST_ADDR1": "111 Road", "CUST_ADDR2": "", "CUST_CITY": "SomeCity", "CUST_STATE": "CA", "CUST_ZIP_CODE": 7787, "CUST_SHIP_TO_CONTACT": "", "CUST_SHIP_TO_NAME": "Test Name", "CUST_SHIP_TO_ADDR1": "Test Address 1", "CUST_SHIP_TO_ADDR2": "Shop Plaza", "CUST_SHIP_TO_CITY": "", "CUST_SHIP_TO_STATE": "", "CUST_SHIP_TO_ZIP_COD": "", "SREP_NAME": "Jane Doe", "SHIP_DESC": "Our Truck", "TERM_DESC": "Net 30 Days", "ORDR_COMMENT": "", "PARM_MSG_LINE1": "Thank you", "PARM_MSG_LINE2": "Come Again", "PARM_MSG_LINE3": "", "SUB_TOTAL": 118.4, "ORDR_DISC_AMT": 11.84, "ORDR_FREIGHT": 0, "ORDR_STAX": 7.46, "BALANCE_DUE": 114.02 }, "OP_Inv_Detail": [ { "ORDR_SEQ_NUM": 1, "ITEM_CODE": "71-B24150", "ITEM_DESC": "Bond 24" x 150'", "ORDR_QTY_SHIPPED": 2, "ORDR_ITEM_PRICE": 27.95, "ORDR_LINE_AMOUNT": 55.9 }, { "ORDR_SEQ_NUM": 2, "ITEM_CODE": "70-P10", "ITEM_DESC": "Bic-Matic Grip Mechanical Pencil", "ORDR_QTY_SHIPPED": 10, "ORDR_ITEM_PRICE": 5.25, "ORDR_LINE_AMOUNT": 52.5 }, { "ORDR_SEQ_NUM": 3, "ITEM_CODE": "90-110", "ITEM_DESC": "Delivery", "ORDR_QTY_SHIPPED": 1, "ORDR_ITEM_PRICE": 10, "ORDR_LINE_AMOUNT": 10 } ] }}

Sign In

pdk

Posts

Joined

Last visited

pdk's Achievements

Newbie (1/14)

Recent Badges

Reputation

Using Json data file given me a blank page, using same configure xml works

Activity

Products

Explore