Jump to content
Changes to the Jaspersoft community edition download ×

redundant data fields in jasperstudio


iman.gharib

Recommended Posts

I have very simple select query in my dataset and Query dialog. When I run this query I get 2 times more data fields as there are in the data base! Is there any suggestion where should I look to?

select * from "Index", "Images"where LB_ID = 62 and "KN_OG" =3 and IMG_ID = 1[/code]

 

Link to comment
Share on other sites

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Where are you checking the data? Are you checking from the Dataset and Query Dialog box - Data Preview (bottom tab) - Refresh Preview Data?

If you're checking your data from the report, there just may be layout problem. Need your jrxml file to find the cause.

 

Link to comment
Share on other sites

yes I am checking it from Dataset and Query Dialog box. Here is my jrxml. The sql part is:

select distinct *from KennzahlReferenz2015_QIBericht, ImageswhereLB_ID = $P{LB_ID} andKN_OffiziellGruppe =$P{KN_OffeziellGruppe}and IMG_ID = 1[/code]

and default value for first and second parameter are 62 and 3

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.2.final using JasperReports Library version 6.2.2  --><!-- 2016-06-08T08:53:05 --><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="direktRechrDV" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryNewPage="true" isSummaryWithPageHeaderAndFooter="true" uuid="d12b4217-cf22-4ec4-857b-9cb1b2b406a8">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="KennzahlReferenz2015_QIBericht"/>    <property name="net.sf.jasperreports.print.create.bookmarks" value="true"/>    <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 1_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 1_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 2_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 2_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 3_TH" mode="Opaque" backcolor="#005051">        <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 4_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 5_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 5_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 5_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>    <style name="Table 6_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 7_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 7_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>    <subDataset name="DatasetTable" uuid="088a752b-feef-4e31-b6a9-a2983a8dac7b">        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="KennzahlReferenz2015_QIBericht"/>        <parameter name="LB_ID" class="java.lang.Integer">            <parameterDescription><![CDATA[]]></parameterDescription>        </parameter>        <parameter name="KN_OffeziellGruppe" class="java.lang.Integer"/>        <queryString>            <![CDATA[select * from KennzahlReferenz2015_QIBericht, Images]]>        </queryString>        <field name="praefix" class="java.lang.String"/>        <field name="id" class="java.lang.Integer"/>        <field name="bewertungsArtTypNameKurz" class="java.lang.String"/>        <field name="refbereich" class="java.lang.String"/>        <field name="refbereichVorjahres" class="java.lang.String"/>        <field name="KN_ZAlleinstehend" class="java.lang.String"/>        <field name="KN_GGAlleinstehend" class="java.lang.String"/>        <field name="erlaueterungDerRechregeln" class="java.lang.String"/>        <field name="teildatensatzbezug" class="java.lang.String"/>        <field name="mindesanzahlZaeler" class="java.lang.Integer"/>        <field name="mindesanzahlNenner" class="java.lang.String"/>        <field name="KN_FormelZ" class="java.lang.String"/>        <field name="KN_FormelGG" class="java.lang.String"/>        <field name="verwendeteFunktionen" class="java.lang.String"/>        <field name="vergleichbarkeit" class="java.lang.String"/>        <field name="bewertungsArtTypNameLang" class="java.lang.String"/>        <field name="bewertungsArtVorjahrTypNameLang" class="java.lang.String"/>        <field name="gruppe" class="java.lang.String"/>        <field name="idLb" class="java.lang.String"/>        <field name="LB_LangBezeichnung" class="java.lang.String"/>        <field name="LB_ID" class="java.lang.Integer"/>        <field name="nameAlleinstehend" class="java.lang.String"/>        <field name="KN_BezeichnungAlleinstehendKurz" class="java.lang.String"/>        <field name="refBereichArt" class="java.lang.Integer"/>        <field name="refBereichEinheitErgebnis" class="java.lang.String"/>        <field name="refBereichInfo" class="java.lang.String"/>        <field name="KN_OffiziellGruppe" class="java.lang.Integer"/>        <field name="KN_Zusatzinfo_Erlaeuterung_Rechenregel" class="java.lang.String"/>        <field name="KN_Zusatzinfo_Erlaeuterung_Refbereich" class="java.lang.String"/>        <field name="KN_Zusatzinfo_Methode_Risikoadjustierung" class="java.lang.String"/>        <field name="KN_Zusatzinfo_Erlaeuterung_Risikoadjustierung" class="java.lang.String"/>        <field name="KN_Zusatzinfo_Erlaeuterung_zum_SD" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Indikatorbezug" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Mindestanzahl_Z" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Mindestanzahl_N" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Relevanz" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Hypothese" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Jahr_der_Erstanwendung" class="java.lang.String"/>        <field name="KN_Zusatzinfo_DV_Kommentar" class="java.lang.String"/>        <field name="refBereichInfoArt" class="java.lang.String"/>        <field name="refBereichOperator1" class="java.lang.String"/>        <field name="refBereichStringAusgabe" class="java.lang.String"/>        <field name="refBereichVorjahrInfoArt" class="java.lang.String"/>        <field name="refBereichVorjahrOperator1" class="java.lang.String"/>        <field name="refBereichVorjahrStringAusgabe" class="java.lang.String"/>        <field name="refBereichWert1" class="java.math.BigDecimal"/>        <field name="sortierung" class="java.lang.Integer"/>        <field name="veroeffentlichungsPflicht" class="java.lang.Integer"/>        <field name="idQI_id" class="java.lang.Integer"/>        <field name="KN_Vergleichbarkeit_Vorjahr" class="java.lang.String"/>        <field name="IMG_ID" class="java.lang.Integer"/>        <field name="Name" class="java.lang.String"/>        <field name="Image" class="java.awt.Image"/>        <group name="id">            <groupExpression><![CDATA[$F{id}]]></groupExpression>        </group>        <group name="bewertungsArtTypNameKurz">            <groupExpression><![CDATA[$F{bewertungsArtTypNameKurz}]]></groupExpression>        </group>        <group name="bewertungsArtTypNameLang">            <groupExpression><![CDATA[$F{bewertungsArtTypNameLang}]]></groupExpression>        </group>        <group name="bewertungsArtVorjahrTypNameLang">            <groupExpression><![CDATA[$F{bewertungsArtVorjahrTypNameLang}]]></groupExpression>        </group>        <group name="gruppe">            <groupExpression><![CDATA[$F{gruppe}]]></groupExpression>        </group>        <group name="idLb">            <groupExpression><![CDATA[$F{idLb}]]></groupExpression>        </group>        <group name="LB_LangBezeichnung">            <groupExpression><![CDATA[$F{LB_LangBezeichnung}]]></groupExpression>        </group>        <group name="nameAlleinstehend">            <groupExpression><![CDATA[$F{nameAlleinstehend}]]></groupExpression>        </group>        <group name="KN_BezeichnungAlleinstehendKurz">            <groupExpression><![CDATA[$F{KN_BezeichnungAlleinstehendKurz}]]></groupExpression>        </group>        <group name="praefix">            <groupExpression><![CDATA[$F{praefix}]]></groupExpression>        </group>        <group name="refBereichArt">            <groupExpression><![CDATA[$F{refBereichArt}]]></groupExpression>        </group>        <group name="refBereichEinheitErgebnis">            <groupExpression><![CDATA[$F{refBereichEinheitErgebnis}]]></groupExpression>        </group>        <group name="refBereichInfo">            <groupExpression><![CDATA[$F{refBereichInfo}]]></groupExpression>        </group>        <group name="refBereichStringAusgabe">            <groupExpression><![CDATA[$F{refBereichStringAusgabe}]]></groupExpression>        </group>        <group name="refBereichVorjahrInfoArt">            <groupExpression><![CDATA[$F{refBereichVorjahrInfoArt}]]></groupExpression>        </group>        <group name="refBereichVorjahrOperator1">            <groupExpression><![CDATA[$F{refBereichVorjahrOperator1}]]></groupExpression>        </group>        <group name="refBereichVorjahrStringAusgabe">            <groupExpression><![CDATA[$F{refBereichVorjahrStringAusgabe}]]></groupExpression>        </group>        <group name="refBereichWert1">            <groupExpression><![CDATA[$F{refBereichWert1}]]></groupExpression>        </group>        <group name="sortierung">            <groupExpression><![CDATA[$F{sortierung}]]></groupExpression>        </group>        <group name="veroeffentlichungsPflicht">            <groupExpression><![CDATA[$F{veroeffentlichungsPflicht}]]></groupExpression>        </group>        <group name="idQI_id">            <groupExpression><![CDATA[$F{idQI_id}]]></groupExpression>        </group>    </subDataset>    <scriptlet name="moveTOC" class="testProjektIman.toc.MoveTOC">        <scriptletDescription><![CDATA[moves toc to first page]]></scriptletDescription>    </scriptlet>    <parameter name="LB_ID" class="java.lang.Integer">        <parameterDescription><![CDATA[iD des Leistungsbereiches]]></parameterDescription>        <defaultValueExpression><![CDATA[62]]></defaultValueExpression>    </parameter>    <parameter name="KN_OffeziellGruppe" class="java.lang.Integer">        <defaultValueExpression><![CDATA[3]]></defaultValueExpression>    </parameter>    <parameter name="toc" class="java.lang.StringBuilder" isForPrompting="false">        <defaultValueExpression><![CDATA[new StringBuilder()]]></defaultValueExpression>    </parameter>    <queryString>        <![CDATA[select distinct *from KennzahlReferenz2015_QIBericht, ImageswhereLB_ID = $P{LB_ID} andKN_OffiziellGruppe =$P{KN_OffeziellGruppe}and IMG_ID = 1]]>    </queryString>    <field name="praefix" class="java.lang.String"/>    <field name="id" class="java.lang.Integer"/>    <field name="bewertungsArtTypNameKurz" class="java.lang.String"/>    <field name="refbereich" class="java.lang.String"/>    <field name="refbereichVorjahres" class="java.lang.String"/>    <field name="KN_ZAlleinstehend" class="java.lang.String"/>    <field name="KN_GGAlleinstehend" class="java.lang.String"/>    <field name="erlaueterungDerRechregeln" class="java.lang.String"/>    <field name="teildatensatzbezug" class="java.lang.String"/>    <field name="mindesanzahlZaeler" class="java.lang.Integer"/>    <field name="mindesanzahlNenner" class="java.lang.String"/>    <field name="KN_FormelZ" class="java.lang.String"/>    <field name="KN_FormelGG" class="java.lang.String"/>    <field name="verwendeteFunktionen" class="java.lang.String"/>    <field name="vergleichbarkeit" class="java.lang.String"/>    <field name="bewertungsArtTypNameLang" class="java.lang.String"/>    <field name="bewertungsArtVorjahrTypNameLang" class="java.lang.String"/>    <field name="gruppe" class="java.lang.String"/>    <field name="idLb" class="java.lang.String"/>    <field name="LB_LangBezeichnung" class="java.lang.String"/>    <field name="LB_ID" class="java.lang.Integer"/>    <field name="nameAlleinstehend" class="java.lang.String"/>    <field name="KN_BezeichnungAlleinstehendKurz" class="java.lang.String"/>    <field name="refBereichArt" class="java.lang.Integer"/>    <field name="refBereichEinheitErgebnis" class="java.lang.String"/>    <field name="refBereichInfo" class="java.lang.String"/>    <field name="KN_OffiziellGruppe" class="java.lang.Integer"/>    <field name="KN_Zusatzinfo_Erlaeuterung_Rechenregel" class="java.lang.String"/>    <field name="KN_Zusatzinfo_Erlaeuterung_Refbereich" class="java.lang.String"/>    <field name="KN_Zusatzinfo_Methode_Risikoadjustierung" class="java.lang.String"/>    <field name="KN_Zusatzinfo_Erlaeuterung_Risikoadjustierung" class="java.lang.String"/>    <field name="KN_Zusatzinfo_Erlaeuterung_zum_SD" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Indikatorbezug" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Mindestanzahl_Z" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Mindestanzahl_N" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Relevanz" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Hypothese" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Jahr_der_Erstanwendung" class="java.lang.String"/>    <field name="KN_Zusatzinfo_DV_Kommentar" class="java.lang.String"/>    <field name="refBereichInfoArt" class="java.lang.String"/>    <field name="refBereichOperator1" class="java.lang.String"/>    <field name="refBereichStringAusgabe" class="java.lang.String"/>    <field name="refBereichVorjahrInfoArt" class="java.lang.String"/>    <field name="refBereichVorjahrOperator1" class="java.lang.String"/>    <field name="refBereichVorjahrStringAusgabe" class="java.lang.String"/>    <field name="refBereichWert1" class="java.math.BigDecimal"/>    <field name="sortierung" class="java.lang.Integer"/>    <field name="veroeffentlichungsPflicht" class="java.lang.Integer"/>    <field name="idQI_id" class="java.lang.Integer"/>    <field name="KN_Vergleichbarkeit_Vorjahr" class="java.lang.String"/>    <field name="IMG_ID" class="java.lang.Integer"/>    <field name="Name" class="java.lang.String"/>    <field name="Image" class="java.awt.Image"/>    <variable name="someVar" class="java.lang.String">        <variableExpression><![CDATA[$V{someVar}]]></variableExpression>    </variable>    <variable name="tocVar" class="java.lang.String">        <variableExpression><![CDATA[$V{tocVar}]]></variableExpression>    </variable>    <group name="id" isStartNewPage="true" isReprintHeaderOnEachPage="true" keepTogether="true">        <groupExpression><![CDATA[$F{id}]]></groupExpression>        <groupHeader>            <band height="21"/>        </groupHeader>        <groupFooter>            <band height="36" splitType="Immediate"/>        </groupFooter>    </group>    <background>        <band splitType="Stretch"/>    </background>    <title>        <band height="521" splitType="Stretch">            <line>                <reportElement x="80" y="20" width="400" height="1" uuid="dab75733-7bb4-47bd-92cd-021d22411568"/>            </line>            <staticText>                <reportElement x="400" y="340" width="130" height="70" uuid="ae994f3a-16aa-466b-99b6-0cdb6546437f"/>                <textElement textAlignment="Right" markup="html"/>                <text><![CDATA[statistische Basisprüfung<br>Auffälligkeitskriterien:<br>Verstetigung und Vollzähligkeit 2015]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="400" y="410" width="130" height="30" uuid="d72dd2de-2edd-4fe0-a201-e4588bd0ef6c"/>                <textElement markup="none">                    <font isBold="true"/>                </textElement>                <textFieldExpression><![CDATA[$F{LB_LangBezeichnung}]]></textFieldExpression>            </textField>            <textField isStretchWithOverflow="true" pattern="d/M/yyyy">                <reportElement x="434" y="447" width="79" height="23" uuid="2fe7cd1f-9ffc-4691-a580-9639169ac883"/>                <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>            </textField>            <staticText>                <reportElement x="386" y="449" width="43" height="20" uuid="63bff184-13a9-4ed2-b9b2-a0d04ea25e88"/>                <text><![CDATA[stand: ]]></text>            </staticText>            <line>                <reportElement x="70" y="500" width="410" height="1" uuid="4a51126e-9144-451f-b6ba-87640a2889f1"/>            </line>            <break>                <reportElement x="0" y="520" width="550" height="1" uuid="ebfc5cc3-dc6d-4420-a748-78b3947a0d9f"/>            </break>            <image>                <reportElement x="432" y="98" width="50" height="50" uuid="d03444ee-c71b-431d-82c4-66eca87ade71">                    <printWhenExpression><![CDATA[$F{IMG_ID} == 1]]></printWhenExpression>                </reportElement>                <imageExpression><![CDATA[$F{Image}]]></imageExpression>            </image>        </band>    </title>    <pageHeader>        <band height="62" splitType="Stretch">            <staticText>                <reportElement x="8" y="2" width="409" height="26" uuid="37a242c0-b352-42e1-b287-42350a5e2090"/>                <textElement markup="html"/>                <text><![CDATA[statistische Basisprüfung - Auffälligkeitskriterien: Verstetigung und Vollzähligkeit 2015<br>]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="7" y="16" width="322" height="19" uuid="f28c3fc0-6d00-4437-a185-febccf94e91f"/>                <textElement markup="none"/>                <textFieldExpression><![CDATA[$F{idLb} +" - "+ $F{LB_LangBezeichnung}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="8" y="32" width="321" height="20" uuid="705007c1-4bfa-483a-a113-887cf7fd6488"/>                <textFieldExpression><![CDATA[$F{id}+": "+$F{KN_BezeichnungAlleinstehendKurz}]]></textFieldExpression>            </textField>            <image hAlign="Center">                <reportElement x="480" y="6" width="50" height="50" uuid="3f5fe998-e94e-4280-af71-7f7163878156">                    <printWhenExpression><![CDATA[$F{IMG_ID} == 1]]></printWhenExpression>                </reportElement>                <imageExpression><![CDATA[$F{Image}]]></imageExpression>            </image>        </band>    </pageHeader>    <columnHeader>        <band height="14" splitType="Stretch"/>    </columnHeader>    <detail>        <band height="50">            <printWhenExpression><![CDATA[1==0]]></printWhenExpression>            <textField>                <reportElement x="80" y="10" width="420" height="30" uuid="c38fb16c-2924-45f6-ba0d-eb230a5c0efb"/>                <textFieldExpression><![CDATA[$V{someVar}]]></textFieldExpression>            </textField>        </band>        <band height="121" splitType="Stretch">            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="61" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="3bea42be-d6e1-4ae3-b50b-e1bf40c09835"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[AK-Präfix]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="61" width="414" height="30" printWhenGroupChanges="id" uuid="104b3d59-130c-44b0-8421-0504c500ec1e">                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <box padding="5">                    <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>                <textElement>                    <font size="10" isBold="false"/>                </textElement>                <textFieldExpression><![CDATA[$F{praefix}]]></textFieldExpression>            </textField>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="91" width="414" height="30" printWhenGroupChanges="id" uuid="ca7c279e-c22a-4713-82d4-20fa8a297afa">                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <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>                <textElement>                    <font size="10" isBold="false"/>                </textElement>                <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>            </textField>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="91" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="a64eb43b-f9fd-485a-ab39-95eccae8b674">                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[AK-ID]]></text>            </staticText>            <textField evaluationTime="Group" evaluationGroup="id" hyperlinkType="Reference" bookmarkLevel="1">                <reportElement isPrintRepeatedValues="false" x="-4" y="37" width="534" height="20" printWhenGroupChanges="id" uuid="f6d9376f-7106-4292-b491-7229b297ce04"/>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{id}+": "+$F{KN_BezeichnungAlleinstehendKurz}]]></textFieldExpression>                <anchorNameExpression><![CDATA[$F{id}+":"+$F{KN_BezeichnungAlleinstehendKurz}]]></anchorNameExpression>                <hyperlinkReferenceExpression><![CDATA[$F{id}+": "+$F{KN_BezeichnungAlleinstehendKurz}]]></hyperlinkReferenceExpression>                <hyperlinkTooltipExpression><![CDATA[$F{id}.toString()]]></hyperlinkTooltipExpression>            </textField>        </band>        <band height="32">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="1" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="6ae315bf-592c-4619-b9ea-44574a9ca659">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Jahr der Erstanwendung]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement isPrintRepeatedValues="false" x="128" y="1" width="414" height="30" printWhenGroupChanges="id" uuid="3628f14b-97d0-492a-80af-7ab53449844f">                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <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>                <textElement>                    <font size="10" isBold="false"/>                </textElement>                <textFieldExpression><![CDATA[$F{KN_Zusatzinfo_DV_Jahr_der_Erstanwendung}]]></textFieldExpression>            </textField>        </band>        <band height="30">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="dc4dfb7b-f859-4804-9616-cfafcf3dea84">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[begründung für die Auswahl]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="30" printWhenGroupChanges="id" uuid="f51d75fc-bfc3-42fd-8861-682472654b69">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA["<b>Relevanz</b><br>" +($F{KN_Zusatzinfo_DV_Relevanz} !=null ? $F{KN_Zusatzinfo_DV_Relevanz} : "-")]]></textFieldExpression>            </textField>        </band>        <band height="25">            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="25" printWhenGroupChanges="id" uuid="bb889911-7d1c-4acd-abac-32f1dbc83b11">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA["<b>Hypothese</b><br>" + ($F{KN_Zusatzinfo_DV_Hypothese} !=null ? $F{KN_Zusatzinfo_DV_Hypothese}: "-")]]></textFieldExpression>            </textField>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="25" forecolor="#FFFFFF" backcolor="#005051" uuid="336f071c-3d66-4d5f-bcfa-da262ef5cec9">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <box>                    <topPen lineWidth="0.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>                <text><![CDATA[]]></text>            </staticText>        </band>        <band height="30">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="ea5824ca-a03f-44a9-bdf5-444fa3813ca8">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[bezug zu anderen Indikatoren]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="30" printWhenGroupChanges="id" uuid="de44716d-515c-4d56-aceb-6451cfa50c0a">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[($F{KN_Zusatzinfo_DV_Indikatorbezug} !=null ? $F{KN_Zusatzinfo_DV_Indikatorbezug} : "-")]]></textFieldExpression>            </textField>        </band>        <band height="20" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="20" forecolor="#FFFFFF" backcolor="#005051" uuid="86f2905b-6799-48a0-be37-ff86ca8aa79d"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[bewertungsart]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="20" printWhenGroupChanges="id" uuid="48b31380-d48b-431c-90ba-47df17b863dc">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{bewertungsArtTypNameKurz}]]></textFieldExpression>            </textField>        </band>        <band height="25" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="pixel"/>            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="25" forecolor="#FFFFFF" backcolor="#005051" uuid="5c698117-f797-4698-9ad2-aafaa211ac7a">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Referenzbereich 2015]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="25" printWhenGroupChanges="id" uuid="e9948ea5-2651-40e2-90ed-13411cf70ca9"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{refBereichOperator1}]]></textFieldExpression>            </textField>        </band>        <band height="30">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="30" forecolor="#FFFFFF" backcolor="#005051" uuid="3279bef0-68bb-4cf3-bdd6-0d9104a61199"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Referenzbereich 2014]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="30" printWhenGroupChanges="id" uuid="7c641997-0d9e-4306-b4a5-e93adda4333c">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA["refbereich2014"]]></textFieldExpression>            </textField>        </band>        <band height="44">            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="44" forecolor="#FFFFFF" backcolor="#005051" uuid="bb2073be-e698-4e87-9818-0fac84756390"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Erläuterung zum Referenzbereich 2015]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="44" printWhenGroupChanges="id" uuid="940bb0a0-9c46-4c62-bffa-113b9fb40652">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[($F{KN_Zusatzinfo_Erlaeuterung_Refbereich} != null ?  $F{KN_Zusatzinfo_Erlaeuterung_Refbereich} : "-")]]></textFieldExpression>            </textField>        </band>        <band height="33">            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="33" forecolor="#FFFFFF" backcolor="#005051" uuid="342fe73d-487b-4b00-8262-4c44a30eecfb">                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>                </reportElement>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Erläuterung zum Dialog 2015]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="33" printWhenGroupChanges="id" uuid="1fe53a2b-5ce7-4c35-b0fd-da194fe95b67">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{KN_Zusatzinfo_Erlaeuterung_zum_SD} !=null ? $F{KN_Zusatzinfo_Erlaeuterung_zum_SD} : "-"]]></textFieldExpression>            </textField>        </band>        <band height="35">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="35" forecolor="#FFFFFF" backcolor="#005051" uuid="51adbf5a-a1e8-475d-b2a7-a034e914a6e9"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Rechenregeln]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="35" printWhenGroupChanges="id" uuid="dccb310c-8b02-4dff-9aca-9a35b38ec3a5"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA["<b>Zähler</b><br>"+$F{KN_ZAlleinstehend}]]></textFieldExpression>            </textField>        </band>        <band height="29">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="29" printWhenGroupChanges="id" uuid="de2daa0e-3333-4b07-8fb1-544d1360e133"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA["<b>Nenner</b><br>"+$F{KN_GGAlleinstehend}]]></textFieldExpression>            </textField>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="29" forecolor="#FFFFFF" backcolor="#005051" uuid="78b52e97-3c5e-4e77-a9d1-5a8d81bb6e8b">                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                </reportElement>                <box>                    <topPen lineWidth="0.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>                <text><![CDATA[]]></text>            </staticText>        </band>        <band height="39">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="39" forecolor="#FFFFFF" backcolor="#005051" uuid="9b2b0077-44c0-490f-9979-2c4651c64e6f"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Erläuterung der Rechenregel]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="39" printWhenGroupChanges="id" uuid="2b195991-c939-4cdd-b653-ff90df128090"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{KN_Zusatzinfo_Erlaeuterung_Rechenregel}]]></textFieldExpression>            </textField>        </band>        <band height="33">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="33" forecolor="#FFFFFF" backcolor="#005051" uuid="942cda1b-573d-41a6-89e2-462805a1d735"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Teildatensatzbezug]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="33" printWhenGroupChanges="id" uuid="136b8015-5b7d-4f40-92d1-67e5b148cffc"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{teildatensatzbezug}]]></textFieldExpression>            </textField>        </band>        <band height="37">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="37" forecolor="#FFFFFF" backcolor="#005051" uuid="8ff5988c-89b0-409d-85b1-f34cb8b5cbf5"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Mindesanzahl Zähler]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="37" printWhenGroupChanges="id" uuid="effd266c-efbc-495e-a5b4-42271215d471"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{mindesanzahlZaeler}]]></textFieldExpression>            </textField>        </band>        <band height="28">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="28" forecolor="#FFFFFF" backcolor="#005051" uuid="19dc11f1-036c-4643-a5d9-500823ce8b9e"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Mindesanzahl Nenner]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="28" printWhenGroupChanges="id" uuid="fbd88128-9d15-44ee-ba24-9bf4e8ccb129"/>                <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>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$F{mindesanzahlNenner}]]></textFieldExpression>            </textField>        </band>        <band height="25">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="127" height="25" forecolor="#FFFFFF" backcolor="#005051" uuid="3edb0919-a19d-4e45-aba4-e94b1ac433d3"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Zähler (Formel)]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="25" printWhenGroupChanges="id" uuid="83619da0-58da-4c59-a7c7-dd62f84e4f81">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html">                    <paragraph lineSpacing="1_1_2"/>                </textElement>                <textFieldExpression><![CDATA[$F{KN_FormelZ}]]></textFieldExpression>            </textField>        </band>        <band height="25">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="1" width="127" height="23" forecolor="#FFFFFF" backcolor="#005051" uuid="b1d7623f-82b2-48b8-8d54-26a10e6de1bb"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Nenner (Formel)]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="25" printWhenGroupChanges="id" uuid="39e11c34-7a23-404c-899b-9ce85e43eddd">                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                </reportElement>                <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>                <textElement markup="html">                    <paragraph lineSpacing="1_1_2"/>                </textElement>                <textFieldExpression><![CDATA[$F{KN_FormelGG}]]></textFieldExpression>            </textField>        </band>        <band height="25">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="25" forecolor="#FFFFFF" backcolor="#005051" uuid="3f8dcfa7-d60b-4975-af7a-c3d4550832dd"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Verwendete Funktionen]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="25" printWhenGroupChanges="id" uuid="b91757bc-552d-4bdf-9691-cdc553f72d5c"/>                <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>                <textElement markup="html">                    <paragraph lineSpacing="Single"/>                </textElement>                <textFieldExpression><![CDATA[$F{verwendeteFunktionen}]]></textFieldExpression>            </textField>        </band>        <band height="69">            <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression>            <staticText>                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="127" height="29" forecolor="#FFFFFF" backcolor="#005051" uuid="6c3ddd72-815e-4a53-8b2a-24330740e597"/>                <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                    <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>                <text><![CDATA[Vergleichbarkeit mit Vorjahresergebnissen]]></text>            </staticText>            <textField isStretchWithOverflow="true">                <reportElement x="128" y="0" width="414" height="30" printWhenGroupChanges="id" uuid="f51634f5-261b-4d2a-a750-55e4f59f6a5c"/>                <box leftPadding="6">                    <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>                <textElement markup="html">                    <font isBold="true"/>                </textElement>                <textFieldExpression><![CDATA[$F{KN_Vergleichbarkeit_Vorjahr}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="200" y="32" width="126" height="36" uuid="03db01ad-c46e-4d32-9056-6edb17ad582e"/>                <textElement markup="none"/>                <textFieldExpression><![CDATA[$P{toc}.append(    $F{id}.toString()+": "+$F{KN_BezeichnungAlleinstehendKurz}.replaceAll("&","&").replaceAll("<", "<").replaceAll(">", ">")        + new String( new char [90 -  Math.min ($F{KN_BezeichnungAlleinstehendKurz}.length(),90)]).replaceAll(".", ".")        + $V{PAGE_NUMBER}        + "<br>") == null ? "" : ""]]></textFieldExpression>            </textField>        </band>    </detail>    <columnFooter>        <band height="13" splitType="Stretch"/>    </columnFooter>    <pageFooter>        <band height="54" splitType="Stretch">            <staticText>                <reportElement x="0" y="20" width="410" height="20" uuid="0744ba3c-69d3-4220-b201-72dabdeb5038"/>                <textElement>                    <font size="8"/>                </textElement>                <text><![CDATA[© 2016 IQTIG – Institut für Qualitätssicherung und Transparenz im Gesundheitswesen]]></text>            </staticText>            <textField evaluationTime="Master">                <reportElement x="481" y="18" width="69" height="24" uuid="5789c6a7-2ca2-4ba9-bd13-1b56ddcb7091"/>                <textFieldExpression><![CDATA["Seite "+$V{MASTER_CURRENT_PAGE}+" von"+$V{MASTER_TOTAL_PAGES}]]></textFieldExpression>            </textField>        </band>    </pageFooter>    <summary>        <band height="206" splitType="Stretch">            <staticText>                <reportElement x="7" y="10" width="70" height="21" uuid="6604fff5-c645-41b7-a31d-774a3fd181ff"/>                <text><![CDATA[TOC]]></text>            </staticText>            <textField isStretchWithOverflow="true" evaluationTime="Report" hyperlinkType="" hyperlinkTarget="">                <reportElement stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="10" y="60" width="520" height="130" isRemoveLineWhenBlank="true" uuid="99a78ebe-2291-485b-97ce-c2e56bdeb14c"/>                <textElement markup="html"/>                <textFieldExpression><![CDATA[$P{toc}]]></textFieldExpression>            </textField>            <textField hyperlinkType="" hyperlinkTarget="">                <reportElement x="190" y="10" width="122" height="30" uuid="21593bcb-a2f8-4e86-9974-5d7dbe79d83f"/>                <textFieldExpression><![CDATA[$P{moveTOC_SCRIPTLET}.hello()]]></textFieldExpression>            </textField>        </band>    </summary></jasperReport>[/code]

 

 

 

Link to comment
Share on other sites

Why did you create all these detail sections? Should have increased a detailed section to hold all rows and put all rows there. If you want a page break after each form, put a "break" component or create a group that's just fetch each row and check to create a new page.

Link to comment
Share on other sites

I have changed the sturcture and I have one detail now. But the problem with redundant data is still there! When i go to Dataset and query dialog and then data preview, after refreshing the data I see two times more data fields as there are! And my report book has double pages more than the report itself!

 

Link to comment
Share on other sites

Well, I have found the problem reason. It happens when I add the report book and write a query for that. Why should I write a new query in report book, although I add the compiled jasper report to it? If I do not write a query for report book the report will not compile and says document is empty.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...