<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.21.3.final using JasperReports Library version 6.21.3-4a3078d20785ebe464f18037d738d12fc98c13cf  -->
<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="Turnover per Employee" 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-1000"/>
	<property name="com.jaspersoft.studio.report.description" value=""/>
	<parameter name="From" class="java.sql.Date"/>
	<parameter name="To" class="java.sql.Date"/>
	<queryString language="SQL">
		<![CDATA[SELECT 
	CONCAT(travel_agent.last_name, ' ', travel_agent.first_name) as travel_agent,
	COUNT(DISTINCT CASE WHEN document.type='TRAVEL_CATALOG' THEN document.id ELSE null END) as count_offered,
	COUNT(DISTINCT CASE WHEN document.type='TRAVEL_CONFIRMATION' AND dossier.status not in ('CANCELED', 'STORNO') THEN document.id ELSE null END) as count_confirmed,
	COUNT(DISTINCT CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('STORNO') THEN document.id ELSE null END) as count_storno,
	COUNT(DISTINCT CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('CANCELED') THEN document.id ELSE null END) as count_canceled,
	
	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' AND dossier.status not in ('CANCELED', 'STORNO') THEN event.brutto_price ELSE 0 END) as sales_turnover_confirmed,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('STORNO') THEN event.brutto_price ELSE 0 END) as sales_turnover_storno,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('CANCELED') THEN event.brutto_price ELSE 0 END) as sales_turnover_canceled,
	
	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' AND dossier.status not in ('CANCELED', 'STORNO') THEN event.profit_after_discount ELSE 0 END) as profit_confirmed,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('STORNO') THEN event.profit_after_discount ELSE 0 END) as profit_storno,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('CACELED') THEN event.profit_after_discount ELSE 0 END) as profit_canceled,
	
	(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' AND dossier.status not in ('CANCELED', 'STORNO') THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' AND dossier.status not in ('CANCELED', 'STORNO') THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_confirmed,
	(sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('STORNO') THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('STORNO') THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_storno,
	(sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('CANCELED') THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CATALOG' AND dossier.status in ('CANCELED') THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_canceled


FROM event
	Left Join (
		Select d.*, 
		row_number() over (Partition By d.dossier_id, d.type Order By d.date DESC) as Ranking
		From document d
	  ) as document on document.id = event.document_id and document.Ranking = 1
	  
	JOIN dossier ON document.dossier_id = dossier.id
	JOIN customer_contact as travel_agent ON dossier.travel_agent_id = travel_agent.id

WHERE event.start BETWEEN $P{From} and  $P{To}
GROUP BY travel_agent.id
ORDER BY sales_turnover_confirmed, travel_agent.last_name, travel_agent.first_name]]>
	</queryString>
	<field name="travel_agent" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="travel_agent"/>
		<property name="com.jaspersoft.studio.field.label" value="travel_agent"/>
	</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="count_storno" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="count_storno"/>
		<property name="com.jaspersoft.studio.field.label" value="count_storno"/>
	</field>
	<field name="count_canceled" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="count_canceled"/>
		<property name="com.jaspersoft.studio.field.label" value="count_canceled"/>
	</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="sales_turnover_storno" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_storno"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_storno"/>
	</field>
	<field name="sales_turnover_canceled" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_canceled"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_canceled"/>
	</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="profit_storno" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_storno"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_storno"/>
	</field>
	<field name="profit_canceled" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_canceled"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_canceled"/>
	</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>
	<field name="purchase_turnover_storno" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_storno"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_storno"/>
	</field>
	<field name="purchase_turnover_canceled" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_canceled"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_canceled"/>
	</field>
	<sortField name="sales_turnover_confirmed" order="Descending"/>
	<variable name="count_offered1" class="java.lang.Long" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_confirmed1" class="java.lang.Long" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_storno1" class="java.lang.Long" calculation="Sum">
		<variableExpression><![CDATA[$F{count_storno}]]></variableExpression>
	</variable>
	<variable name="count_canceled1" class="java.lang.Long" calculation="Sum">
		<variableExpression><![CDATA[$F{count_canceled}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_storno1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_storno}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_canceled1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_canceled}]]></variableExpression>
	</variable>
	<variable name="profit_offered1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_offered}]]></variableExpression>
	</variable>
	<variable name="profit_confirmed1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_confirmed}]]></variableExpression>
	</variable>
	<variable name="profit_storno1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_storno}]]></variableExpression>
	</variable>
	<variable name="profit_canceled1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_canceled}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_storno1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_storno}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_canceled1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_canceled}]]></variableExpression>
	</variable>
	<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 travel agent]]></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["Travel dates: " + 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="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="411" 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="329" 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[Profit]]></text>
			</staticText>
			<staticText>
				<reportElement x="210" 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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
			<staticText>
				<reportElement x="249" y="15" width="80" height="15" uuid="369965a8-d713-41d9-9af9-13a8bd1783b4">
					<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="490" y="15" width="80" height="15" uuid="57daaac3-df2b-4551-acce-67222edb98ab">
					<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[Markup %]]></text>
			</staticText>
			<staticText>
				<reportElement x="570" y="15" width="80" height="15" uuid="45301730-3e3e-4328-9cef-d76301bba34c">
					<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[Margin %]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="153" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<staticText>
				<reportElement mode="Transparent" x="209" y="0" width="440" height="14" 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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="209" y="37" width="440" height="14" 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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="208" 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{travel_agent}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="52" 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="410" y="15" 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="329" y="15" 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{profit_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="52" 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{profit_confirmed}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="15" 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="Left"/>
				<textFieldExpression><![CDATA[$F{count_offered}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="52" 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="Left"/>
				<textFieldExpression><![CDATA[$F{count_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="15" width="80" height="15" uuid="1d879581-429f-4a86-a531-d4518af3f1c5">
					<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="490" y="15" width="80" height="15" uuid="040e7279-657c-43de-851d-c7cec1ecc898">
					<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[new Double($F{profit_offered}.doubleValue() / $F{purchase_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="15" width="80" height="15" uuid="d4dbe929-16de-4b53-a3f7-a4684d2bab1c">
					<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[new Double($F{profit_offered}.doubleValue() / $F{sales_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="150" width="800" height="1" uuid="db114094-4d1a-40a7-b399-df2c304a09fe"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="52" width="80" height="15" uuid="92af0efa-d508-48be-ae59-ee624225a8b5">
					<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_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="52" width="80" height="15" uuid="4bdaf803-8ac3-4fa8-89db-272b03acbdaa">
					<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[new Double($F{profit_confirmed}.doubleValue() / $F{purchase_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="52" width="80" height="15" uuid="2365dcbd-54ad-4ddc-a4e7-47a6cfe078a0">
					<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[new Double($F{profit_confirmed}.doubleValue() / $F{sales_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="89" width="80" height="15" uuid="c4a60a91-08ee-4120-803c-68452ea4e523">
					<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_storno}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="89" width="40" height="15" uuid="17867089-dde8-4c55-9292-c2ab8dd769f6">
					<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="Left"/>
				<textFieldExpression><![CDATA[$F{count_storno}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="209" y="74" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="f2a70c92-cfd1-4fea-9801-95393b72615b">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Cancelled]]></text>
			</staticText>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="89" width="80" height="15" uuid="dc1d6ec8-b9c0-4b78-88d1-a5c9f544d825">
					<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[new Double($F{profit_storno}.doubleValue() / $F{purchase_turnover_storno}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="89" width="80" height="15" uuid="2e3deeaa-4356-4d16-812c-cde6b63ead88">
					<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[new Double($F{profit_storno}.doubleValue() / $F{sales_turnover_storno}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="89" width="80" height="15" uuid="358ccbc3-ec8e-447f-bbb3-1d905dabc19a">
					<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{profit_storno}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="89" width="80" height="15" uuid="76b57538-7bf6-4bcc-94d5-559eda6e8ed8">
					<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_storno}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="209" y="112" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="1f7b1145-45cc-4c76-916c-16032bb39682">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Lost]]></text>
			</staticText>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="127" width="80" height="15" uuid="d10da79d-06a9-45f1-a434-99e5edfc8c8f">
					<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{profit_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="127" width="80" height="15" uuid="0464b019-86bb-4f03-b73c-f157694d4fc0">
					<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_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="127" width="80" height="15" uuid="5e983284-1058-4026-ae6f-9e786486bdce">
					<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[new Double($F{profit_canceled}.doubleValue() / $F{purchase_turnover_canceled}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="127" width="40" height="15" uuid="ed93a934-ea62-4d15-a03f-591896948fbf">
					<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="Left"/>
				<textFieldExpression><![CDATA[$F{count_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="127" width="80" height="15" uuid="149054be-9b8f-4595-93f1-67c7a7eae26d">
					<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_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="127" width="80" height="15" uuid="242cd149-a1e8-45de-ac93-69258e322832">
					<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[new Double($F{profit_canceled}.doubleValue() / $F{sales_turnover_canceled}.doubleValue())*100]]></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>
		</band>
	</pageFooter>
	<summary>
		<band height="245">
			<rectangle>
				<reportElement x="0" y="51" width="800" height="30" backcolor="#F5F5F5" uuid="843ce32e-bfc3-4eb3-93e0-d379af7ca509">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineColor="#F5F5F5"/>
				</graphicElement>
			</rectangle>
			<staticText>
				<reportElement mode="Transparent" x="209" y="88" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="1b6f2308-eb47-4704-a17a-32eff00340ec">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="209" y="125" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="f59a250c-232b-4652-ad70-7a9e8a918db5">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="209" y="162" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="6ff78532-7a3a-4640-a767-daeab86e54b4">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Cancelled]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="209" y="200" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="d707abba-a448-4b7b-9324-73ca09b113e5">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Lost]]></text>
			</staticText>
			<textField>
				<reportElement x="210" y="102" width="42" height="18" uuid="ce690ad0-22ee-47a6-88ea-e7b154e03637"/>
				<textFieldExpression><![CDATA[$V{count_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="139" width="42" height="18" uuid="f90ebb35-381b-49b0-908b-8bd25abecfa0"/>
				<textFieldExpression><![CDATA[$V{count_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="208" y="176" width="44" height="18" uuid="00334230-b6ec-4408-8e07-edb13de9660a"/>
				<textFieldExpression><![CDATA[$V{count_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="214" width="42" height="18" uuid="2023b09d-3f71-476b-b0ff-c17d2c482ac0"/>
				<textFieldExpression><![CDATA[$V{count_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="102" width="80" height="18" uuid="cf9baac9-e95a-448d-8e2b-5aadf9627ea6"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="407" y="139" width="82" height="18" uuid="e7524118-96f3-4072-ad21-f035137fe7c5"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="176" width="82" height="18" uuid="1d21a11b-7524-4cf6-acf9-045090365390"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="410" y="214" width="80" height="18" uuid="e7001076-2e98-4926-9dce-5b60ce7057fc"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="102" width="80" height="18" uuid="eb93688e-c596-4440-95fa-04b7b5112f75"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="139" width="78" height="18" uuid="c8993e0d-fedf-4b83-9a03-a6b847d05dd0"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="328" y="176" width="80" height="18" uuid="a0097d65-32bd-4883-ae98-1fd4f611fcda"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="214" width="80" height="18" uuid="f6f8ff3c-d46f-4080-83f9-1b82106c59a3"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="102" width="76" height="18" uuid="d49e27cf-305b-411d-b81a-2723e9119930"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="251" y="139" width="78" height="18" uuid="b2e9a805-0a3e-4363-938e-93ef367884d3"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="176" width="76" height="18" uuid="856a168c-cb6c-4d1d-9843-106324713caa"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="214" width="76" height="18" uuid="102e6de1-5d2c-4d24-b126-0591fbda6e74"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="411" y="66" width="80" height="15" uuid="657c6801-4fb5-41b2-be72-8848162fd2db">
					<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="329" y="66" width="80" height="15" uuid="6b5ff567-69f1-4f6d-9748-0d50f0d01d8b">
					<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[Profit]]></text>
			</staticText>
			<staticText>
				<reportElement x="490" y="66" width="80" height="15" uuid="f92e1800-1e26-4493-99fd-29c02b6de1e2">
					<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[Markup %]]></text>
			</staticText>
			<staticText>
				<reportElement x="249" y="66" width="80" height="15" uuid="e3532c60-9da9-4c10-bf1e-3ba7b9577a7a">
					<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="570" y="66" width="80" height="15" uuid="cee65d8f-36df-4911-a34a-38df1e2d9159">
					<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[Margin %]]></text>
			</staticText>
			<staticText>
				<reportElement x="210" y="66" width="39" height="15" uuid="0f0629ef-785b-467e-826c-ab3339cc3e86">
					<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="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="51" width="100" height="30" uuid="dcf948df-59fe-4826-9676-943c171e0b4c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Summary]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="170" height="30" uuid="3177fb63-b4e5-428c-bc9e-c3d53ddd6213"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="310" height="20" uuid="67c9767a-55c6-402a-979f-27e938efa27a"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Turnover per travel agent]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="20" width="310" height="15" uuid="e93530e7-36e4-48d0-8f11-c270dd35fdc1">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["Travel dates: " + DATEFORMAT($P{From},"dd/MM/yyyy") + " - "+DATEFORMAT($P{To},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="88" width="208" height="15" uuid="bb805c2d-66f1-44b5-b8b6-efe80560aaf8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textFieldExpression><![CDATA["Total"]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="238" width="800" height="1" uuid="e1cf3abd-89a4-487c-8232-69b68c764a1e"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="102" width="80" height="15" uuid="85d9f9ad-e05e-4c87-b567-a6677a159db2">
					<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[new Double($V{profit_offered1}.doubleValue() / $V{sales_turnover_offered1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="214" width="80" height="15" uuid="6aa1447f-aafb-4d52-9988-f22dcb549723">
					<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[new Double($V{profit_canceled1}.doubleValue() / $V{purchase_turnover_canceled1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="214" width="80" height="15" uuid="e87125b0-999e-49b2-a634-2c07a7cdc669">
					<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[new Double($V{profit_canceled1}.doubleValue() / $V{sales_turnover_canceled1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="102" width="80" height="15" uuid="44c8c6a9-72ca-4d07-87da-eed2f9ac93bb">
					<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[new Double($V{profit_offered1}.doubleValue() / $V{purchase_turnover_offered1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="176" width="80" height="15" uuid="1e2e19e2-6fc2-45d9-af47-408ccf7c1efd">
					<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[new Double($V{profit_storno1}.doubleValue() / $V{purchase_turnover_storno1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="176" width="80" height="15" uuid="d922a3c9-8234-4531-8fe7-ddf93aa9767b">
					<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[new Double($V{profit_storno1}.doubleValue() / $V{sales_turnover_storno1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="139" width="80" height="15" uuid="818404de-007b-48b3-a635-5b811b50e977">
					<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[new Double($V{profit_confirmed1}.doubleValue() / $V{purchase_turnover_confirmed1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="139" width="80" height="15" uuid="96a4e57f-e8fc-4417-9c50-c2f1ecbb01d9">
					<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[new Double($V{profit_confirmed1}.doubleValue() / $V{sales_turnover_confirmed1}.doubleValue())*100]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
