<?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 Country" 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 
	customer_location.country as country,
	CONCAT(MIN(customer.last_name), ' ', MIN(customer.first_name)) as customer,
	CONCAT('D', dossier.number) as dossier_nr,
	dossier.name as dossier_name,
	dossier.status as dossier_status,
	dossier.opening_date as dossier_opening_date,
	MIN(travel_document.start) as travel_start,
	(MIN(travel_document.start) - dossier.opening_date) as days_before_travel,
	
	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
	JOIN document ON event.document_id = document.id
	JOIN travel_document ON document.id = travel_document.id
	JOIN dossier ON document.dossier_id = dossier.id
	JOIN customer_location ON dossier.customer_location_id = customer_location.id
	JOIN customer on customer.id = customer_location.customer_id
	
WHERE event.start BETWEEN $P{From} and  $P{To}
GROUP BY dossier.id, customer_location.country, customer.last_name
ORDER BY  customer_location.country, customer.last_name]]>
	</queryString>
	<field name="country" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="country"/>
		<property name="com.jaspersoft.studio.field.label" value="country"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="customer_location"/>
	</field>
	<field name="customer" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="customer"/>
		<property name="com.jaspersoft.studio.field.label" value="customer"/>
	</field>
	<field name="dossier_nr" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_nr"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_nr"/>
	</field>
	<field name="dossier_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_name"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="dossier_status" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_status"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_status"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="dossier_opening_date" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="dossier_opening_date"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_opening_date"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="travel_start" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="travel_start"/>
		<property name="com.jaspersoft.studio.field.label" value="travel_start"/>
	</field>
	<field name="days_before_travel" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="days_before_travel"/>
		<property name="com.jaspersoft.studio.field.label" value="days_before_travel"/>
	</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="purchase_turnover_offered1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="profit_offered1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_offered}]]></variableExpression>
	</variable>
	<variable name="profit_confirmed1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed1" class="java.math.BigDecimal" resetType="Group" resetGroup="Country Group" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="profit_offered2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_offered}]]></variableExpression>
	</variable>
	<variable name="profit_confirmed2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{profit_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<group name="Country Group" isStartNewPage="true">
		<groupExpression><![CDATA[$F{country}]]></groupExpression>
		<groupHeader>
			<band height="40">
				<rectangle>
					<reportElement x="0" y="2" width="800" height="28" backcolor="#F5F5F5" uuid="8ad0ece3-7d92-4497-a314-26898de30b53">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="5" y="8" width="100" height="20" uuid="7048ec64-429d-4ba8-a41a-1e0fa7ceb34a"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="100">
				<rectangle>
					<reportElement x="0" y="2" width="800" height="58" backcolor="#F5F5F5" uuid="d290c081-f00e-4889-8b1f-e976dd6b1f74">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="4" y="24" width="100" height="30" uuid="f94bb944-c569-4a18-a190-cc541045530e"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Transparent" x="358" y="21" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="2003b951-4cd2-4727-baad-b89ca07e1d54">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Offered]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Transparent" x="358" y="40" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="c13cf43d-dbcd-48ea-8306-645056b4e85c">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Confirmed]]></text>
				</staticText>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="398" y="40" width="80" height="14" uuid="487673e0-3e81-4caf-b468-d6e36a83e102"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="398" y="21" width="80" height="14" uuid="88eb6fcb-1f7c-4d2f-90d9-3d5017513093"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{purchase_turnover_offered1}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="4" y="12" width="100" height="16" uuid="8a7e9c21-a64b-4fc0-9d54-ff3f54174b95">
						<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
					</reportElement>
					<textElement>
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Total]]></text>
				</staticText>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="480" y="21" width="78" height="14" uuid="0306c9af-a170-4693-a71d-d9ff7bd38295"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{profit_offered1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="480" y="40" width="78" height="14" uuid="909e1970-fe15-41cb-acd8-d4fba72b5047"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{profit_confirmed1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="560" y="21" width="78" height="14" uuid="44cc44a7-fd2e-44ee-840e-517085d08210"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_offered1}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="560" y="40" width="78" height="14" uuid="03563b03-9944-42f8-8dc6-58cb738f8414"/>
					<textElement textAlignment="Right">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{sales_turnover_confirmed1}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="398" y="6" width="80" height="15" uuid="e7b1d3e6-e7ba-4bf7-bdb5-aea26286871b">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Purchase]]></text>
				</staticText>
				<staticText>
					<reportElement x="478" y="6" width="80" height="15" uuid="9dccf3c4-6bc1-406e-809d-a4c16cd68a34">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Profit]]></text>
				</staticText>
				<staticText>
					<reportElement x="560" y="6" width="80" height="15" uuid="b77c92f8-d4d9-4a70-901e-b8c1cdade2ec">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Sales]]></text>
				</staticText>
				<staticText>
					<reportElement x="639" y="6" width="80" height="15" uuid="c77c7a02-754f-4f6a-bde8-be0ec3d3032f">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Markup %]]></text>
				</staticText>
				<staticText>
					<reportElement x="719" y="6" width="80" height="15" uuid="4999a93e-973e-4595-817d-beeb4a67b8d8">
						<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 size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Margin %]]></text>
				</staticText>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="639" y="20" width="80" height="15" uuid="00692a56-f30f-4e7f-8c39-59a4a0a473c9">
						<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">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[new Double($V{profit_offered1}.doubleValue() / $V{purchase_turnover_offered1}.doubleValue())*100]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="639" y="39" width="80" height="15" uuid="957557cc-c0df-486c-ac67-951506b027f0">
						<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">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[new Double($V{profit_confirmed1}.doubleValue() / $V{purchase_turnover_confirmed1}.doubleValue())*100]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="20" width="80" height="15" uuid="60b31604-8b3e-4b67-9137-7059a6e798a9">
						<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">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[new Double($V{profit_offered1}.doubleValue() / $V{sales_turnover_offered1}.doubleValue())*100]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="719" y="39" width="80" height="15" uuid="53872d9f-7137-4adf-8b95-1cc047cc5f73">
						<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">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[new Double($V{profit_confirmed1}.doubleValue() / $V{sales_turnover_confirmed1}.doubleValue())*100]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="55" 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="400" height="20" uuid="dac20ad5-35eb-4fe1-aab4-ac3db438831e"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Turnover per country]]></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="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Travel dates: " + DATEFORMAT($P{From},"dd/MM/yyyy") + " - "+DATEFORMAT($P{To},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="170" y="35" width="400" height="15" uuid="ef249afa-85e3-4241-96b9-da344516fed6"/>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ordered by country and customer name, ascending]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="36" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<rectangle>
				<reportElement x="0" y="2" 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="23" y="9" width="100" height="23" uuid="e1e2e129-ca8d-43fe-8de3-6aa57e23ebb4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Customer
Dossier]]></text>
			</staticText>
			<staticText>
				<reportElement x="560" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Sales]]></text>
			</staticText>
			<staticText>
				<reportElement x="478" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Profit]]></text>
			</staticText>
			<staticText>
				<reportElement x="398" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Purchase]]></text>
			</staticText>
			<staticText>
				<reportElement x="639" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Markup %]]></text>
			</staticText>
			<staticText>
				<reportElement x="719" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Margin %]]></text>
			</staticText>
			<staticText>
				<reportElement x="190" y="10" width="60" height="21" uuid="37c039ae-a9fc-4172-b647-953c763302c2">
					<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="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Opening
date]]></text>
			</staticText>
			<staticText>
				<reportElement x="250" y="10" width="60" height="21" uuid="0396bebf-2762-4575-92d0-9761e98cb29b">
					<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="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Travel
start]]></text>
			</staticText>
			<staticText>
				<reportElement x="310" y="10" width="48" height="21" uuid="30241181-9d2d-42b5-8baa-499fb54be47c">
					<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="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Days before travel start]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="62" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<staticText>
				<reportElement mode="Transparent" x="358" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="358" y="19" 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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<textField>
				<reportElement x="23" y="0" width="166" height="15" uuid="52860d11-1450-4c78-9151-b9df90db2e52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{customer}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="559" y="20" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{sales_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="559" y="1" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{sales_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="478" y="1" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{profit_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="478" y="20" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{profit_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="1" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{purchase_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="1" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{purchase_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="1" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{sales_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="56" width="800" height="1" uuid="db114094-4d1a-40a7-b399-df2c304a09fe"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="20" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{purchase_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="20" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{purchase_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="20" 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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{sales_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="23" y="16" width="156" height="15" uuid="ff1e09d3-b0a6-42bc-ab71-d9b7b81448b1">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dossier_nr}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="23" y="33" width="166" height="17" uuid="e3574c29-3e3b-416f-926a-18c0cd72e061">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dossier_name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="190" y="1" width="60" height="15" uuid="5f4eb392-8264-4d2c-a67e-7d95dabde1c2">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[DATEFORMAT($F{dossier_opening_date},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="250" y="1" width="60" height="15" uuid="de979f91-c411-4435-bf36-00413a5f8e08">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[DATEFORMAT($F{travel_start},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="310" y="1" width="48" height="15" uuid="141bac4c-7c8e-4d55-8424-c3ac11f68f02">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{days_before_travel}]]></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="273">
			<rectangle>
				<reportElement x="0" y="63" width="800" height="30" backcolor="#F5F5F5" uuid="d14631c2-4e52-4dcb-a01c-067dd5a06033">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineColor="#F5F5F5"/>
				</graphicElement>
			</rectangle>
			<staticText>
				<reportElement x="0" y="78" width="100" height="14" uuid="817c67c7-1341-4532-9cfb-b5482e6174c1">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<staticText>
				<reportElement x="398" y="76" width="80" height="15" uuid="5f3af29d-2bbf-4bba-a695-c2b28002440d">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Purchase]]></text>
			</staticText>
			<staticText>
				<reportElement x="560" y="76" width="80" height="15" uuid="248e1d18-5a41-4677-8fe1-f3e7ee96ab8d">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Sales]]></text>
			</staticText>
			<staticText>
				<reportElement x="719" y="76" width="80" height="15" uuid="8403d96b-4919-4152-a8f6-83ae55c0f0b8">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Margin %]]></text>
			</staticText>
			<staticText>
				<reportElement x="639" y="76" width="80" height="15" uuid="0100ef81-69ea-4662-8f71-97c0e11146cd">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Markup %]]></text>
			</staticText>
			<staticText>
				<reportElement x="478" y="76" width="80" height="15" uuid="ec2a716e-ddca-40dc-ad64-060db5116406">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Profit]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="360" y="102" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="4381dcdd-620d-4efa-90e9-25812dae0b22">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="360" y="121" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="76ec98d9-12e3-4a18-8d4d-992ce9f114cd">
					<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 size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="102" width="80" height="14" uuid="951751f6-0f36-4a72-bb3c-42189321345d">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{purchase_turnover_offered2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="121" width="80" height="14" uuid="97b4c7a0-552a-46b9-9981-4fbd67132430">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="480" y="102" width="78" height="14" uuid="4c0aa4b1-9ec4-4c6f-b239-863e14ebca2f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{profit_offered2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="480" y="121" width="78" height="14" uuid="c67d7d97-c1a9-4747-94a3-92c24aa66cc6">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{profit_confirmed2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="560" y="102" width="78" height="14" uuid="44fe770f-a7ea-44bd-8ad7-d6b8d187f1d5">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{sales_turnover_offered2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="560" y="121" width="78" height="14" uuid="a3ad6d11-ed1a-4944-bf1a-690a1c326e74">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{sales_turnover_confirmed2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="103" width="80" height="15" uuid="0fd1e527-3f8b-4930-9a3b-ed3fdd3e2e76">
					<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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($V{profit_offered2}.doubleValue() / $V{purchase_turnover_offered2}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="122" width="80" height="15" uuid="2a2fc026-0664-43e4-adda-10f625648b0f">
					<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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($V{profit_confirmed2}.doubleValue() / $V{purchase_turnover_confirmed2}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="103" width="80" height="15" uuid="aa8295f3-f481-41b4-987f-d5bc2c8bf2e1">
					<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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($V{profit_offered2}.doubleValue() / $V{sales_turnover_offered2}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="122" width="80" height="15" uuid="5bad4901-91a4-4db3-b1b3-f80e1063c25f">
					<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">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($V{profit_confirmed1}.doubleValue() / $V{sales_turnover_confirmed1}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="170" height="30" uuid="2c7d4480-e676-4936-b48d-be86a14cf765"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="400" height="20" uuid="0acc422c-854d-4b3e-9fed-6653f9e19995"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Turnover per country]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="20" width="310" height="15" uuid="8f263bd9-d910-485b-a1f8-c9d088737906">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Travel dates: " + DATEFORMAT($P{From},"dd/MM/yyyy") + " - "+DATEFORMAT($P{To},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="170" y="35" width="400" height="15" uuid="c218d8a7-e0d0-4eeb-983d-2492c9617ccd"/>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ordered by country and customer name, ascending]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
