Jump to content
We've recently updated our Privacy Statement, available here ×

bikerpfanne

Members
 View Profile  See their activity

  • Posts

    5

  • 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 bikerpfanne

    Subreport cascade with XML Datasource

    in Products

    Posted

    Hi all,

    I'm not able to solve really simple problem.  How can I iterate over List in SubReport included from another Subreport ?

    XML Example :

    <xmldata>

       <group> 

          <group><position></position></group>

          <group><position></position></group>

       </group>

       <group> 

          <group><position></position></group>

          <group><position></position></group>

       </group>

    </xmldata>

    Mainreport

    <queryString language="xPath">   <![CDATA[/xmldata/group]]></queryString>

    <detail>

    ...

    <subreport>

    <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/group")]]></dataSourceExpression><subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "reportGroup.jasper"]]></subreportExpression>

    </subreport>

    </detail>

    Subreport reportGroup works ... :

    <detail>

    ..

    <subreport><subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "reportPosition.jasper"]]></subreportExpression>

    </subreport>

    </detail>

    reportPosition  has detail section to show all positions of a Group...

    Now we got Groups and Groups of groups in Report. OK. Positions is emtpy every time.

    Everything works Fine in iReport, Jasper Studio and as Java Application . Groups, Groups og Groups and Positions are printed.

     

    Now I try to show Positiosn of every Group ...

    I add following in reportGroup : 

    <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")]]></dataSourceExpression>

    It works in iReport and in Jasper Studio. BUT does not work as Java Application. With following error:

    [http-nio-8081-exec-6] net.sf.jasperreports.engine.fill.JRFillSubreport.prepare Fill 1: exception
     net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")
        at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284)
        at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:316)

     

    Could somebody explain me , why?

    I tried JREmptyDataSource, just to be sure... wit works in iReport, and Studio but not in Java Application

    [http-nio-8081-exec-7] net.sf.jasperreports.engine.fill.JRFillSubreport.prepare Fill 1: exception
     net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new JREmptyDataSource()
        at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284)

     

    I tried to pass XML Document like this

    parameters.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, document);

    JasperFillManager.fillReport("<path...>/mainReport.jasper", parameters);

    and  like this

    JRXmlDataSource jr = new JRXmlDataSource(document,"/xmldata/group");

    JasperFillManager.fillReport("<path...>/mainReport.jasper", parameters, jr);

     

    So it schould be a problem to pass Datasource from Details section in subreport to another subreport. 

    Actually really simple and standard issue or not?

    Regards Leo

     

    see also  https://community.jaspersoft.com/questions/1141426/problem-passing-datasource-one-subreport-another-subreport

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Problem with passing Datasource from one Subreport to another Subreport

    in Products

    Posted

    OK some bad news :(  I just want to show , that XML Data, and xPath selects does not have any meaning here 

    I tried to defined following Data Source Expression  ... in reportGroup 

     

    new net.sf.jasperreports.engine.JREmptyDataSource()  instead of    

    ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")

    Error is the same :

     

     

    01:52:47.704 [http-nio-8080-exec-8] ERROR net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1: exception
    net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: new net.sf.jasperreports.engine.JREmptyDataSource()
        at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284)
        at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:316)
        at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:672)
        at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:640)
        at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1169)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:522)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:350)
        at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383)
        at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:548)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2583)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:813)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615)
        at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:433)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:818)
        at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61)
        at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JREmptyDataSource
        at reportGroup_1565043926314_683208.evaluate(reportGroup_1565043926314_683208:218)
        at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:302)
        ... 19 common frames omitted

     

     

     

     

     

     

     

     

     

     

     

    Problem with passing Datasource from one Subreport to another Subreport

    in Products

    Posted

    Hi ppl,

    after days spending solving problem I want to ask the community.

    Given :

    4 Reports : reportA, reportFirmen,  reportGroup, reportPosition

    reportA includes  reportFirmen and reportGroup

    reportGroup includes reportPosition

    All of Reports works fine in iReport Designer 5.6.0  and in TIBCO Jaspersoft® Studio 6.9.0 - Visual Designer for JasperReports 6.9.0. 
    But in Java Application  (WebbApp) not with following Error 

    Maven (tried with 6.8.0, 6.2.0 and 5.0.4 no difference) : 

    <!-- https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports --><dependency>    <groupId>net.sf.jasperreports</groupId>    <artifactId>jasperreports</artifactId>    <version>6.8.1</version></dependency>

     

    Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")
        at net.sf.jasperreports.engine.fill.JREvaluator.handleEvaluationException(JREvaluator.java:284)
        at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:316)
        at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:672)
        at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:640)
        at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1169)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:522)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:350)
        at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:383)
        at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:548)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2583)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:813)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615)
        at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:433)
        at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:818)
        at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61)
        at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        ... 1 more
    Caused by: java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
        at reportGroup_1564933204729_909292.evaluate(reportGroup_1564933204729_909292:211)
        at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:302)
        ... 19 more
    Caused by: java.lang.ClassNotFoundException: net.sf.jasperreports.engine.JRDataSource
        at java.lang.ClassLoader.findClass(ClassLoader.java:530)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 21 more


    All Reports have Langueg=Java
    I pass SubReport Directory correctly
    First Level works really fine in JavaApp too (Groups and Firms are in the Report)
    Creation of Datasoruce from reportA for reportGroup   works in JavaApp and iReport
    ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/group")

    The Problem is creating new  Datasoruce in reportGroup from reportPosition
    ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")
    it works ONLY in ireport

    if I do not pass/create this DS, everything works with empty positions List in subreport.
    Tank a lot !

     

     

    <?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="reportA" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="98ea4eeb-12cc-4fb5-bc82-c9ec2757e85b">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="0"/>   <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">      <defaultValueExpression><![CDATA["/Users/leo/IdeaProjects/gitlabinnoweb/innoweb/src/main/resources/reports/"]]></defaultValueExpression>   </parameter>   <queryString language="xPath">      <![CDATA[/xmldata/group]]>   </queryString>   <field name="presimage" class="java.lang.String">      <fieldDescription><![CDATA[/xmldata/presimage]]></fieldDescription>   </field>   <field name="id" class="java.lang.String">      <fieldDescription><![CDATA[id]]></fieldDescription>   </field>   <field name="name" class="java.lang.String">      <fieldDescription><![CDATA[name]]></fieldDescription>   </field>   <background>      <band splitType="Stretch"/>   </background>   <title>      <band height="122" splitType="Stretch">         <image>            <reportElement x="50" y="0" width="100" height="50" uuid="34a2b359-27cd-47a1-91cc-8e5da3128eee"/>            <imageExpression><![CDATA[new java.io.ByteArrayInputStream(org.apache.commons.codec.binary.Base64.decodeBase64($F{presimage}.getBytes()))]]></imageExpression>         </image>         <subreport>            <reportElement x="0" y="93" width="555" height="29" uuid="4e9e407e-1731-4ede-a0a1-55c55dd830a4"/>            <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).dataSource("/xmldata/firmen/firm")]]></dataSourceExpression>            <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "reportFirmen.jasper"]]></subreportExpression>         </subreport>         <textField>            <reportElement x="100" y="63" width="455" height="20" uuid="e7ee3b21-795f-4984-9cca-5c4a174808ad"/>            <textFieldExpression><![CDATA[$P{SUBREPORT_DIR}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="0" y="63" width="100" height="20" uuid="b2c187c6-e5dc-4d9c-8f4c-77a5279fbcd6"/>            <text><![CDATA[subreport dir]]></text>         </staticText>      </band>   </title>   <detail>      <band height="62" splitType="Stretch">         <textField>            <reportElement x="0" y="0" width="100" height="20" uuid="5999312c-1ad7-415c-a021-cd15b5c311cc"/>            <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="100" y="0" width="363" height="20" uuid="e944d6c0-5785-4276-9b04-dee7e2c040a8"/>            <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>         </textField>         <subreport>            <reportElement x="0" y="20" width="555" height="42" uuid="5b11fe21-104d-41b0-8e35-7612df9ac9c3"/>            <subreportParameter name="SUBREPORT_DIR">               <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>            </subreportParameter>            <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/group")]]></dataSourceExpression>            <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "reportGroup.jasper"]]></subreportExpression>         </subreport>      </band>   </detail></jasperReport>[/code]
    <?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="reportFirmen" pageWidth="555" pageHeight="802" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="7d5ebcce-f74b-48e5-a09b-4b65c6af948c">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="0"/>   <queryString language="xPath">      <![CDATA[/xmldata/firmen/firm]]>   </queryString>   <field name="name" class="java.lang.String">      <fieldDescription><![CDATA[name]]></fieldDescription>   </field>   <field name="info" class="java.lang.String">      <fieldDescription><![CDATA[/xmldata/firmen/info]]></fieldDescription>   </field>   <title>      <band height="23">         <textField>            <reportElement x="222" y="0" width="333" height="20" uuid="1fff2be9-b525-4b31-95cc-7e654c4ed6f8"/>            <textFieldExpression><![CDATA[$F{info}]]></textFieldExpression>         </textField>         <staticText>            <reportElement x="122" y="0" width="100" height="20" uuid="3b116953-f269-489a-bc42-341b98e7e163"/>            <text><![CDATA[Alle Lieferanten]]></text>         </staticText>      </band>   </title>   <detail>      <band height="23" splitType="Stretch">         <textField>            <reportElement x="0" y="0" width="213" height="20" uuid="32b13a2b-c4c2-4c87-a9d7-39f464a9785f"/>            <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>         </textField>      </band>   </detail></jasperReport>[/code]

     

    <?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="reportGroup" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="0" bottomMargin="0" uuid="5a823ffc-bb97-44a4-88b6-7fd7e13a49ab">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="0"/>   <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">      <defaultValueExpression><![CDATA["/Users/leo/IdeaProjects/gitlabinnoweb/innoweb/src/main/resources/reports/"]]></defaultValueExpression>   </parameter>   <queryString language="xPath">      <![CDATA[/xmldata/group/group]]>   </queryString>   <field name="id" class="java.lang.String">      <fieldDescription><![CDATA[id]]></fieldDescription>   </field>   <field name="name" class="java.lang.String">      <fieldDescription><![CDATA[name]]></fieldDescription>   </field>   <field name="totalprice" class="java.lang.String">      <fieldDescription><![CDATA[totalprice]]></fieldDescription>   </field>   <title>      <band height="25">         <textField>            <reportElement x="0" y="0" width="555" height="20" uuid="e7c1dae2-1d7f-4e51-8876-caf84aab3602"/>            <textFieldExpression><![CDATA[$P{SUBREPORT_DIR}]]></textFieldExpression>         </textField>      </band>   </title>   <detail>      <band height="82" splitType="Stretch">         <textField>            <reportElement x="100" y="13" width="393" height="20" uuid="4e65c336-9c12-4bf5-9cd8-53a2964c08a9"/>            <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="0" y="13" width="100" height="20" uuid="c29fc9f8-f386-441b-b5fa-515de2a77c4f"/>            <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>         </textField>         <subreport>            <reportElement x="0" y="33" width="555" height="38" uuid="ec08d032-8cde-4a66-9bd8-bb0e82c55731"/>            <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/group/position")]]></dataSourceExpression>            <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "reportPosition.jasper"]]></subreportExpression>         </subreport>      </band>   </detail>   <lastPageFooter>      <band height="25">         <staticText>            <reportElement x="320" y="0" width="100" height="20" uuid="539df4fc-c828-4e1b-829d-7863e2c88f3d"/>            <text><![CDATA[total group  price]]></text>         </staticText>         <textField>            <reportElement x="420" y="0" width="100" height="20" uuid="668abe45-de36-4e16-8a5e-e5d5b2ba2a5f"/>            <textFieldExpression><![CDATA[$F{totalprice}]]></textFieldExpression>         </textField>      </band>   </lastPageFooter></jasperReport>[/code]

     

    <?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="reportPosition" pageWidth="555" pageHeight="802" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="9c3067ff-301b-4853-b1dd-b60f86f10881">   <property name="ireport.zoom" value="1.0"/>   <property name="ireport.x" value="0"/>   <property name="ireport.y" value="0"/>   <queryString language="xPath">      <![CDATA[/xmldata/group/group/position]]>   </queryString>   <field name="id" class="java.lang.String">      <fieldDescription><![CDATA[id]]></fieldDescription>   </field>   <field name="name" class="java.lang.String">      <fieldDescription><![CDATA[name]]></fieldDescription>   </field>   <field name="amount" class="java.lang.String">      <fieldDescription><![CDATA[amount]]></fieldDescription>   </field>   <field name="unit" class="java.lang.String">      <fieldDescription><![CDATA[unit]]></fieldDescription>   </field>   <field name="price" class="java.lang.String">      <fieldDescription><![CDATA[price]]></fieldDescription>   </field>   <field name="totalprice" class="java.lang.String">      <fieldDescription><![CDATA[totalprice]]></fieldDescription>   </field>   <field name="image" class="java.lang.String">      <fieldDescription><![CDATA[image]]></fieldDescription>   </field>   <background>      <band splitType="Stretch"/>   </background>   <columnHeader>      <band height="24" splitType="Stretch">         <staticText>            <reportElement x="0" y="2" width="40" height="20" uuid="632fa471-23ca-48e6-acc2-908f1c94c37e"/>            <text><![CDATA[id]]></text>         </staticText>         <staticText>            <reportElement x="40" y="2" width="207" height="20" uuid="6e1e4604-29b9-4e52-9dfc-85a1f809c78d"/>            <text><![CDATA[name]]></text>         </staticText>         <staticText>            <reportElement x="247" y="0" width="100" height="20" uuid="86ef3c1e-3c8b-4a3f-b952-56ed8fa3ecb2"/>            <text><![CDATA[amount]]></text>         </staticText>         <staticText>            <reportElement x="347" y="2" width="43" height="20" uuid="1bbf1120-80f1-4062-8b6f-a686e742e9d0"/>            <text><![CDATA[unit]]></text>         </staticText>         <staticText>            <reportElement x="390" y="2" width="67" height="20" uuid="2e2663b8-1682-46f8-b114-9c185c6c5cc1"/>            <text><![CDATA[price]]></text>         </staticText>         <staticText>            <reportElement x="457" y="2" width="98" height="20" uuid="f117df4d-aa82-4f98-a44a-63f1c9c8bcde"/>            <text><![CDATA[totalprice]]></text>         </staticText>      </band>   </columnHeader>   <detail>      <band height="67" splitType="Stretch">         <image scaleImage="RealSize">            <reportElement x="0" y="20" width="555" height="44" uuid="8c884f7b-76f0-4108-b556-e41c2e594926"/>            <imageExpression><![CDATA[new java.io.ByteArrayInputStream(org.apache.commons.codec.binary.Base64.decodeBase64($F{image}.getBytes()))]]></imageExpression>         </image>         <textField>            <reportElement x="347" y="0" width="43" height="20" uuid="d727ea06-8c53-46ce-8b92-bfa85d7ec83b"/>            <textFieldExpression><![CDATA[$F{unit}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="0" y="0" width="40" height="20" uuid="5e24b73b-257a-4b30-8479-2f10e0848d1d"/>            <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="40" y="0" width="207" height="20" uuid="8e21fdc1-63ec-4e21-a37a-62958805a5c5"/>            <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="247" y="0" width="100" height="20" uuid="5cbcee7b-d24b-493b-a88c-a193fc1c2d3c"/>            <textFieldExpression><![CDATA[$F{amount}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="390" y="0" width="67" height="20" uuid="84bfd460-2fed-4079-b778-4b3ce43d5184"/>            <textFieldExpression><![CDATA[$F{price}]]></textFieldExpression>         </textField>         <textField>            <reportElement x="457" y="0" width="98" height="20" uuid="358c6394-40ba-4a57-b8f9-612d6748641a"/>            <textFieldExpression><![CDATA[$F{totalprice}]]></textFieldExpression>         </textField>      </band>   </detail></jasperReport>[/code]

     

    <xmldata>    <angebot>        <id>aaaaa11111</id>        <name>Name of angebot</name>        <date>Januar 20,2020</date>    </angebot>    <customer>        <id>287462876</id>        <name>Familie Mustermann</name>        <street>Musterstr. 1</street>        <zipcode>80111</zipcode>        <city>Musterstadt</city>    </customer>    <firmen>        <info>Firmenliste</info>        <firm>            <name>Firma A</name>        </firm>        <firm>            <name>Firma B</name>        </firm>        <firm>            <name>Firma C</name>        </firm>    </firmen>    <group>        <id>1</id>        <name>Vorbereitende Arbeiten</name>        <group>            <id>1</id>            <name>Baustelleneinrichtung</name>            <position>                <id>1</id>                <name>Baustellen WC</name>                <amount>3.00</amount>                <unit>Stück</unit>                <price>1000</price>                <totalprice>3000.00</totalprice>            </position>            <position>                <id>2</id>                <name>Baucontainer</name>                <amount>2.00</amount>                <unit>Stück</unit>                <price>100</price>                <totalprice>200.00</totalprice>            </position>            <totalprice>3200.00</totalprice>        </group>    </group>    <group>        <id>2</id>        <name>Innenausbau</name>        <group>            <id>1</id>            <name>Fliesen- und Natursteinarbeiten</name>            <position>                <id>1</id>                <name>Anschleifen</name>                <amount>300.00</amount>                <unit>m2</unit>                <price>3</price>                <totalprice>900.00</totalprice>             </position>            <position>                <id>2</id>                <name>Abklopfen</name>                <amount>200.00</amount>                <unit>m2</unit>                <price>10</price>                <totalprice>2000.00</totalprice>            </position>            <totalprice>2900.00</totalprice>        </group>        <group>            <id>2</id>            <name>Sonstiges</name>            <position>                <id>1</id>                <name>Matte</name>                <amount>30.00</amount>                <unit>Stück</unit>                <price>1</price>                <totalprice>30.00</totalprice>            </position>            <position>                <id>2</id>                <name>Streichen</name>                <amount>2000.00</amount>                <unit>m2</unit>                <price>10</price>                <totalprice>20000.00</totalprice>            </position>            <totalprice>20030.00</totalprice>        </group>    </group>    <group>        <id>3</id>        <name>Unbekannte Arbeiten</name>    </group></xmldata>[/code]

    Need Help !

    Thanks 

     

     

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore