view artifacts/doc/conf/jasper/sqmeasurements.jrxml @ 8605:b0e5a2ce0b09

(issue1750) Fix id handling with oracle On oracle the id is returned as BigDecimal. This could probably be done better with hibernate but checking the Object also works.
author Andre Heinecke <andre.heinecke@intevation.de>
date Fri, 20 Mar 2015 18:42:00 +0100
parents 4eb1a3c71579
children c985b27e3a8c
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="167"/>
	<property name="ireport.y" value="0"/>
	<subDataset name="dataset1"/>
	<field name="date" class="java.lang.String"/>
	<field name="param" class="java.lang.String"/>
	<field name="transport" class="java.lang.String"/>
	<field name="discharge" class="java.lang.String"/>
	<field name="outlier" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="31" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="1" width="177" height="30"/>
				<textElement>
					<font size="18"/>
				</textElement>
				<text><![CDATA[Basisdaten]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="23" splitType="Stretch">
			<line>
				<reportElement x="0" y="19" width="515" height="1"/>
			</line>
			<staticText>
				<reportElement x="0" y="0" width="60" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Parameter]]></text>
			</staticText>
			<staticText>
				<reportElement x="60" y="0" width="115" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Transport in [kg/s]]]></text>
			</staticText>
			<staticText>
				<reportElement x="175" y="0" width="115" height="20"/>
				<textElement verticalAlignment="Middle"/>
				<text><![CDATA[Abfluss in [m³/s]]]></text>
			</staticText>
			<staticText>
				<reportElement x="288" y="0" width="104" height="20"/>
				<textElement verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[Datum der Messung]]></text>
			</staticText>
			<staticText>
				<reportElement x="392" y="0" width="123" height="20"/>
				<textElement textAlignment="Left" verticalAlignment="Middle" markup="styled"/>
				<text><![CDATA[Ausreißer in Durchgang]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="17" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="288" y="0" width="104" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="60" height="14"/>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{param}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="60" y="0" width="115" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{transport}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="175" y="0" width="113" height="14"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{discharge}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="392" y="0" width="123" height="14"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{outlier}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="30" splitType="Stretch">
			<textField evaluationTime="Report">
				<reportElement x="458" y="9" width="57" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[" / " + ($V{PAGE_NUMBER} + 1)]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="403" y="9" width="55" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER} + 1]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>

http://dive4elements.wald.intevation.org