<?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="178_Rahmenquote_Balkendiagramm" language="groovy" pageWidth="381" pageHeight="842" orientation="Landscape" columnWidth="381" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="MNFIRM" class="java.lang.String">
		<defaultValueExpression><![CDATA["100"]]></defaultValueExpression>
	</parameter>
	<parameter name="SQL_66" class="java.lang.String" isForPrompting="false"/>
	<queryString>
		<![CDATA[SELECT CONVERT(DATE, CONCAT(KZGD1G, '-', RIGHT('00' + KZGD2G, 2 ), '-01')) AS ZEITRAUM, KZGD3V as WERT, 'Rahmenquote' as Rahmenquote FROM IKENZP WHERE KZGDGK = 'RAHMENQUOTE' AND KZFIRM = $P{MNFIRM} AND KZDATU = 	(SELECT MAX(KZDATU) 	FROM IKENZP 	WHERE KZFIRM = $P{MNFIRM} 	AND KZGDGK = 'RAHMENQUOTE') AND KZGD1G >= YEAR(DATEADD(YY,-1,GETDATE())) ORDER BY KZDATU,KZGD1G,CAST(KZGD2G AS INT)]]>
	</queryString>
	<field name="ZEITRAUM" class="java.sql.Date"/>
	<field name="WERT" class="java.math.BigDecimal"/>
	<title>
		<band height="30">
			<staticText>
				<reportElement x="0" y="0" width="377" height="30"/>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" size="14" isBold="true" isStrikeThrough="false"/>
				</textElement>
				<text><![CDATA[Rahmenquote in %]]></text>
			</staticText>
		</band>
	</title>
	<summary>
		<band height="180" splitType="Stretch">
			<barChart>
				<chart isShowLegend="false">
					<reportElement x="0" y="0" width="381" height="180"/>
					<chartTitle/>
					<chartSubtitle/>
					<chartLegend position="Bottom"/>
				</chart>
				<categoryDataset>
					<categorySeries>
						<seriesExpression><![CDATA["Rahmenquote"]]></seriesExpression>
						<categoryExpression><![CDATA[$F{ZEITRAUM}]]></categoryExpression>
						<valueExpression><![CDATA[$F{WERT}]]></valueExpression>
					</categorySeries>
				</categoryDataset>
				<barPlot isShowTickMarks="true">
					<plot labelRotation="-90.0">
						<seriesColor seriesOrder="0" color="#CC4C33"/>
						<seriesColor seriesOrder="1" color="#008CFA"/>
						<seriesColor seriesOrder="2" color="#4BAD85"/>
						<seriesColor seriesOrder="3" color="#EAB766"/>
						<seriesColor seriesOrder="4" color="#8C52AA"/>
						<seriesColor seriesOrder="5" color="#787878"/>
						<seriesColor seriesOrder="6" color="#ED8AA7"/>
					</plot>
					<itemLabel/>
				</barPlot>
			</barChart>
		</band>
	</summary>
</jasperReport>
