view artifacts/doc/conf/jasper/templates/bundu.bezugswst.result2.jrxml @ 9503:83e6acdf8fc6

Fixed: no rounding during calculations (Meilenstein-2 2.9)
author mschaefer
date Fri, 28 Sep 2018 10:11:06 +0200
parents a8d1784ad8e8
children
line wrap: on
line source
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 4.5.0  -->
<!-- 2018-07-31T13:53:15 -->
<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="842" pageHeight="595" orientation="Landscape" columnWidth="762" 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"/>
	<style name="htmlStyle" isDefault="true" mode="Transparent" markup="html" fontName="Roboto" fontSize="8">
		<paragraph lineSpacing="Single"/>
	</style>
	<field name="meta:totalpages" class="java.lang.Integer"/>
	<field name="meta:startpageoffset" class="java.lang.Integer"/>
	<field name="meta:header" class="java.lang.String"/>
	<field name="meta:calcMode" class="java.lang.String"/>
	<field name="meta:version_label" class="java.lang.String"/>
	<field name="meta:version" class="java.lang.String"/>
	<field name="meta:user_label" class="java.lang.String"/>
	<field name="meta:user" class="java.lang.String"/>
	<field name="meta:date_label" class="java.lang.String"/>
	<field name="meta:date" class="java.lang.String"/>
	<field name="meta:river_label" class="java.lang.String"/>
	<field name="meta:river" class="java.lang.String"/>
	<field name="meta:range_label" class="java.lang.String"/>
	<field name="meta:range" class="java.lang.String"/>
	<field name="meta:calculation_label" class="java.lang.String"/>
	<field name="meta:calculation_name" class="java.lang.String"/>
	<field name="meta:station_header" class="java.lang.String"/>
	<field name="meta:flowdepthdevelopment_header" class="java.lang.String"/>
	<field name="meta:flowdepthdevelopmentperyear_header" class="java.lang.String"/>
	<field name="meta:waterleveldifference_header" class="java.lang.String"/>
	<field name="meta:waterleveldifference_header2" class="java.lang.String"/>
	<field name="meta:waterleveldifference_header_label" class="java.lang.String"/>
	<field name="meta:bedheightdifference_header" class="java.lang.String"/>
	<field name="meta:bedheightdifference_header2" class="java.lang.String"/>
	<field name="meta:bedheightdifference_header_label" class="java.lang.String"/>
	<field name="meta:flowdepthcurrent_header" class="java.lang.String"/>
	<field name="meta:flowdepthcurrent_header2" class="java.lang.String"/>
	<field name="meta:flowdepthhistorical_header" class="java.lang.String"/>
	<field name="meta:flowdepthhistorical_header2" class="java.lang.String"/>
	<field name="meta:flowdepthcurrent_header_label" class="java.lang.String"/>
	<field name="meta:flowdepthhistorical_header_label" class="java.lang.String"/>
	<field name="meta:flowdepth_header" class="java.lang.String"/>
	<field name="meta:flowdepthdevelopment" class="java.lang.String"/>
	<field name="meta:flowdepthmin_header" class="java.lang.String"/>
	<field name="meta:flowdepthmax_header" class="java.lang.String"/>
	<field name="meta:flowdepthdevelopment_header_label" class="java.lang.String"/>
	<field name="meta:flowdepth_tkh_header" class="java.lang.String"/>
	<field name="meta:tkh_header" class="java.lang.String"/>
	<field name="meta:tkhkind_header" class="java.lang.String"/>
	<field name="meta:waterlevel_header" class="java.lang.String"/>
	<field name="meta:discharge_header" class="java.lang.String"/>
	<field name="meta:waterlevel_name_header" class="java.lang.String"/>
	<field name="meta:gauge_header" class="java.lang.String"/>
	<field name="meta:bedheight_header" class="java.lang.String"/>
	<field name="meta:sounding_name_header" class="java.lang.String"/>
	<field name="meta:location_header" class="java.lang.String"/>
	<field name="meta:river_unit" class="java.lang.String"/>
	<field name="meta:riverside_header" class="java.lang.String"/>
	<field name="meta:inundationduration_header" class="java.lang.String"/>
	<field name="meta:inundationduration_q_header" class="java.lang.String"/>
	<field name="meta:infrastructure_height_header" class="java.lang.String"/>
	<field name="meta:infrastructure_type_header" class="java.lang.String"/>
	<field name="meta:w_1_header" class="java.lang.String"/>
	<field name="meta:q_1_header" class="java.lang.String"/>
	<field name="meta:bezeichnung_1_header" class="java.lang.String"/>
	<field name="meta:duration_1_header" class="java.lang.String"/>
	<field name="meta:w_2_header" class="java.lang.String"/>
	<field name="meta:q_2_header" class="java.lang.String"/>
	<field name="meta:bezeichnung_2_header" class="java.lang.String"/>
	<field name="meta:duration_2_header" class="java.lang.String"/>
	<field name="meta:w_3_header" class="java.lang.String"/>
	<field name="meta:q_3_header" class="java.lang.String"/>
	<field name="meta:bezeichnung_3_header" class="java.lang.String"/>
	<field name="meta:duration_3_header" class="java.lang.String"/>
	<field name="meta:bezugswst_result_header" class="java.lang.String"/>
	<field name="meta:bezugswst_header" class="java.lang.String"/>
	<field name="meta:sounding_header" class="java.lang.String"/>
	<field name="meta:channel_lower_edge_header" class="java.lang.String"/>
	<field name="meta:channel_min_depth_header" class="java.lang.String"/>
	<field name="meta:channel_miss_depth_header" class="java.lang.String"/>
	<field name="meta:channel_miss_volume_header" class="java.lang.String"/>
	<field name="meta:channel_miss_mass_header" class="java.lang.String"/>
	<field name="meta:excavation_volume_header" class="java.lang.String"/>
	<field name="meta:excavation_costs_header" class="java.lang.String"/>
	<field name="meta:channel_width_header" class="java.lang.String"/>
	<field name="meta:density_header" class="java.lang.String"/>
	<field name="meta:mean_bedheight_header" class="java.lang.String"/>
	<field name="meta:field_header1" class="java.lang.String"/>
	<field name="meta:field_header2" class="java.lang.String"/>
	<field name="meta:field_header3" class="java.lang.String"/>
	<field name="meta:field_header4" class="java.lang.String"/>
	<field name="meta:field_header5" class="java.lang.String"/>
	<field name="meta:field_header6" class="java.lang.String"/>
	<field name="meta:field_header7" class="java.lang.String"/>
	<field name="meta:field_header8" class="java.lang.String"/>
	<field name="meta:field_header9" class="java.lang.String"/>
	<field name="meta:field_header10" class="java.lang.String"/>
	<field name="data:0" class="java.lang.String"/>
	<field name="data:1" class="java.lang.String"/>
	<field name="data:2" class="java.lang.String"/>
	<field name="data:3" class="java.lang.String"/>
	<field name="data:4" class="java.lang.String"/>
	<field name="data:5" class="java.lang.String"/>
	<field name="data:6" class="java.lang.String"/>
	<field name="data:7" class="java.lang.String"/>
	<field name="data:8" class="java.lang.String"/>
	<field name="data:9" class="java.lang.String"/>
	<field name="data:10" class="java.lang.String"/>
	<field name="data:11" class="java.lang.String"/>
	<field name="data:12" class="java.lang.String"/>
	<field name="data:13" class="java.lang.String"/>
	<field name="data:14" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="30" splitType="Stretch">
			<textField>
				<reportElement style="htmlStyle" x="0" y="0" width="515" height="30"/>
				<textElement>
					<font size="18"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{meta:bezugswst_result_header}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<line>
				<reportElement style="htmlStyle" positionType="FixRelativeToBottom" x="-36" y="24" width="805" height="1"/>
			</line>
			<textField isStretchWithOverflow="true">
				<reportElement style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="-36" y="0" width="65" height="24">
					<property name="net.sf.jasperreports.text.hyphenation" value="true"/>
					<property name="net.sf.jasperreports.text.save.line.breaks" value="true"/>
					<property name="net.sf.jasperreports.export.xls.wrap.text" value="true"/>
				</reportElement>
				<box padding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:station_header}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="29" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header1}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="94" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header2}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="159" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header3}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="224" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header4}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="289" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header5}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="354" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header6}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="419" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header7}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="484" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header8}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="549" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header9}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="614" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:field_header10}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="679" y="0" width="65" height="24"/>
				<box padding="2"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{meta:mean_bedheight_header}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Prevent">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="-36" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top"/>
				<textFieldExpression><![CDATA[$F{data:0}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="29" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:1}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="94" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:2}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="159" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:3}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="224" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:4}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="289" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:5}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="354" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:6}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="419" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:7}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="484" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:8}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="549" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:9}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="614" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:10}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="" style="htmlStyle" positionType="Float" stretchType="RelativeToBandHeight" x="679" y="0" width="65" height="15"/>
				<box padding="2">
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{data:11}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="15" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement style="htmlStyle" x="634" y="0" width="55" height="15"/>
				<box topPadding="2" rightPadding="3"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER} +(($F{meta:startpageoffset} != null) ? $F{meta:startpageoffset} : 0 )]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" evaluationTime="Report">
				<reportElement style="htmlStyle" x="690" y="0" width="57" height="15"/>
				<box topPadding="2" leftPadding="0" bottomPadding="0" rightPadding="0"/>
				<textFieldExpression><![CDATA["/ " + ( $V{PAGE_NUMBER}+( ($F{meta:totalpages} != null) ? $F{meta:totalpages} -$V{PAGE_NUMBER} : 0 ) )]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>

http://dive4elements.wald.intevation.org