<?xml version="1.0" encoding="UTF-8" standalone="no"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" bottomMargin="0" columnWidth="782" language="groovy" leftMargin="0" name="177_Liefertermintreue" pageHeight="595" pageWidth="782" rightMargin="0" topMargin="0" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd">
	<property name="ireport.zoom" value="1.366026910730141"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="table">
		<box>
			<pen lineColor="#000000" lineWidth="1.0"/>
		</box>
	</style>
	<style backcolor="#F0F8FF" mode="Opaque" name="table_TH">
		<box>
			<pen lineColor="#000000" lineWidth="0.5"/>
		</box>
	</style>
	<style backcolor="#BFE1FF" mode="Opaque" name="table_CH">
		<box>
			<pen lineColor="#000000" lineWidth="0.5"/>
		</box>
	</style>
	<style backcolor="#FFFFFF" mode="Opaque" name="table_TD">
		<box>
			<pen lineColor="#000000" lineWidth="0.5"/>
		</box>
	</style>
	<subDataset name="Table Dataset 1"/>
	<parameter class="java.lang.String" name="MNFIRM">
		<defaultValueExpression><![CDATA["100"]]></defaultValueExpression>
	</parameter>
	<parameter class="java.lang.String" isForPrompting="false" name="SQL_80"/>
	<queryString>
		<![CDATA[select KZGD2G as Jahr, KZGD1G as Monat, CASE WHEN KZGD3G = '' THEN 'keine Produktgr.' ELSE KZGD3G END as Produktgruppe, KZGD1V as Verzug0, KZGD2V as Verzug1, KZGD3V as Verzug2, KZGD4V as Verzug3 from IKENZP where KZGDGK = 'LIEFERTERMINTREUE' and KZFIRM = $P{MNFIRM} AND KZDATU = 	(select max(KZDATU) 	from IKENZP 	where KZFIRM = $P{MNFIRM} 	AND KZGDGK = 'LIEFERTERMINTREUE') and ( KZGD1V<>0 or KZGD2V <>0 or KZGD3V <>0 or KZGD4V <>0) and KZGD2G >= YEAR(DATEADD(yy,-1,getdate())) order by KZDATU, KZGD2G,CAST(KZGD1G AS INT), KZGD3G]]>
	</queryString>
	<field class="java.lang.String" name="Jahr"/>
	<field class="java.lang.String" name="Monat"/>
	<field class="java.lang.String" name="Produktgruppe"/>
	<field class="java.math.BigDecimal" name="Verzug0"/>
	<field class="java.math.BigDecimal" name="Verzug1"/>
	<field class="java.math.BigDecimal" name="Verzug2"/>
	<field class="java.math.BigDecimal" name="Verzug3"/>
	<variable calculation="Count" class="java.lang.Integer" name="KZGD1G_1" resetType="Column">
		<variableExpression><![CDATA[$F{Monat}]]></variableExpression>
	</variable>
	<variable calculation="First" class="java.lang.Integer" name="KZGD1G_2" resetType="Column">
		<variableExpression><![CDATA[$F{Monat}]]></variableExpression>
	</variable>
	<variable calculation="Count" class="java.lang.Integer" name="KZGD2G_1" resetType="Column">
		<variableExpression><![CDATA[$F{Jahr}]]></variableExpression>
	</variable>
	<variable calculation="Count" class="java.lang.Integer" name="KZGD3G_1" resetType="Column">
		<variableExpression><![CDATA[$F{Produktgruppe}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="KZGD1V_1" resetType="Column">
		<variableExpression><![CDATA[$F{Verzug0}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="KZGD2V_1" resetType="Column">
		<variableExpression><![CDATA[$F{Verzug1}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="KZGD3V_1" resetType="Column">
		<variableExpression><![CDATA[$F{Verzug2}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="KZGD4V_1" resetType="Column">
		<variableExpression><![CDATA[$F{Verzug3}]]></variableExpression>
	</variable>
	<title>
		<band height="30">
			<staticText>
				<reportElement height="30" width="332" x="0" y="0"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" isBold="true" size="14"/>
				</textElement>
				<text><![CDATA[Liefertermintreue]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="15" splitType="Stretch">
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="79" x="0" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[Monat]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="79" x="79" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[Jahr]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="224" x="158" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[Produktgruppe]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="100" x="382" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[0 Tage Verzug ]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="100" x="482" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[1-5 Tage Verzug ]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="100" x="582" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[6-20 Tage Verzug ]]></text>
			</staticText>
			<staticText>
				<reportElement backcolor="#008CFA" forecolor="#FFFFFF" height="15" mode="Opaque" width="100" x="682" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<text><![CDATA[>20 Tage Verzug ]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<rectangle>
				<reportElement backcolor="#CCCCCC" forecolor="#FFFFFF" height="15" mode="Opaque" width="783" x="-1" y="0">
					<printWhenExpression><![CDATA[Boolean.valueOf( $V{PAGE_COUNT}.intValue() % 2 == 0 )]]></printWhenExpression>
				</reportElement>
			</rectangle>
			<textField>
				<reportElement height="15" mode="Transparent" width="79" x="79" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Jahr}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement height="15" width="79" x="0" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Monat}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement height="15" width="224" x="158" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Produktgruppe}]]></textFieldExpression>
			</textField>
			<textField pattern="###0">
				<reportElement height="15" width="100" x="382" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Verzug0}]]></textFieldExpression>
			</textField>
			<textField pattern="###0">
				<reportElement height="15" width="100" x="482" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Verzug1}]]></textFieldExpression>
			</textField>
			<textField pattern="###0">
				<reportElement height="15" width="100" x="582" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Verzug2}]]></textFieldExpression>
			</textField>
			<textField pattern="###0">
				<reportElement height="15" width="100" x="682" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Verzug3}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>