<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Turnover per Company" 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(customer.last_name, ' ', customer.first_name) as customer,
	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_location ON dossier.customer_location_id = customer_location.id
	JOIN customer on customer_location.customer_id = customer.id

WHERE event.start BETWEEN $P{From} and  $P{To}
GROUP BY customer.id
ORDER BY customer.last_name, customer.first_name]]>
	</queryString>
	<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="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>
	<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 company]]></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="162" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<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{customer}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="150" width="800" height="1" uuid="db114094-4d1a-40a7-b399-df2c304a09fe"/>
			</line>
			<staticText>
				<reportElement mode="Transparent" x="209" y="0" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="102feb79-20a7-4813-89ab-dd06758b1f3b">
					<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="58ca293c-a2ef-457e-9ec3-36cce9b04a48">
					<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 pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="52" width="80" height="15" uuid="7a1a7b25-df84-4b11-aa66-004517a54baf">
					<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="1089c3f8-97d5-4146-9c72-0a890a7753c2">
					<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="928176f6-e1da-48ab-948d-4ecbbc950d94">
					<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="541ede59-e849-4805-9997-4818926cbdcf">
					<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="754b404b-b44b-4c62-9951-df51f62bcbad">
					<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="45f4c52a-99dc-49d7-a7ce-3804a674983d">
					<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="4d0e73bc-9232-45f7-8bf0-c61474ab4249">
					<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="b0dde1ee-05db-4264-9703-742a801e5142">
					<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="c12ed73b-79e0-4a98-b140-1b5fb5d7f1b8">
					<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>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="52" width="80" height="15" uuid="3ed2cc43-20e1-46d2-bdfd-4efdc7a5fa1b">
					<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="2210890e-2224-43db-9559-eb40c9d43831">
					<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="80b76df6-cb70-4862-8cbb-245e46fc5a80">
					<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="727e5b49-c435-4597-a6f2-7b48c843bbe0">
					<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="1ab8cc45-006d-44f7-a81e-946cd9c07b52">
					<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="7533c9ae-b4df-4bb8-81e9-eb633dc6f0c0">
					<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="bc2269a0-1f51-45de-944d-1f6949c9336a">
					<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="29a2a614-4d29-442d-b756-155b2804bc0b">
					<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="977ca5d2-9974-4571-8027-10a6129cd71a">
					<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="8d6bd5c2-be9a-4156-ac73-50a2d992a15b">
					<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="1283fd53-ddba-421a-b401-e56a297e876a">
					<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="3b14f242-a8cd-4450-9e7b-3d7e6cdf61b1">
					<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="a2255751-bff1-4cf4-953c-f3b7df937a3f">
					<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="9de59ef1-2715-4346-b52c-7196681291cf">
					<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="8de60110-5180-4f87-bcfd-164257310ed7">
					<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="876a1f8e-69be-4606-8136-38108a3ebee2">
					<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="2c15a23d-06fc-42ac-9f6c-4ee0f1815243">
					<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="239">
			<rectangle>
				<reportElement x="0" y="51" width="800" height="30" backcolor="#F5F5F5" uuid="6df59a56-3979-4cbc-ad86-763d407c859d">
					<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="6edf4cdb-cecf-46b9-99cd-4110b9e2c68a">
					<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="a3a5c6df-820f-4987-84b0-fab13af26509">
					<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="bf5a717e-34db-4a38-8628-739cc7b3ee6f">
					<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="0c937f7b-bb66-4bee-a316-46f0e2a111a2">
					<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="f6678e5e-95f5-4059-91de-779e1d779d68"/>
				<textFieldExpression><![CDATA[$V{count_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="139" width="42" height="18" uuid="1fec36cf-ea9b-4d5a-aba8-2da9e6c5d956"/>
				<textFieldExpression><![CDATA[$V{count_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="208" y="176" width="44" height="18" uuid="f3a5ab86-a874-49e9-9e67-f3a35005375c"/>
				<textFieldExpression><![CDATA[$V{count_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="214" width="42" height="18" uuid="a4656034-15de-4049-ba49-a0fb7d9454b8"/>
				<textFieldExpression><![CDATA[$V{count_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="102" width="80" height="18" uuid="e3c9dbb6-22f2-4eb2-9f14-4661917039a1"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="407" y="139" width="82" height="18" uuid="efced44d-fcca-4ea4-9cf7-d3fcee521914"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="176" width="82" height="18" uuid="6c1c9715-a99d-4001-88f5-12fd9b3f62c2"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="410" y="214" width="80" height="18" uuid="1e0bdb98-1053-4d51-a694-0667d7cad130"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="102" width="80" height="18" uuid="ec628aba-e561-40a4-a7f5-1122c8e7ab41"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="139" width="78" height="18" uuid="1c1e1645-c3b5-41c0-834c-880a79e6d53d"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="328" y="176" width="80" height="18" uuid="f7c6449d-a3ff-419b-ae3c-9bbf7cc43e03"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="214" width="80" height="18" uuid="f77a7644-288d-4266-8141-6cbeb178e009"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="102" width="76" height="18" uuid="55b0ddc4-cc0e-4523-9b57-113ef40cc7ab"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="251" y="139" width="78" height="18" uuid="2e53a11f-a4a2-4782-b6af-3d7aa0be6490"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="176" width="76" height="18" uuid="8d377a0a-1b8f-4f94-bef1-1d83605bdd00"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="214" width="76" height="18" uuid="8cd39f20-49ae-456e-af22-fbcb13c730e2"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="411" y="66" width="80" height="15" uuid="faa0286e-10aa-4a8e-b7a4-ba6a2f94708d">
					<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="b0f7fc19-95e2-440f-969c-9969c84e9073">
					<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="f1eeb390-4613-4c83-af03-64444717cac2">
					<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="70a8a798-7296-44b5-ae3b-156db7629029">
					<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="9af8f6f7-6832-4c84-9bb3-329736be5a28">
					<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="7e6f463b-5a8b-40a9-8154-7272fb9ab778">
					<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="e71a0863-9584-4b99-af05-a30a576d146e">
					<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="c2e19d4a-41ca-4833-aebe-ff828298149e"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="310" height="20" uuid="840dcbfd-7431-4766-87ce-d83487af0bfb"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Turnover per company]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="20" width="310" height="15" uuid="d6f83e15-2b35-40bf-b311-067dacc357ed">
					<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="929ec443-d07c-4149-8763-8b2f9c7f36c1">
					<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="dd1ac6b2-1e62-41df-8b04-ceac63e5e49b"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="102" width="80" height="15" uuid="708c34b2-823d-44a9-83f8-731ae7b98c37">
					<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="795592b1-bdbc-47a0-9e45-bbd41a7862a6">
					<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="113b4f72-9a7d-49a8-a6ec-619ccd4b84c0">
					<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="af42d5dd-c80c-43e5-85db-f25559eef821">
					<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="bb823799-b89c-4c97-960f-5b3733a37f2c">
					<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="bc148b3b-854d-473f-b729-7139c7b62be3">
					<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="3a1504f9-f62b-4a17-92e6-38686ea8f8fa">
					<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="d539af2c-aa82-450f-936b-144d1ddec060">
					<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>
