redundant data fields in jasperstudio

0

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

iman.gharib's picture
Joined: Nov 18 2015 - 3:46am
Last seen: 2 months 1 week ago

6 Answers:

0

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.

 

hozawa's picture
69172
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 7 months ago
0

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

select distinct *
from KennzahlReferenz2015_QIBericht, Images
where
LB_ID = $P{LB_ID} 
and
KN_OffiziellGruppe =$P{KN_OffeziellGruppe}
and IMG_ID = 1

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, Images
where
LB_ID = $P{LB_ID} 
and
KN_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("&","&amp;").replaceAll("<", "&lt;").replaceAll(">", "&gt;")
        + 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>

iman.gharib's picture
Joined: Nov 18 2015 - 3:46am
Last seen: 2 months 1 week ago
1

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.

hozawa's picture
69172
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 7 months ago
0

I am changing the report so that all can be in one detail. But still running the SQL request delivers double fields using jasper Dataset and Query Dialog box - Data Preview (bottom tab) - Refresh Preview Data

iman.gharib's picture
Joined: Nov 18 2015 - 3:46am
Last seen: 2 months 1 week ago
0

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!

 

iman.gharib's picture
Joined: Nov 18 2015 - 3:46am
Last seen: 2 months 1 week ago
0

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.

iman.gharib's picture
Joined: Nov 18 2015 - 3:46am
Last seen: 2 months 1 week ago
Feedback
randomness