<?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="173_lieferantenteile" language="groovy" pageWidth="595" pageHeight="842" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="173_lieferantenteile">
	<property name="ireport.zoom" value="1.6105100000000008"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="MNFIRM" class="java.lang.String">
		<defaultValueExpression><![CDATA["990"]]></defaultValueExpression>
	</parameter>
	<parameter name="LINR" class="java.lang.String">
		<defaultValueExpression><![CDATA["7517510"]]></defaultValueExpression>
	</parameter>
	<parameter name="FINR" class="java.lang.String">
		<defaultValueExpression><![CDATA["000"]]></defaultValueExpression>
	</parameter>
	<parameter name="IDNR" class="java.lang.String">
		<defaultValueExpression><![CDATA["00684-EKS"]]></defaultValueExpression>
	</parameter>
	<parameter name="standard" class="java.lang.Boolean">
		<defaultValueExpression><![CDATA[true]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT LFMATL, LFTLEB, LFPLK1, LFBRPR, LFNEPR, LIPLK1, PKKADR, FIWESL
FROM ELFTLP
LEFT JOIN ELIEFP ON LIFIRM = LFFIRM AND LFLINR = LILINR AND LFFINR = LIFINR
LEFT JOIN UPKADP ON PKFAAD = LFFIRM AND PKPKNR = LFLINR AND PKPFIN = LFFINR
LEFT JOIN UFIRMP ON FIFIRM = LFFIRM
WHERE LFFIRM = $P{MNFIRM} AND LFIDNR = $P{IDNR} AND LFLINR = $P{LINR} AND LFFINR = $P{FINR}]]>
	</queryString>
	<field name="LFMATL" class="java.lang.String"/>
	<field name="LFTLEB" class="java.lang.String"/>
	<field name="LFPLK1" class="java.lang.String"/>
	<field name="LFBRPR" class="java.math.BigDecimal"/>
	<field name="LFNEPR" class="java.math.BigDecimal"/>
	<field name="LIPLK1" class="java.lang.String"/>
	<field name="PKKADR" class="java.lang.String"/>
	<field name="FIWESL" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<summary>
		<band height="123" splitType="Stretch">
			<textField>
				<reportElement x="1" y="0" width="485" height="22"/>
				<textElement>
					<font fontName="Arial" size="16" isBold="true" isUnderline="true"/>
				</textElement>
				<textFieldExpression><![CDATA[!$P{standard} ?
$R{Lieferant} :
$R{Standardlieferant}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="1" y="63" width="110" height="15">
					<printWhenExpression><![CDATA[$F{LFMATL} != null]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_LFMATL} + ": "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="111" y="63" width="141" height="15"/>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LFMATL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="1" y="78" width="110" height="30">
					<printWhenExpression><![CDATA[!$F{LFTLEB}.equals("")]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_LFBEZG} + ": "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="111" y="78" width="141" height="45"/>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LFTLEB}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="270" y="63" width="110" height="15"/>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_LFBRPR} + ": "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="270" y="78" width="110" height="15"/>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_LFNEPR} + ": "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="270" y="93" width="110" height="15"/>
				<textElement>
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_PLK1} + ": "]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="380" y="63" width="75" height="15"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LFBRPR} + " " + $F{FIWESL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="380" y="78" width="75" height="15"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LFNEPR} + " " + $F{FIWESL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="380" y="93" width="75" height="15"/>
				<textElement textAlignment="Right">
					<font fontName="Arial"/>
				</textElement>
				<textFieldExpression><![CDATA[!$F{LFPLK1}.equals("") ?
$F{LFPLK1} :
$F{LIPLK1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="1" y="25" width="202" height="15"/>
				<textElement>
					<font fontName="Arial" size="10" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_LINR} + ":"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="203" y="25" width="139" height="15"/>
				<textElement>
					<font fontName="Arial" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{LINR} + " " + $P{FINR}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="1" y="40" width="202" height="15"/>
				<textElement>
					<font fontName="Arial" size="10" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{TX_KADR} + ":"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement x="203" y="40" width="139" height="15"/>
				<textElement>
					<font fontName="Arial" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PKKADR}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
