iman.gharib

I got this answer from stackoverflows: http://stackoverflow.com/a/37725804/4262423

I have a structure like bellow which consist of one static text and two text fields. The text fields should expand relative to their content. I need to adjust them in a way that these three elements expand together. Should I keep them in one band? What should be the stretch type for each? Static Text Text field onetext field two

Is it possible to rotate the table by 90° or I should use text fields instead of table for this purpose? table component creates table like bellow Text1Text2Value1Value2I need something like this one: Text1Value1Text2Value2regards

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

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]

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]

I have created a report book, but the table of content is shown with dots as in photo above. The hyperlink which is used to create the TOC is: <band height="52"> <textField evaluationTime="Group" evaluationGroup="id" hyperlinkType="Reference" bookmarkLevel="1"> <reportElement isPrintRepeatedValues="false" x="8" y="32" width="534" height="20" printWhenGroupChanges="id" uuid="f6d9376f-7106-4292-b491-7229b297ce04"/> <textElement markup="html"/> <textFieldExpression><![CDATA[$F{id}+": "+$F{KN_bk}]]></textFieldExpression> <anchorNameExpression><![CDATA[$F{id}+": "+$F{KN_bk}]]></anchorNameExpression> <hyperlinkReferenceExpression><![CDATA[$F{id}+": "+$F{KN_bk}]]></hyperlinkReferenceExpression> <hyperlinkTooltipExpression><![CDATA[$F{id}.toString()]]></hyperlinkTooltipExpression> </textField> </band>[/code]Hovering the mouse on the dots shows the real text which should be presented but not the page nummber! Would you please tell me where should i look for solving this problem?

I am still struggling moving my summary to the top using scriptlet. Is there any sample code for this? My TOC is placed at the summary and I want to move it to the top. I have read that it is possible using Jasperprint but I need an example for doing it. regards Iman

How can I create the toc using scriptlets?

I am appending the contentn of my table of content like here:http://rolandtapken.de/blog/2013-04/jasperreports-append-report-toc-without-scriplets Now I have my TOc at the summary band. How can I move to the second page? thanks

I am trying to find out if it is possible to get the most out of jasperstudio without any java code. At some points it seems that i com to the limits for example by creating table of contents and filling tables with data from database. I want to find a solution, which make it possible for a user without any java knowledge and only with SQL knowledge to make reports. Is it possible with jasper? If not dose anyone know if it is possible to program the needed java classes and bind the jar files to the jasperstudio and at the compile time jasper runs those jars? In this way the person without java knowledge who is meant to work jasper does his part and for parts like table of content and more complicated reports he can use the java classes inside the jasperreport . Thanks