view artifacts/doc/conf/jasper/beddifference.jrxml @ 9713:aef987124822 3.2.x

Do not rely on database default for setting hws_lines.official to 0 It's not under the control of the importer whether the field is rendered into an INSERT statement, whether it's actually set or not. If it is unset but rendered into the statement, the field would be set to NULL. Thus, always set it explicitly. While here, remove an unused import.
author Tom Gottfried <tom@intevation.de>
date Fri, 12 Mar 2021 15:11:44 +0100
parents ff33c24c2b64
children
line wrap: on
line source
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="flysreport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="515" leftMargin="60" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<field name="river" class="java.lang.String"/>
	<field name="diff" class="java.lang.String"/>
	<field name="date" class="java.lang.String"/>
	<field name="calculation" class="java.lang.String"/>
	<field name="differences" class="java.lang.String"/>
	<field name="km" class="java.lang.String"/>
	<field name="diffheader" class="java.lang.String"/>
	<field name="diffpairheader" class="java.lang.String"/>
	<field name="diffpair" class="java.lang.String"/>
	<field name="sounding1header" class="java.lang.String"/>
	<field name="sounding1" class="java.lang.String"/>
	<field name="sounding2header" class="java.lang.String"/>
	<field name="sounding2" class="java.lang.String"/>
	<field name="kmheader" class="java.lang.String"/>
	<field name="gap1header" class="java.lang.String"/>
	<field name="gap1" class="java.lang.String"/>
	<field name="gap2header" class="java.lang.String"/>
	<field name="gap2" class="java.lang.String"/>
	<field name="range" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="155" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="1" width="177" height="30"/>
				<textElement>
					<font size="18"/>
				</textElement>
				<text><![CDATA[Ergebnisausgabe]]></text>
			</staticText>
			<textField>
				<reportElement x="177" y="0" width="338" height="31"/>
				<textElement>
					<font size="18"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{river}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="31" width="515" height="26"/>
				<textElement>
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{calculation}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="70" width="123" height="20"/>
				<textElement/>
				<text><![CDATA[Gewässer:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="70" width="392" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{river}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="90" width="123" height="20"/>
				<textElement/>
				<text><![CDATA[Datum der Erstellung:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="90" width="392" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="109" width="123" height="20"/>
				<textElement/>
				<text><![CDATA[Bereich:]]></text>
			</staticText>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="123" y="109" width="392" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{range}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="123" y="129" width="392" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{differences}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="129" width="123" height="20"/>
				<textElement/>
				<text><![CDATA[Differenzen:]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="24" splitType="Stretch">
			<line>
				<reportElement x="0" y="19" width="515" height="1"/>
			</line>
			<textField>
				<reportElement x="0" y="0" width="54" height="20"/>
				<textElement markup="none"/>
				<textFieldExpression><![CDATA[$F{kmheader}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="174" y="0" width="75" height="19"/>
				<textElement markup="none"/>
				<textFieldExpression><![CDATA[$F{diffheader}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="54" y="0" width="120" height="19"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{diffpairheader}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="249" y="1" width="75" height="19"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{sounding1header}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="324" y="0" width="75" height="19"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{sounding2header}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="399" y="1" width="58" height="19"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{gap1header}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="457" y="0" width="58" height="19"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{gap2header}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="54" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{km}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="174" y="0" width="75" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{diff}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="54" y="0" width="120" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{diffpair}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="249" y="0" width="75" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{sounding1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="324" y="0" width="75" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{sounding2}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="399" y="0" width="58" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{gap1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="457" y="0" width="58" height="14"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{gap2}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="29" splitType="Stretch">
			<textField evaluationTime="Report">
				<reportElement x="457" y="9" width="57" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[" / " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="402" y="9" width="55" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>

http://dive4elements.wald.intevation.org