<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad  -->
<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="Product_without_template" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="958c2021-38b4-4859-8313-e3df21f9e602">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="advatra-1001"/>
	<parameter name="From" class="java.sql.Date"/>
	<parameter name="To" class="java.sql.Date"/>
	<queryString language="SQL">
		<![CDATA[SELECT 
	event_template.id,
	event_template.name,
	COUNT(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.id ELSE null END) as count_offered,
	COUNT(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.id ELSE null END) as count_confirmed,
	(CASE WHEN geographic_location.type='DESTINATION' THEN geographic_location.name ELSE '' END) as geo_small,
	(CASE WHEN geographic_location.type='STATE' THEN geographic_location.name ELSE (
			CASE WHEN geographic_location.type='DESTINATION' THEN geo_state_destination.name ELSE '' END
		) END) as geo_medium,
	(CASE WHEN geographic_location.type='REGION' THEN geographic_location.name ELSE (
			CASE WHEN geographic_location.type='STATE' THEN geo_region_state.name ELSE (
				CASE WHEN geographic_location.type='DESTINATION' THEN geo_region_destination.name ELSE '' END
			) END
		) END) as geo_large,
	event_category.name as category_name,
	event_category.type as category_type,
	(CASE WHEN customer_location.number is not null THEN CONCAT('L', customer.number, '.',  customer_location.number) ELSE '' END) as supplier,
	customer.last_name as supplier_name,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.brutto_price ELSE 0 END) as sales_turnover_offered,
	sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.brutto_price ELSE 0 END) as sales_turnover_confirmed,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.profit_after_discount ELSE 0 END) as profit_offered,
	sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.profit_after_discount ELSE 0 END) as profit_confirmed,
	(sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_offered,
	(sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_confirmed


FROM event_template
	JOIN event_category on event_template.event_category_id = event_category.id
	LEFT JOIN customer_location on event_template.customer_location_id = customer_location.id
	LEFT JOIN customer on customer_location.customer_id = customer.id
	
	JOIN geographic_location on event_template.geographic_location_id = geographic_location.id
	LEFT JOIN destination geo_destination on geographic_location.id = geo_destination.id and geographic_location.type='DESTINATION'
	LEFT JOIN canton geo_state on geographic_location.id = geo_state.id and geographic_location.type='STATE'
	LEFT JOIN region geo_region on geographic_location.id = geo_region.id and geographic_location.type='REGION'
	
	LEFT JOIN geographic_location geo_state_destination on geo_destination.canton_id=geo_state_destination.id
	LEFT JOIN geographic_location geo_region_state on geo_state.region_id=geo_region_state.id
	
	LEFT JOIN canton geo_region_state_destination on geo_state_destination.id=geo_region_state_destination.id
	LEFT JOIN geographic_location geo_region_destination on geo_region_state_destination.region_id=geo_region_destination.id
	
	JOIN event on event_template.id = event.event_template_id
	JOIN document ON event.document_id = document.id 

WHERE event.event_template_id IS NOT NULL AND event.start BETWEEN $P{From} and  $P{To}
GROUP BY event_template.id, event_category.name, event_category.type, customer_location.number, customer.number, customer.last_name, geographic_location.name, geographic_location.type, geo_state_destination.name, geo_region_state.name, geo_region_destination.name
ORDER BY category_type ASC, category_name ASC, geo_large ASC, geo_medium ASC, geo_small ASC, customer_location.number ASC, customer.number ASC, name ASC]]>
	</queryString>
	<field name="id" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="id"/>
		<property name="com.jaspersoft.studio.field.label" value="id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_template"/>
	</field>
	<field name="name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="name"/>
		<property name="com.jaspersoft.studio.field.label" value="name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_template"/>
	</field>
	<field name="count_offered" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="count_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="count_offered"/>
	</field>
	<field name="count_confirmed" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="count_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="count_confirmed"/>
	</field>
	<field name="geo_small" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_small"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_small"/>
	</field>
	<field name="geo_medium" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_medium"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_medium"/>
	</field>
	<field name="geo_large" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_large"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_large"/>
	</field>
	<field name="category_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="category_name"/>
		<property name="com.jaspersoft.studio.field.label" value="category_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_category"/>
	</field>
	<field name="category_type" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="category_type"/>
		<property name="com.jaspersoft.studio.field.label" value="category_type"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_category"/>
	</field>
	<field name="supplier" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="supplier"/>
		<property name="com.jaspersoft.studio.field.label" value="supplier"/>
	</field>
	<field name="supplier_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="supplier_name"/>
		<property name="com.jaspersoft.studio.field.label" value="supplier_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
	</field>
	<field name="sales_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_offered"/>
	</field>
	<field name="sales_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_confirmed"/>
	</field>
	<field name="profit_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_offered"/>
	</field>
	<field name="profit_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_confirmed"/>
	</field>
	<field name="purchase_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_offered"/>
	</field>
	<field name="purchase_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_confirmed"/>
	</field>
	<variable name="sales_turnover_confirmed1" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed2" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed1" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed2" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered1" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered2" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered1" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered2" class="java.math.BigDecimal" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered1" class="java.lang.Long" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered2" class="java.lang.Long" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_confirmed1" class="java.lang.Long" resetType="Group" resetGroup="Category Type" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed2" class="java.lang.Long" resetType="Group" resetGroup="Category Name" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed6" class="java.math.BigDecimal" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed6" class="java.math.BigDecimal" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered6" class="java.math.BigDecimal" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered6" class="java.math.BigDecimal" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered6" class="java.lang.Long" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_confirmed6" class="java.lang.Long" resetType="Group" resetGroup="Supplier" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<group name="Category Type" isStartNewPage="true">
		<groupExpression><![CDATA[$F{category_type}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<rectangle>
					<reportElement x="0" y="0" width="800" height="40" backcolor="#F5F5F5" uuid="6402d6c9-2010-4cdc-8919-c0b0f1d1ea97">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="0" y="0" width="399" height="19" uuid="96ccb61e-b0ce-4074-bb06-d99d474f2d90"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_type}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="0" width="80" height="20" uuid="60e4ed2e-0008-4065-8502-24a177b5bce1">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed1}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="0" width="80" height="20" uuid="941bc99e-3525-4b0a-865e-11262279f724">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed1}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="0" width="80" height="20" uuid="bb18e661-a707-4c3a-9e8b-289ade0dae5b">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered1}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="0" width="80" height="20" uuid="128ff885-f8e9-455c-82f3-d2e11ef29fd1">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered1}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type">
					<reportElement x="398" y="0" width="42" height="18" uuid="800166f1-ea64-4b2e-b1db-a1d277e6b728"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered1}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Type">
					<reportElement x="600" y="0" width="38" height="18" uuid="a1aef468-a8b0-40f8-9bd0-26826a71d865"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed1}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Category Name" isStartNewPage="true">
		<groupExpression><![CDATA[$F{category_name}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<rectangle>
					<reportElement x="10" y="0" width="789" height="40" backcolor="#F5F5F5" uuid="294141b6-4ba7-48b6-b8f7-1c5c18cc5416">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="10" y="0" width="388" height="19" uuid="bdc4d82b-5a91-47da-a849-d2101309b163"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_type} + " - " + $F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="0" width="80" height="20" uuid="55ba54b8-320b-4734-8a2f-302c712c1c8a">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed2}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="0" width="80" height="20" uuid="072f1856-ecb2-4630-b338-67802dc9f492">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered2}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="0" width="80" height="20" uuid="092418fe-426a-4b32-a447-f09fec6e8c98">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed2}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="0" width="80" height="20" uuid="66089b92-2716-4853-8745-d0a6826a68a8">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered2}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name">
					<reportElement x="398" y="0" width="42" height="18" uuid="82a00ec7-423f-44af-8466-0866ceb5d864"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered2}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Category Name">
					<reportElement x="600" y="0" width="38" height="18" uuid="1f8406f7-5021-480c-a352-d3ebf0ebefed"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed2}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Geo Large" isStartNewPage="true">
		<groupExpression><![CDATA[$F{geo_large}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<rectangle>
					<reportElement x="20" y="0" width="780" height="40" backcolor="#F5F5F5" uuid="8cb4a1a8-5335-453a-9736-13fb6cf9d824">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="20" y="20" width="379" height="19" uuid="5986b170-991b-4d4a-b3a7-2da4a8145a58"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="19" width="80" height="20" uuid="0c6a0de7-1952-43e1-ab20-56a673bd3ee5">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="19" width="80" height="20" uuid="f6df1727-9e71-43bd-83ae-b4a419c2b10b">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="19" width="80" height="20" uuid="464b1fea-141d-4aaa-ba87-fa0bf0a7bf23">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="29aaf380-a36f-4c73-863d-34ba91713757">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered3}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="20" y="0" width="379" height="19" uuid="5473a89a-6153-4d20-9d58-1fc10f061e4b"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_type} + " - " + $F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large">
					<reportElement x="399" y="19" width="42" height="18" uuid="7d4455e9-cfd6-4936-bb7d-2fc75b86c0df"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large">
					<reportElement x="601" y="19" width="38" height="18" uuid="0f16dd83-4f5f-4ea0-8929-8091981d9fc0"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed3}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Geo Medium" isStartNewPage="true">
		<groupExpression><![CDATA[$F{geo_medium}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<printWhenExpression><![CDATA[!$F{geo_medium}.equals("")]]></printWhenExpression>
				<rectangle>
					<reportElement x="30" y="0" width="769" height="40" backcolor="#F5F5F5" uuid="95146473-99cf-4b45-a0bc-af3962b9cdad">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="30" y="20" width="368" height="19" uuid="68dc9094-be4c-41ec-a736-f85c9e917763"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large} + " - " + $F{geo_medium}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="19" width="80" height="20" uuid="ed0ea47d-3412-4fae-a595-08d17da88f73">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="19" width="80" height="20" uuid="17225aaa-891a-4de6-80fc-9526ebcd5c68">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="19" width="80" height="20" uuid="31c0c40d-2432-4537-863a-6a2d0a0f1dc2">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="0d5493ec-b5b0-48fb-86ec-76e08f378ce7">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered4}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="30" y="0" width="368" height="19" uuid="c8797ebc-37ca-44de-aa09-c8ecec0f2c36"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_type} + " - " + $F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium">
					<reportElement x="399" y="19" width="42" height="18" uuid="34cf0b57-f52e-4609-ae6d-db2d44b49e2b"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium">
					<reportElement x="601" y="19" width="38" height="18" uuid="d5430acc-fbe2-42dd-a403-6bb64e076d9c"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed4}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Geo Small">
		<groupExpression><![CDATA[$F{geo_small}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<printWhenExpression><![CDATA[!$F{geo_small}.equals("")]]></printWhenExpression>
				<rectangle>
					<reportElement x="40" y="0" width="760" height="40" backcolor="#F5F5F5" uuid="ffb63c7d-d06f-4882-bdea-8468d135d5c1">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="40" y="20" width="359" height="19" uuid="135432cf-d14a-4a19-b13b-480afa638ce8"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large} + " - " + $F{geo_medium}  + " - " + $F{geo_small}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="19" width="80" height="20" uuid="b5a842db-77ee-4f9f-bda4-3f2f98b2234b">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="19" width="80" height="20" uuid="5b175f33-f44b-46cf-8176-05572900d8e5">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="19" width="80" height="20" uuid="61e1e1f9-754e-47fb-a73c-e1f5bb04454a">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="68a8f88e-dc8c-47be-b449-326bebdc13a1">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered5}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="40" y="0" width="359" height="19" uuid="afbacf2a-9af5-46c5-8fad-5ac4ca303fa8"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_type} + " - " + $F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small">
					<reportElement x="399" y="19" width="42" height="18" uuid="9dce5bd5-27bc-418a-9932-b4b6918f1d02"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small">
					<reportElement x="601" y="19" width="38" height="18" uuid="8fa374d0-0348-44f0-8261-2f7578ab4336"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed5}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Supplier">
		<groupExpression><![CDATA[$F{supplier}]]></groupExpression>
		<groupHeader>
			<band height="20">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<printWhenExpression><![CDATA[!$F{supplier}.equals("")]]></printWhenExpression>
				<rectangle>
					<reportElement x="40" y="0" width="760" height="18" backcolor="#F5F5F5" uuid="4fd5821a-6d55-4c4c-bc07-ae4d97e104f9">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField evaluationTime="Group" evaluationGroup="Supplier">
					<reportElement x="399" y="0" width="42" height="18" uuid="72ca589f-30ca-48bf-8083-914892875ee4">
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered6}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Supplier" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="0" width="80" height="20" uuid="78d6b85b-4893-4442-ace6-7cf09d167e1c">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered6}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Supplier" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="519" y="0" width="80" height="20" uuid="92fde5cb-c142-434b-81ef-a7ac1fcff417">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered6}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Supplier">
					<reportElement x="601" y="0" width="38" height="18" uuid="e5ec8884-d68f-41f9-9af1-fc635eac1d8a">
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed6}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Supplier" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="640" y="0" width="80" height="20" uuid="7957e08b-6437-4807-b56d-fb5b461b8a8e">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed6}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Supplier" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="0" width="80" height="20" uuid="70645a0f-0fd9-4aa3-9853-2516d20dd1ea">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
						<property name="com.jaspersoft.studio.unit.width" value="px"/>
						<property name="com.jaspersoft.studio.unit.y" value="px"/>
					</reportElement>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed6}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="40" y="1" width="359" height="19" uuid="c26a7cbd-fe6b-42c4-b053-047f8e00f85f"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{supplier} + " - " + $F{supplier_name}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="45" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<image>
				<reportElement x="0" y="0" width="170" height="30" uuid="58347aa4-4f49-4c04-8c39-b8a0b97e1cf8"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="310" height="20" uuid="dac20ad5-35eb-4fe1-aab4-ac3db438831e"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Turnover per product]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="20" width="310" height="15" uuid="33ab0374-ca13-47bb-8602-cf38d7130761">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[DATEFORMAT($P{From},"dd/MM/yyyy") + " - "+DATEFORMAT($P{To},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="35" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<rectangle>
				<reportElement x="0" y="0" width="800" height="30" backcolor="#F5F5F5" uuid="9b5e32a5-ac08-4b72-9b4b-c668d65ce6a5">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineColor="#F5F5F5"/>
				</graphicElement>
			</rectangle>
			<staticText>
				<reportElement x="0" y="0" width="50" height="20" uuid="58a68346-56d0-481a-8910-4f504f7b0b3a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a5ebb97-9ff6-4300-992b-578cfd5999b4"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[ID]]></text>
			</staticText>
			<staticText>
				<reportElement x="50" y="0" width="100" height="30" uuid="e1e2e129-ca8d-43fe-8de3-6aa57e23ebb4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="720" y="15" width="80" height="15" uuid="b2c29928-4e86-4060-882a-54d912f44bfd">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Sales]]></text>
			</staticText>
			<staticText>
				<reportElement x="520" y="15" width="80" height="15" uuid="28589ca9-91f4-4d68-a89b-2fdee26c908e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Sales]]></text>
			</staticText>
			<staticText>
				<reportElement x="439" y="15" width="80" height="15" uuid="27b74f34-b7ca-4957-98c4-5cbfc358600f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Purchase]]></text>
			</staticText>
			<staticText>
				<reportElement x="640" y="15" width="80" height="15" uuid="fc619706-f6ba-459f-933d-e38c232aac59">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Purchase]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="400" y="0" width="200" height="15" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="6561cf5a-b5fa-4c0a-8395-20a73acba2f7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="600" y="0" width="200" height="15" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="566deab5-3b42-4053-b127-1fc2c5a6420d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<staticText>
				<reportElement x="320" y="0" width="80" height="30" uuid="6136a7e8-44d1-488b-b2c3-2fe13225a45f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e4671070-94f2-4e00-82f0-370eeb035cfd"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Supplier]]></text>
			</staticText>
			<staticText>
				<reportElement x="600" y="15" width="39" height="15" uuid="f125d6d3-0034-41d4-b70b-509b024be3cd">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
			<staticText>
				<reportElement x="400" y="15" width="39" height="15" uuid="c3d98d7c-8c6f-4fa2-b93a-a747f37213e7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="40" y="0" width="50" height="15" uuid="e96f9b83-2fc6-47f7-9e3c-16108e25094e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a5ebb97-9ff6-4300-992b-578cfd5999b4"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="90" y="0" width="230" height="15" uuid="52860d11-1450-4c78-9151-b9df90db2e52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="0" width="80" height="15" uuid="33aa7f1a-b1bd-459e-94ad-e6bef027c88b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="520" y="0" width="80" height="15" uuid="3454d714-a7db-4954-b66d-24cac0e51807">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="440" y="0" width="80" height="15" uuid="9f88a151-969c-4d71-a242-0ba2458931cc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="0" width="80" height="15" uuid="8f917b82-1e42-4ae1-97e2-b67c35e63fdc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="320" y="0" width="79" height="15" uuid="414cb2fe-6cfe-48da-8462-76814b7c8ea6">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e4671070-94f2-4e00-82f0-370eeb035cfd"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{supplier}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="400" y="0" width="40" height="15" uuid="430171ff-6f33-4103-bf89-fff1523f94b1">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{count_offered}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="600" y="0" width="40" height="15" uuid="01765fea-8462-4d85-9305-b14fd8928f73">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{count_confirmed}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="17" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="0" y="0" width="100" height="15" uuid="7ac7cf54-f6d6-4e10-8854-383452db3c5f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["advatra - " + DATEFORMAT(TODAY( ),"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="700" y="0" width="100" height="15" uuid="280d34e0-be05-4180-a898-fe7ac07e904a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Group" evaluationGroup="Geo Small">
				<reportElement x="100" y="0" width="599" height="15" uuid="0155ea2a-a4b9-41b5-af10-907172a02a62">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement verticalAlignment="Top">
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{category_type} + " - " + $F{category_name} + " - " + $F{geo_large} + " - " + $F{geo_medium}  + " - " + $F{geo_small}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
