Mercurial > dive4elements > river

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 4eb1a3c71579
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.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="43"/>
	<parameter name="MEASUREMENT_PAGE_NUM" class="java.lang.Integer"/>
	<field name="river" class="java.lang.String"/>
	<field name="periods" class="java.lang.String"/>
	<field name="outliertest" class="java.lang.String"/>
	<field name="date" class="java.lang.String"/>
	<field name="outliers" class="java.lang.String"/>
	<field name="calculation" class="java.lang.String"/>
	<field name="total" class="java.lang.String"/>
	<field name="out" class="java.lang.String"/>
	<field name="location" class="java.lang.String"/>
	<field name="sd" class="java.lang.String"/>
	<field name="a" class="java.lang.String"/>
	<field name="b" class="java.lang.String"/>
	<field name="km" class="java.lang.String"/>
	<field name="param" class="java.lang.String"/>
	<field name="qmax" class="java.lang.String"/>
	<field name="cduan" class="java.lang.String"/>
	<field name="cferg" class="java.lang.String"/>
	<field name="r2" class="java.lang.String"/>
	<field name="msGauge" class="java.lang.String"/>
	<field name="msName" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="231" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="1" width="177" height="30"/>
				<textElement>
					<font size="18"/>
				</textElement>
				<text><![CDATA[Calculation result]]></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 verticalAlignment="Middle"/>
				<text><![CDATA[River:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="70" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{river}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="90" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Location]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="90" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{location}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="150" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Date of creation:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="150" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="170" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Periods:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="170" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{periods}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="190" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Outliertest:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="190" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{outliertest}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="210" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Outliers:]]></text>
			</staticText>
			<textField>
				<reportElement x="123" y="210" width="392" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{outliers}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement x="123" y="110" width="392" height="20" isRemoveLineWhenBlank="true"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{msName}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="130" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[hdyr. Reference Gauge:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="110" width="123" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Measurement Station:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement x="123" y="130" width="392" height="20" isRemoveLineWhenBlank="true"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{msGauge}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<line>
				<reportElement x="0" y="19" width="515" height="1"/>
			</line>
			<staticText>
				<reportElement x="94" y="0" width="60" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[a]]></text>
			</staticText>
			<staticText>
				<reportElement x="391" y="0" width="44" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[n <sub>outlier</sub>]]></text>
			</staticText>
			<staticText>
				<reportElement x="470" y="0" width="45" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[C <sub>Ferguson</sub>]]></text>
			</staticText>
			<staticText>
				<reportElement x="435" y="0" width="35" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[C<sub>Duan</sub>]]></text>
			</staticText>
			<staticText>
				<reportElement x="265" y="0" width="60" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[Q<sub>max,measured</sub>]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="0" width="39" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[R-km	]]></text>
			</staticText>
			<staticText>
				<reportElement x="325" y="0" width="26" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[r²]]></text>
			</staticText>
			<staticText>
				<reportElement x="351" y="0" width="40" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[n<sub>total</sub>]]></text>
			</staticText>
			<staticText>
				<reportElement x="189" y="0" width="76" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[Standard err]]></text>
			</staticText>
			<staticText>
				<reportElement x="154" y="0" width="35" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[b]]></text>
			</staticText>
			<staticText>
				<reportElement x="39" y="0" width="55" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Parameter]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="14" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="435" y="0" width="35" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{cduan}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="391" y="0" width="44" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{out}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="154" y="0" width="35" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{b}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="39" y="0" width="55" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{param}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="39" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{km}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="470" y="0" width="45" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{cferg}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="94" y="0" width="60" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{a}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="189" y="0" width="76" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{sd}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="265" y="0" width="60" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{qmax}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="351" y="0" width="40" height="14" isPrintWhenDetailOverflows="true"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{total}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="325" y="0" width="26" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{r2}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="29" splitType="Stretch">
			<textField evaluationTime="Report">
				<reportElement x="458" y="9" width="57" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[" / " + ($V{PAGE_NUMBER} + $P{MEASUREMENT_PAGE_NUM})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="403" 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