Jasper Json

btodem_1 · August 19, 2021

Json File :

{
"header" : {
"title" : "Inventarliste",
"buchungsKreisBezeichnung" : "Möbelparadies Eifelland",
},
"footer" : {
"user" : "_master",
},
"anlagengueter" : [ {
"anlagennummer" : "317",
"bezeichnung" : "Festwert neue ",
"beschreibung" : "Festwert, darchen",
"info" : "",
"aktiviertDatum" : {
"year" : 1980,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "TUESDAY",
"leapYear" : true,
"dayOfMonth" : 1
},
"aktiviertUser" : null,
"aktiviert" : true,
"datumAnschaffung" : {
"year" : 2021,
"month" : "MAY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 5,
"era" : "CE",
"dayOfYear" : 121,
"dayOfWeek" : "SATURDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"datumAfaBeginn" : {
"year" : 2021,
"month" : "MAY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 5,
"era" : "CE",
"dayOfYear" : 121,
"dayOfWeek" : "SATURDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"klasse" : "0020",
"klasseBezeichnung" : "Feert",
"konto" : {
"kontonummer" : "000",
"bezeichnung" : "Fesert",
"kontonummerUndBezeichnung" : "00t"
},
"sachkonto" : null,
"betragAnschaffung" : 250.00,
"nutzdauer" : 142,
"abschreissatz" : null,
"anfanndAHK" : 0.00,
"endbesHK" : 2120.00,
"anfangsndCalc" : 0.00,
"afaCmuliert" : 0.00,
"afalc" : 0.00,
"endCalc" : 21250.00,
"anfanebucht" : 0.00,
"afmuliert" : 0.00,
"afucht" : 0.00,
"endbGeht" : 21250.00,
"afebucht" : 0.00,
"afufig" : 0.00,
"zugge" : 21250.00,
"aenge" : 0.00,
"ucngen" : 0.00,
"kz" : null,
"garantie" : null,
"user" : [ ],
"ort" : [ ],
"werks" : [ ]
}, {
"anlag" : "323",
"bezeichnung" : "Audi A4",
"beschreibung" : "",
"info" : "Das ist ein Test",
"aktiviertDatum" : {
"year" : 1980,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "TUESDAY",
"leapYear" : true,
"dayOfMonth" : 1
},
"aktiviertUser" : null,
"aktiviert" : true,
"datumAnschaffung" : {
"year" : 2021,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"datumAfaBeginn" : {
"year" : 2021,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"anlagenklasse" : "0320",
"anlagenklasseBezeichnung" : "Fuhrpark",
"anlagenkonto" : {
"kontonummer" : "032",
"bezeichnung" : "W",
"kontonummerUndBezeichnung" : "032W"
},
"sachkonto" : {
"kontonummer" : "432",
"bezeichnung" : "APKW",
"kontonummerUndBezeichnung" : "4 PKW"
},
"betragAnschaffung" : 51.85,
"nutzungsdauer" : 72,
"abschreibungssatz" : 16.7,
"anfangsbestandAHK" : 0.00,
"endbestandAHK" : 541.85,
"anfangsbestandCalc" : 0.00,
"afaCalcKumuliert" : 91.68,
"afaCalc" : 903.8,
"endbestandCalc" : 418.17,
"anfangsbestandGebucht" : 0.00,
"afaGebuchtKumuliert" : 67.76,
"afaGebucht" : 67.76,
"endbestandGebucht" : 477.09,
"afaNichtGebucht" : 25.92,
"afaVorlaeufig" : 0.00,
"zugaenge" : 546.85,
"abgaenge" : 0.00,
"umbuchungen" : 0.00,
"kfz" : {
"kfzKennzeichen" : "uiy - 55 123",
"fahrgestellNummer" : "",
"autoMarke" : "",
"modell" : "",
"aufbau" : "",
"farbe" : "",
"bauArt" : null,
"kw" : null,
"anzahlGaenge" : 0,
"kraftstoffArt" : null,
"tankGroesse" : null,
"anzahlTueren" : 0,
"anzahlSitze" : 0,
"ahk" : false,
"traglast" : null,
"erstZulassung" : null,
"tuevBis" : null,
"steuerProJahr" : 0.00,
"steuerFaellig" : null,
"einzugMandatId" : "",
"groesseSommerReifen" : "",
"groesseWinterReifen" : ""
},
"garantie" : {
"seriennummer" : "114-91-02994-2093452",
"abteilung" : "Verwaltung",
"garantieBis" : {
"year" : 2025,
"month" : "DECEMBER",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 12,
"era" : "CE",
"dayOfYear" : 365,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 31
},
"erweiterteGarantieBis" : {
"year" : 2032,
"month" : "JUNE",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 6,
"era" : "CE",
"dayOfYear" : 181,
"dayOfWeek" : "THURSDAY",
"leapYear" : false,
"dayOfMonth" : 30
},
"bemerkung" : "t",
"geberKonto" : {
"kontonummer" : "80ziopiio7",
"bezeichnung" : "Aziopüziopo Gmb",
"kontonummerUndBezeichnung" : "80359ipözoziziomb"
}
},
"mitarbeiters" : [ {
"datumVon" : {
"year" : 2021,
"month" : "JUNE",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 6,
"era" : "CE",
"dayOfYear" : 181,
"dayOfWeek" : "WEDNESDAY",
"leapYear" : false,
"dayOfMonth" : 30
},
"datumBis" : null,
"personalnr" : "068542",
"kuerzel" : "p5p",
"name" : "Jnas",
"vorname" : "Koff",
"email" : "eifelland.de",
"vornameName" : " Jonas"
} ],
"standorte" : [ {
"abteilung" : "Verwltung",
"datumBis" : null,
"datumVon" : {
"year" : 2021,
"month" : "JUNE",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 6,
"era" : "CE",
"dayOfYear" : 181,
"dayOfWeek" : "WEDNESDAY",
"leapYear" : false,
"dayOfMonth" : 30
},
"raum" : "023",
"filialeNr" : "02",
"filialeBezeichnung" : "Verkauus"
} ],
"werkstaetten" : [ ]
} ],
"dateRange" : {
"start" : {
"year" : 2021,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"end" : {
"year" : 2022,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "SATURDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"empty" : false,
"endInclusive" : {
"year" : 2021,
"month" : "DECEMBER",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 12,
"era" : "CE",
"dayOfYear" : 365,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 31
},
"unboundedStart" : false,
"unboundedEnd" : false
},
"datumVon" : {
"year" : 2021,
"month" : "JANUARY",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 1,
"era" : "CE",
"dayOfYear" : 1,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 1
},
"datumBis" : {
"year" : 2021,
"month" : "DECEMBER",
"chronology" : {
"calendarType" : "iso8601",
"id" : "ISO"
},
"monthValue" : 12,
"era" : "CE",
"dayOfYear" : 365,
"dayOfWeek" : "FRIDAY",
"leapYear" : false,
"dayOfMonth" : 31
}
}

I have this Json file und Try to do my first Jasperreport with Json.

please can someone help me. Thankssssssss

I try to do this :

Anlagennummer Bezeichnung .. serienummer .... .abteilung .... Raum .... Name

btodem_1 · October 4, 2021

I Try with this 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="2TEXT1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fd41c91c-2bf0-4ef1-b931-82f2aef5c232">
   <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JsonDataAdapter "/>
   <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
       <box>
           <pen lineWidth="0.5" lineColor="#000000"/>
           <topPen lineWidth="0.5" lineColor="#000000"/>
           <leftPen lineWidth="0.5" lineColor="#000000"/>
           <bottomPen lineWidth="0.5" lineColor="#000000"/>
           <rightPen lineWidth="0.5" lineColor="#000000"/>
       </box>
   </style>
   <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
       <box>
           <pen lineWidth="0.5" lineColor="#000000"/>
           <topPen lineWidth="0.5" lineColor="#000000"/>
           <leftPen lineWidth="0.5" lineColor="#000000"/>
           <bottomPen lineWidth="0.5" lineColor="#000000"/>
           <rightPen lineWidth="0.5" lineColor="#000000"/>
       </box>
   </style>
   <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
       <box>
           <pen lineWidth="0.5" lineColor="#000000"/>
           <topPen lineWidth="0.5" lineColor="#000000"/>
           <leftPen lineWidth="0.5" lineColor="#000000"/>
           <bottomPen lineWidth="0.5" lineColor="#000000"/>
           <rightPen lineWidth="0.5" lineColor="#000000"/>
       </box>
   </style>
   <subDataset name="Dataset1" uuid="246e8a66-fe2e-42c7-87b3-a00ede0de322">
       <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JsonDataAdapter "/>
       <queryString language="JSON">
           <![CDATA[anlagengueter]]>
       </queryString>
       <field name="anlagennummer" class="java.lang.Integer">
           <property name="net.sf.jasperreports.json.field.expression" value="anlagennummer"/>
           <fieldDescription><![CDATA[anlagennummer]]></fieldDescription>
       </field>
       <field name="bezeichnung" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="bezeichnung"/>
           <fieldDescription><![CDATA[bezeichnung]]></fieldDescription>
       </field>
       <field name="beschreibung" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="beschreibung"/>
           <fieldDescription><![CDATA[beschreibung]]></fieldDescription>
       </field>
       <field name="info" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="info"/>
           <fieldDescription><![CDATA[info]]></fieldDescription>
       </field>
       <field name="aktiviertDatum" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="aktiviertDatum"/>
           <fieldDescription><![CDATA[aktiviertDatum]]></fieldDescription>
       </field>
       <field name="aktiviertUser" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="aktiviertUser"/>
           <fieldDescription><![CDATA[aktiviertUser]]></fieldDescription>
       </field>
       <field name="aktiviert" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="aktiviert"/>
           <fieldDescription><![CDATA[aktiviert]]></fieldDescription>
       </field>
       <field name="datumAnschaffung" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="datumAnschaffung"/>
           <fieldDescription><![CDATA[datumAnschaffung]]></fieldDescription>
       </field>
       <field name="datumAfaBeginn" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="datumAfaBeginn"/>
           <fieldDescription><![CDATA[datumAfaBeginn]]></fieldDescription>
       </field>
       <field name="anlagenklasse" class="java.lang.Integer">
           <property name="net.sf.jasperreports.json.field.expression" value="anlagenklasse"/>
           <fieldDescription><![CDATA[anlagenklasse]]></fieldDescription>
       </field>
       <field name="anlagenklasseBezeichnung" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="anlagenklasseBezeichnung"/>
           <fieldDescription><![CDATA[anlagenklasseBezeichnung]]></fieldDescription>
       </field>
       <field name="anlagenkonto" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="anlagenkonto"/>
           <fieldDescription><![CDATA[anlagenkonto]]></fieldDescription>
       </field>
       <field name="sachkonto" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="sachkonto"/>
           <fieldDescription><![CDATA[sachkonto]]></fieldDescription>
       </field>
       <field name="betragAnschaffung" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="betragAnschaffung"/>
           <fieldDescription><![CDATA[betragAnschaffung]]></fieldDescription>
       </field>
       <field name="nutzungsdauer" class="java.lang.Integer">
           <property name="net.sf.jasperreports.json.field.expression" value="nutzungsdauer"/>
           <fieldDescription><![CDATA[nutzungsdauer]]></fieldDescription>
       </field>
       <field name="abschreibungssatz" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="abschreibungssatz"/>
           <fieldDescription><![CDATA[abschreibungssatz]]></fieldDescription>
       </field>
       <field name="anfangsbestandAHK" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="anfangsbestandAHK"/>
           <fieldDescription><![CDATA[anfangsbestandAHK]]></fieldDescription>
       </field>
       <field name="endbestandAHK" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="endbestandAHK"/>
           <fieldDescription><![CDATA[endbestandAHK]]></fieldDescription>
       </field>
       <field name="anfangsbestandCalc" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="anfangsbestandCalc"/>
           <fieldDescription><![CDATA[anfangsbestandCalc]]></fieldDescription>
       </field>
       <field name="afaCalcKumuliert" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaCalcKumuliert"/>
           <fieldDescription><![CDATA[afaCalcKumuliert]]></fieldDescription>
       </field>
       <field name="afaCalc" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaCalc"/>
           <fieldDescription><![CDATA[afaCalc]]></fieldDescription>
       </field>
       <field name="endbestandCalc" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="endbestandCalc"/>
           <fieldDescription><![CDATA[endbestandCalc]]></fieldDescription>
       </field>
       <field name="anfangsbestandGebucht" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="anfangsbestandGebucht"/>
           <fieldDescription><![CDATA[anfangsbestandGebucht]]></fieldDescription>
       </field>
       <field name="afaGebuchtKumuliert" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaGebuchtKumuliert"/>
           <fieldDescription><![CDATA[afaGebuchtKumuliert]]></fieldDescription>
       </field>
       <field name="afaGebucht" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaGebucht"/>
           <fieldDescription><![CDATA[afaGebucht]]></fieldDescription>
       </field>
       <field name="endbestandGebucht" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="endbestandGebucht"/>
           <fieldDescription><![CDATA[endbestandGebucht]]></fieldDescription>
       </field>
       <field name="afaNichtGebucht" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaNichtGebucht"/>
           <fieldDescription><![CDATA[afaNichtGebucht]]></fieldDescription>
       </field>
       <field name="afaVorlaeufig" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="afaVorlaeufig"/>
           <fieldDescription><![CDATA[afaVorlaeufig]]></fieldDescription>
       </field>
       <field name="zugaenge" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="zugaenge"/>
           <fieldDescription><![CDATA[zugaenge]]></fieldDescription>
       </field>
       <field name="abgaenge" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="abgaenge"/>
           <fieldDescription><![CDATA[abgaenge]]></fieldDescription>
       </field>
       <field name="umbuchungen" class="java.math.BigDecimal">
           <property name="net.sf.jasperreports.json.field.expression" value="umbuchungen"/>
           <fieldDescription><![CDATA[umbuchungen]]></fieldDescription>
       </field>
       <field name="kfz" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="kfz"/>
           <fieldDescription><![CDATA[kfz]]></fieldDescription>
       </field>
       <field name="garantie" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="garantie"/>
           <fieldDescription><![CDATA[garantie]]></fieldDescription>
       </field>
       <field name="mitarbeiters" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="mitarbeiters"/>
           <fieldDescription><![CDATA[mitarbeiters]]></fieldDescription>
       </field>
       <field name="standorte" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="standorte"/>
           <fieldDescription><![CDATA[standorte]]></fieldDescription>
       </field>
       <field name="werkstaetten" class="java.lang.String">
           <property name="net.sf.jasperreports.json.field.expression" value="werkstaetten"/>
           <fieldDescription><![CDATA[werkstaetten]]></fieldDescription>
       </field>
   </subDataset>
   <queryString language="json">
       <![CDATA[]]>
   </queryString>
   <field name="header" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="header"/>
       <fieldDescription><![CDATA[header]]></fieldDescription>
   </field>
   <field name="footer" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="footer"/>
       <fieldDescription><![CDATA[footer]]></fieldDescription>
   </field>
   <field name="anlagengueter" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="anlagengueter"/>
       <fieldDescription><![CDATA[anlagengueter]]></fieldDescription>
   </field>
   <field name="waerungsKenzeichen" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="waerungsKenzeichen"/>
       <fieldDescription><![CDATA[waerungsKenzeichen]]></fieldDescription>
   </field>
   <field name="dateRange" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="dateRange"/>
       <fieldDescription><![CDATA[dateRange]]></fieldDescription>
   </field>
   <field name="datumVon" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="datumVon"/>
       <fieldDescription><![CDATA[datumVon]]></fieldDescription>
   </field>
   <field name="datumBis" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="datumBis"/>
       <fieldDescription><![CDATA[datumBis]]></fieldDescription>
   </field>
   <field name="title" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="header.title"/>
       <fieldDescription><![CDATA[header.title]]></fieldDescription>
   </field>
   <field name="user" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="footer.user"/>
       <fieldDescription><![CDATA[footer.user]]></fieldDescription>
   </field>
   <field name="anlagennummer" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="anlagengueter.anlagennummer"/>
       <fieldDescription><![CDATA[anlagengueter.anlagennummer]]></fieldDescription>
   </field>
   <field name="bezeichnung" class="java.lang.String">
       <property name="net.sf.jasperreports.json.field.expression" value="anlagengueter.bezeichnung"/>
       <fieldDescription><![CDATA[anlagengueter.bezeichnung]]></fieldDescription>
   </field>
   <background>
       <band splitType="Stretch"/>
   </background>
   <title>
       <band height="79" splitType="Stretch">
           <textField>
               <reportElement x="316" y="47" width="100" height="30" uuid="f54e908d-d8e7-4c25-9b31-6bfb8b72fc48"/>
               <textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>
           </textField>
       </band>
   </title>
   <pageHeader>
       <band height="35" splitType="Stretch"/>
   </pageHeader>
   <columnHeader>
       <band height="61" splitType="Stretch">
           <staticText>
               <reportElement x="80" y="0" width="100" height="30" uuid="896e61ba-22f2-47b9-b031-f1b786fdaaee">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bd1d6aba-4c47-4e6c-a71d-8711202efd3e"/>
               </reportElement>
               <text><![CDATA[anlagennummer]]></text>
           </staticText>
       </band>
   </columnHeader>
   <detail>
       <band height="243" splitType="Stretch">
           <textField>
               <reportElement x="-10" y="170" width="130" height="70" uuid="bc0e0a13-b064-4106-87d7-386b0cba9eec">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bd1d6aba-4c47-4e6c-a71d-8711202efd3e"/>
               </reportElement>
               <textFieldExpression><![CDATA[$F{anlagennummer}]]></textFieldExpression>
           </textField>
           <componentElement>
               <reportElement x="90" y="20" width="380" height="150" uuid="0662cf10-a474-439c-b814-fdd3dada6096">
                   <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                   <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
                   <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
                   <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
               </reportElement>
               <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                   <datasetRun subDataset="Dataset1" uuid="1f7482cd-ed11-4b15-b783-458686574129">
                       <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("anlagengueter.*")]]></dataSourceExpression>
                   </datasetRun>
                   <jr:column width="40" uuid="00a8a92c-4722-43f5-a084-872edc6797db">
                       <jr:tableHeader style="Table_TH" height="30"/>
                       <jr:tableFooter style="Table_TH" height="30"/>
                       <jr:columnHeader style="Table_CH" height="30">
                           <staticText>
                               <reportElement x="0" y="0" width="40" height="30" uuid="1d975ee1-388d-49be-8631-01d49a70bf00"/>
                               <text><![CDATA[anlagennummer]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:columnFooter style="Table_CH" height="30"/>
                       <jr:detailCell style="Table_TD" height="30">
                           <textField>
                               <reportElement x="0" y="0" width="40" height="30" uuid="3d5f8791-0c26-41ca-b4c9-20ae9fdd96d2"/>
                               <textFieldExpression><![CDATA[$F{anlagennummer}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="40" uuid="a980c09d-718a-47f9-96d9-2a1ebcb5bedd">
                       <jr:tableHeader style="Table_TH" height="30"/>
                       <jr:tableFooter style="Table_TH" height="30"/>
                       <jr:columnHeader style="Table_CH" height="30">
                           <staticText>
                               <reportElement x="0" y="0" width="40" height="30" uuid="d541db18-329f-4429-81af-e09b12cc3fd5"/>
                               <text><![CDATA[bezeichnung]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:columnFooter style="Table_CH" height="30"/>
                       <jr:detailCell style="Table_TD" height="30">
                           <textField>
                               <reportElement x="0" y="0" width="40" height="30" uuid="81c7c04a-46fc-4737-9b8b-fc86bd1dad62"/>
                               <textFieldExpression><![CDATA[$F{bezeichnung}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="40" uuid="f91fccd8-82cc-4dfe-ab20-69949d8c0cc5">
                       <jr:tableHeader style="Table_TH" height="30"/>
                       <jr:tableFooter style="Table_TH" height="30"/>
                       <jr:columnHeader style="Table_CH" height="30">
                           <staticText>
                               <reportElement x="0" y="0" width="40" height="30" uuid="d9f5e035-a2df-4905-985f-c2a9c9eac870"/>
                               <text><![CDATA[afaVorlaeufig]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:columnFooter style="Table_CH" height="30"/>
                       <jr:detailCell style="Table_TD" height="30">
                           <textField>
                               <reportElement x="0" y="0" width="40" height="30" uuid="dc739ffd-775d-48ac-8423-503c6ec7a1d5"/>
                               <textFieldExpression><![CDATA[$F{afaVorlaeufig}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="40" uuid="6f6c13dd-8c9d-499b-8100-2049addbb1a2">
                       <jr:tableHeader style="Table_TH" height="30"/>
                       <jr:tableFooter style="Table_TH" height="30"/>
                       <jr:columnHeader style="Table_CH" height="30">
                           <staticText>
                               <reportElement x="0" y="0" width="40" height="30" uuid="e6d1c96e-2100-42f0-bff1-0d5fcc7df237"/>
                               <text><![CDATA[afaGebuchtKumuliert]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:columnFooter style="Table_CH" height="30"/>
                       <jr:detailCell style="Table_TD" height="30">
                           <textField>
                               <reportElement x="0" y="0" width="40" height="30" uuid="f9d6d1c0-0b4a-4756-9265-f470e8feed1f"/>
                               <textFieldExpression><![CDATA[$F{afaGebuchtKumuliert}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="40" uuid="57738b8d-e3ec-48b4-8530-124eec6eaf14">
                       <jr:tableHeader style="Table_TH" height="30"/>
                       <jr:tableFooter style="Table_TH" height="30"/>
                       <jr:columnHeader style="Table_CH" height="30">
                           <staticText>
                               <reportElement x="0" y="0" width="40" height="30" uuid="20c66c74-ba3d-498d-8df4-e4b314188df3"/>
                               <text><![CDATA[endbestandCalc]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:columnFooter style="Table_CH" height="30"/>
                       <jr:detailCell style="Table_TD" height="30">
                           <textField>
                               <reportElement x="0" y="0" width="40" height="30" uuid="db2ee031-d50b-4e79-a71b-a4c8019c8698"/>
                               <textFieldExpression><![CDATA[$F{endbestandCalc}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
               </jr:table>
           </componentElement>
       </band>
   </detail>
   <columnFooter>
       <band height="45" splitType="Stretch"/>
   </columnFooter>
   <pageFooter>
       <band height="59" splitType="Stretch">
           <textField>
               <reportElement x="19" y="29" width="100" height="30" uuid="e88b1f7d-62ce-4b8e-899f-dd253800cc4f"/>
               <textFieldExpression><![CDATA[$F{user}]]></textFieldExpression>
           </textField>
       </band>
   </pageFooter>
   <summary>
       <band splitType="Stretch"/>
   </summary>
</jasperReport>

Sign In

Jasper Json

Recommended Posts

btodem_1

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

btodem_1

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore