<?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="20" columnWidth="555" language="groovy" leftMargin="20" name="oxa_189" pageHeight="842" pageWidth="595" rightMargin="20" topMargin="20" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd">
	<property name="ireport.zoom" value="1.210000000000001"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="192"/>
	<style fontName="Times New Roman" fontSize="50" isBold="true" name="Title" pdfFontName="Times-Bold"/>
	<style fontName="Arial" fontSize="18" forecolor="#736343" name="SubTitle"/>
	<style fontName="Arial" fontSize="12" forecolor="#666666" isBold="true" name="Column header"/>
	<style fontName="Arial" fontSize="12" name="Detail"/>
	<style mode="Transparent" name="Row">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#D6D6D6"/>
		</conditionalStyle>
	</style>
	<style backcolor="#FFFFFF" fontName="Arial" forecolor="#000000" name="farbe">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DB} < 0]]></conditionExpression>
			<style fontName="Arial" forecolor="#FF0000"/>
		</conditionalStyle>
	</style>
	<style backcolor="#FFFFFF" fontName="Arial" forecolor="#000000" name="farbe2">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DB_1} < 0]]></conditionExpression>
			<style backcolor="#FFFFFF" fill="Solid" fontName="Arial" forecolor="#FF0000"/>
		</conditionalStyle>
	</style>
	<style backcolor="#000000" forecolor="#FFFFFF" isBold="false" mode="Opaque" name="ampel">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz} >= 0.2 && $V{DBproz} < 0.5]]></conditionExpression>
			<style backcolor="#FFFF00" forecolor="#FFFFFF" isBold="false"/>
		</conditionalStyle>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz} < 0.2]]></conditionExpression>
			<style backcolor="#FF0000" isBold="false"/>
		</conditionalStyle>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz} >= 0.5]]></conditionExpression>
			<style backcolor="#00FF00" isBold="false"/>
		</conditionalStyle>
	</style>
	<style backcolor="#000000" forecolor="#FFFFFF" isBold="false" mode="Opaque" name="ampel2">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz_1} >= 0.2 && $V{DBproz_1} < 0.5]]></conditionExpression>
			<style backcolor="#FFFF00" isBold="false"/>
		</conditionalStyle>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz_1} < 0.2]]></conditionExpression>
			<style backcolor="#FF0000" isBold="false"/>
		</conditionalStyle>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{DBproz_1} >= 0.5]]></conditionExpression>
			<style backcolor="#00FF00" isBold="false"/>
		</conditionalStyle>
	</style>
	<parameter class="java.lang.String" name="MNFIRM">
		<defaultValueExpression><![CDATA["FTK"]]></defaultValueExpression>
	</parameter>
	<parameter class="java.lang.String" name="SQL_125"/>
	<queryString>
		<![CDATA[select RKKDNR, RKFINR, PKADR1, RKAUNR, KOBEDT, RKLFDT, (RKNEWF), a.IKIV01 as IKIV01 from VRKOPP left join UPKADP on PKFAAD = RKFIRM and PKPKNR = RKKDNR and PKPFIN = RKFINR left join VKOPFP on KOFIRM = RKFIRM and KOAUNR = RKAUNR left join (select IKFIRM, IKAANW, IKANUM, sum(IKIV01) as IKIV01 from BIKTEP where IKAANW = 'VKS' and IKXKSP = 'ST' group by IKFIRM, IKAANW, IKANUM) as a on a.IKFIRM = RKFIRM and a.IKANUM = RKAUNR where RKFIRM = $P{MNFIRM} and RKAUKZ = 'AB' and IKIV01 <> 0 order by RKKDNR, RKFINR ]]>
	</queryString>
	<field class="java.lang.String" name="RKKDNR"/>
	<field class="java.lang.String" name="RKFINR"/>
	<field class="java.lang.String" name="PKADR1"/>
	<field class="java.lang.String" name="RKAUNR"/>
	<field class="java.sql.Date" name="KOBEDT"/>
	<field class="java.sql.Date" name="RKLFDT"/>
	<field class="java.math.BigDecimal" name="RKNEWF"/>
	<field class="java.math.BigDecimal" name="IKIV01"/>
	<variable calculation="Sum" class="java.math.BigDecimal" name="RKNEWF_1" resetGroup="Kunde" resetType="Group">
		<variableExpression><![CDATA[$F{RKNEWF}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="IKIV01_1" resetGroup="Kunde" resetType="Group">
		<variableExpression><![CDATA[$F{IKIV01}]]></variableExpression>
	</variable>
	<variable class="java.math.BigDecimal" name="DB" resetType="Column">
		<variableExpression><![CDATA[$F{RKNEWF} - $F{IKIV01}]]></variableExpression>
	</variable>
	<variable class="java.math.BigDecimal" name="DB_1" resetType="Column">
		<variableExpression><![CDATA[$V{RKNEWF_1} - $V{IKIV01_1}]]></variableExpression>
	</variable>
	<variable class="java.math.BigDecimal" name="DBproz">
		<variableExpression><![CDATA[$F{RKNEWF} == 0 ?
new BigDecimal(0.0) :
$V{DB}/$F{RKNEWF}]]></variableExpression>
	</variable>
	<variable class="java.math.BigDecimal" name="DBproz_1">
		<variableExpression><![CDATA[$V{RKNEWF_1} == 0 ?
new BigDecimal(0.0) :
$V{DB_1}/$V{RKNEWF_1}]]></variableExpression>
	</variable>
	<variable calculation="Sum" class="java.math.BigDecimal" name="RKNEWF_2" resetGroup="Kunde" resetType="Group">
		<variableExpression><![CDATA[$F{RKNEWF}]]></variableExpression>
	</variable>
	<group name="Kunde">
		<groupExpression><![CDATA[$F{RKKDNR}]]></groupExpression>
		<groupHeader>
			<band height="14">
				<textField>
					<reportElement height="12" width="240" x="0" y="2"/>
					<textElement>
						<font fontName="Arial" isBold="true" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA["Kunde: " + $F{PKADR1}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="20">
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" width="54" x="327" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Arial" isBold="true" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{RKNEWF_1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" width="54" x="381" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Arial" isBold="true" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{IKIV01_1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" style="farbe2" width="54" x="437" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Arial" isBold="true" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{DB_1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00 %">
					<reportElement height="15" style="farbe2" width="50" x="489" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font isBold="true" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{DBproz_1}]]></textFieldExpression>
				</textField>
				<rectangle radius="10">
					<reportElement height="13" style="ampel2" width="13" x="540" y="1"/>
					<graphicElement>
						<pen lineWidth="0.0"/>
					</graphicElement>
				</rectangle>
			</band>
		</groupFooter>
	</group>
	<background>
		<band height="802" splitType="Stretch"/>
	</background>
	<title>
		<band height="110" splitType="Stretch">
			<staticText>
				<reportElement height="32" style="Title" width="425" x="130" y="36"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Arial" pdfFontName="Times-Roman" size="24"/>
				</textElement>
				<text><![CDATA[Deckungsbeitragsrechnung]]></text>
			</staticText>
			<textField>
				<reportElement height="22" width="425" x="130" y="68"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Arial" size="18"/>
				</textElement>
				<textFieldExpression><![CDATA["Aufträge"]]></textFieldExpression>
			</textField>
			<image hAlign="Left" scaleImage="RetainShape" vAlign="Middle">
				<reportElement backcolor="#FFFFFF" forecolor="#FFFFFF" height="90" mode="Opaque" positionType="Float" width="125" x="0" y="0"/>
				<imageExpression><![CDATA["oxaion_logo.png"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="60" splitType="Stretch">
			<printWhenExpression><![CDATA[$V{PAGE_NUMBER} > 1]]></printWhenExpression>
			<image hAlign="Left" scaleImage="RetainShape" vAlign="Middle">
				<reportElement backcolor="#FFFFFF" forecolor="#FFFFFF" height="44" mode="Opaque" positionType="Float" width="65" x="0" y="0"/>
				<imageExpression><![CDATA["oxaion_logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement height="32" style="Title" width="425" x="130" y="12"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font fontName="Arial" pdfFontName="Times-Roman" size="18"/>
				</textElement>
				<text><![CDATA[Deckungsbeitragsrechnung - Aufträge]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<rectangle>
				<reportElement backcolor="#008CD7" forecolor="#008CD7" height="20" width="595" x="-20" y="0"/>
				<graphicElement>
					<pen lineWidth="0.0"/>
				</graphicElement>
			</rectangle>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" style="Column header" width="73" x="200" y="0"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="10"/>
				</textElement>
				<text><![CDATA[Auftragsnr.]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="65" x="0" y="0"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[Kundennr.]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="135" x="65" y="0"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[Kundenname]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="54" x="273" y="0"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[Lieferdat.]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="54" x="327" y="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[Erlöse]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="54" x="381" y="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[Kosten]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="54" x="435" y="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[DB I]]></text>
			</staticText>
			<staticText>
				<reportElement forecolor="#FFFFFF" height="20" width="50" x="489" y="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" isBold="true"/>
				</textElement>
				<text><![CDATA[DB I in %]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<frame>
				<reportElement height="15" mode="Opaque" style="Row" width="555" x="0" y="0"/>
				<textField hyperlinkType="RemotePage" isStretchWithOverflow="true">
					<reportElement forecolor="#0000FF" height="15" style="Detail" width="73" x="200" y="0"/>
					<textElement verticalAlignment="Middle">
						<font fontName="Arial" isUnderline="true" size="10"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{RKAUNR}]]></textFieldExpression>
					<hyperlinkReferenceExpression><![CDATA["http://rpc/"]]></hyperlinkReferenceExpression>
					<hyperlinkParameter name="cmd1">
						<hyperlinkParameterExpression><![CDATA["<ACTION>OPEN_PGM</ACTION><PGM>VK20090R</PGM>"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="cmd2">
						<hyperlinkParameterExpression><![CDATA["<ACTION>AUNR-DROPPED</ACTION><DTA><AUNR>" + $F{RKAUNR} + "</AUNR></DTA>"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="MNFIRM">
						<hyperlinkParameterExpression><![CDATA["D01"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
				</textField>
				<textField hyperlinkType="RemotePage">
					<reportElement forecolor="#0000FF" height="15" width="65" x="0" y="0"/>
					<textElement>
						<font fontName="Arial" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{RKKDNR} + " " + $F{RKFINR}]]></textFieldExpression>
					<hyperlinkReferenceExpression><![CDATA["http://rpc/"]]></hyperlinkReferenceExpression>
					<hyperlinkParameter name="cmd1">
						<hyperlinkParameterExpression><![CDATA["<ACTION>OPEN_PGM</ACTION><PGM>US11290R</PGM>"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="cmd2">
						<hyperlinkParameterExpression><![CDATA["<ACTION>PKNR-DROPPED</ACTION><DTA><PKNR>" + $F{RKKDNR} + "</PKNR></DTA>"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="MNFIRM">
						<hyperlinkParameterExpression><![CDATA["D01"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
				</textField>
				<textField>
					<reportElement height="15" width="135" x="65" y="0"/>
					<textElement>
						<font fontName="Arial"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{PKADR1}]]></textFieldExpression>
				</textField>
				<textField pattern="dd.MM.yyyy">
					<reportElement height="15" width="54" x="273" y="0"/>
					<textElement/>
					<textFieldExpression><![CDATA[$F{RKLFDT}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" width="54" x="327" y="0"/>
					<textElement textAlignment="Right"/>
					<textFieldExpression><![CDATA[$F{RKNEWF}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" width="54" x="381" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Arial"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{IKIV01}]]></textFieldExpression>
				</textField>
				<textField hyperlinkTarget="Parent" hyperlinkType="RemotePage" pattern="#,##0.00;-#,##0.00">
					<reportElement height="15" style="farbe" width="54" x="435" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font fontName="Arial" isUnderline="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{DB}]]></textFieldExpression>
					<anchorNameExpression><![CDATA["http://link/"]]></anchorNameExpression>
					<hyperlinkReferenceExpression><![CDATA["http://link/"]]></hyperlinkReferenceExpression>
					<hyperlinkParameter name="report">
						<hyperlinkParameterExpression><![CDATA["oxa_190"]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="MNFIRM">
						<hyperlinkParameterExpression><![CDATA[$P{MNFIRM}]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
					<hyperlinkParameter name="AUNR">
						<hyperlinkParameterExpression><![CDATA[$F{RKAUNR}]]></hyperlinkParameterExpression>
					</hyperlinkParameter>
				</textField>
				<textField pattern="#,##0.00 %">
					<reportElement height="15" style="farbe" width="50" x="489" y="0"/>
					<textElement textAlignment="Right" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$V{DBproz}]]></textFieldExpression>
				</textField>
				<rectangle radius="10">
					<reportElement height="13" style="ampel" width="13" x="540" y="1"/>
					<graphicElement>
						<pen lineWidth="0.0"/>
					</graphicElement>
				</rectangle>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="10" splitType="Stretch">
			<line>
				<reportElement height="1" positionType="FixRelativeToBottom" width="555" x="0" y="3"/>
				<graphicElement>
					<pen lineColor="#999999" lineWidth="0.5"/>
				</graphicElement>
			</line>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<textField>
				<reportElement forecolor="#999999" height="20" style="Column header" width="124" x="431" y="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Arial" isBold="false" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["Seite "+$V{PAGE_NUMBER}+" von " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement forecolor="#999999" height="20" style="Column header" width="197" x="0" y="1"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" isBold="false" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement forecolor="#999999" height="20" style="Column header" width="106" x="226" y="0"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" isBold="false" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["© oxaion gmbh"]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>