<?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 type" 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_type.name as customer_type,
	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 location on location.id = dossier.customer_location_id
	JOIN customer on customer.id = location.customer_id
	JOIN customer_customer_type ctm on ctm.customer_id = customer.id
	JOIN customer_type on ctm.customer_type_id = customer_type.id

WHERE event.start BETWEEN $P{From} and  $P{To}
GROUP BY customer_type.name
order by customer_type.name]]>
	</queryString>
	<field name="customer_type" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="customer_type"/>
		<property name="com.jaspersoft.studio.field.label" value="customer_type"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="customer_type"/>
	</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="51" 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 type]]></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>
			<textField>
				<reportElement x="170" y="-15" width="630" height="15" uuid="44278390-8a55-4d9e-83bc-f65b024d4264">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Please be aware, that if a company has assigned multiple company types, the turnover will be counted multiple times too."]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="153" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<staticText>
				<reportElement mode="Transparent" x="209" y="0" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="6561cf5a-b5fa-4c0a-8395-20a73acba2f7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="209" y="37" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="566deab5-3b42-4053-b127-1fc2c5a6420d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="208" height="15" uuid="52860d11-1450-4c78-9151-b9df90db2e52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{customer_type}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="52" width="80" height="15" uuid="33aa7f1a-b1bd-459e-94ad-e6bef027c88b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="15" width="80" height="15" uuid="3454d714-a7db-4954-b66d-24cac0e51807">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="15" width="80" height="15" uuid="9f88a151-969c-4d71-a242-0ba2458931cc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{profit_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="52" width="80" height="15" uuid="8f917b82-1e42-4ae1-97e2-b67c35e63fdc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{profit_confirmed}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="15" width="40" height="15" uuid="430171ff-6f33-4103-bf89-fff1523f94b1">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{count_offered}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="52" width="40" height="15" uuid="01765fea-8462-4d85-9305-b14fd8928f73">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{count_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="15" width="80" height="15" uuid="1d879581-429f-4a86-a531-d4518af3f1c5">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="15" width="80" height="15" uuid="040e7279-657c-43de-851d-c7cec1ecc898">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{purchase_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="15" width="80" height="15" uuid="d4dbe929-16de-4b53-a3f7-a4684d2bab1c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{sales_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="150" width="800" height="1" uuid="db114094-4d1a-40a7-b399-df2c304a09fe"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="52" width="80" height="15" uuid="92af0efa-d508-48be-ae59-ee624225a8b5">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="52" width="80" height="15" uuid="4bdaf803-8ac3-4fa8-89db-272b03acbdaa">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{purchase_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="52" width="80" height="15" uuid="2365dcbd-54ad-4ddc-a4e7-47a6cfe078a0">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{sales_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="89" width="80" height="15" uuid="c4a60a91-08ee-4120-803c-68452ea4e523">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_storno}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="89" width="40" height="15" uuid="17867089-dde8-4c55-9292-c2ab8dd769f6">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{count_storno}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="209" y="74" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="f2a70c92-cfd1-4fea-9801-95393b72615b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Cancelled]]></text>
			</staticText>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="89" width="80" height="15" uuid="dc1d6ec8-b9c0-4b78-88d1-a5c9f544d825">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_storno}.doubleValue() / $F{purchase_turnover_storno}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="89" width="80" height="15" uuid="2e3deeaa-4356-4d16-812c-cde6b63ead88">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_storno}.doubleValue() / $F{sales_turnover_storno}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="89" width="80" height="15" uuid="358ccbc3-ec8e-447f-bbb3-1d905dabc19a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{profit_storno}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="89" width="80" height="15" uuid="76b57538-7bf6-4bcc-94d5-559eda6e8ed8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_storno}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="209" y="112" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="1f7b1145-45cc-4c76-916c-16032bb39682">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Lost]]></text>
			</staticText>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="329" y="127" width="80" height="15" uuid="d10da79d-06a9-45f1-a434-99e5edfc8c8f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{profit_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="410" y="127" width="80" height="15" uuid="0464b019-86bb-4f03-b73c-f157694d4fc0">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{sales_turnover_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="490" y="127" width="80" height="15" uuid="5e983284-1058-4026-ae6f-9e786486bdce">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_canceled}.doubleValue() / $F{purchase_turnover_canceled}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="127" width="40" height="15" uuid="ed93a934-ea62-4d15-a03f-591896948fbf">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Left"/>
				<textFieldExpression><![CDATA[$F{count_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="249" y="127" width="80" height="15" uuid="149054be-9b8f-4595-93f1-67c7a7eae26d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{purchase_turnover_canceled}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="127" width="80" height="15" uuid="242cd149-a1e8-45de-ac93-69258e322832">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[new Double($F{profit_canceled}.doubleValue() / $F{sales_turnover_canceled}.doubleValue())*100]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="17" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="0" y="0" width="100" height="15" uuid="7ac7cf54-f6d6-4e10-8854-383452db3c5f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["advatra - " + DATEFORMAT(TODAY( ),"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="700" y="0" width="100" height="15" uuid="280d34e0-be05-4180-a898-fe7ac07e904a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="243">
			<rectangle>
				<reportElement x="0" y="51" width="800" height="30" backcolor="#F5F5F5" uuid="0a516f18-ad8c-455c-b3cb-9e45216abd37">
					<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="0fcde627-5038-4c1b-bdc7-6657df4fcbd1">
					<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="4e31d66e-5bf3-4c0b-adfb-86d4456cc2c6">
					<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="39e5a0d5-9ec1-4cc9-bbbc-1a6d695b543a">
					<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="d7312537-b962-429b-ba2b-99fbdc5da219">
					<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="ef54e10d-d771-43ca-be6d-04e4c1d0b39f"/>
				<textFieldExpression><![CDATA[$V{count_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="139" width="42" height="18" uuid="983473e1-4391-4bfa-a180-555a366e60f5"/>
				<textFieldExpression><![CDATA[$V{count_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="208" y="176" width="44" height="18" uuid="89c0128c-105d-406c-b95c-dde83a4134fc"/>
				<textFieldExpression><![CDATA[$V{count_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="214" width="42" height="18" uuid="b2147be5-658d-4f47-b445-833a46c48d76"/>
				<textFieldExpression><![CDATA[$V{count_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="102" width="80" height="18" uuid="e8224de1-d2fb-4564-b836-cf4a97791575"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="407" y="139" width="82" height="18" uuid="ff158ddb-fa1a-4dc9-9127-cc2ec66a8114"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="409" y="176" width="82" height="18" uuid="e526f419-1e37-4c04-a57e-a5878440c93a"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="410" y="214" width="80" height="18" uuid="409405d2-f3cb-42f3-8617-a2333ea80e25"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{sales_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="102" width="80" height="18" uuid="e1324a1a-d9bd-414d-b0b4-946603a02b23"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="139" width="78" height="18" uuid="3e03bb96-a3fa-4c34-8780-459ae8d3921d"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="328" y="176" width="80" height="18" uuid="99789844-7baf-426b-bdfa-a4c0cbb85191"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="329" y="214" width="80" height="18" uuid="341c8d27-1114-4f5c-b1a0-fe55fa6cb513"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{profit_canceled1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="102" width="76" height="18" uuid="e9e2f39d-b6f0-4140-9f43-d1a68d7c6436"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_offered1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="251" y="139" width="78" height="18" uuid="e44c0bb9-1898-49a2-9ab8-8370dc345242"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_confirmed1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="176" width="76" height="18" uuid="6340eacc-948a-4719-8005-f29fb0a2f4d0"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_storno1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="252" y="214" width="76" height="18" uuid="9b0e4c1d-980c-4da4-857f-9e1d15a0577b"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$V{purchase_turnover_canceled1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="411" y="66" width="80" height="15" uuid="6fe96fd2-583c-40e4-9277-52b1be02da38">
					<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="db2993f6-7fdd-4e33-8c59-e8c404fa48e2">
					<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="db7e1872-c79e-4f0c-a4e8-b557a21d4492">
					<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="bacf97fb-3139-4411-9ed0-2bca6272cc6b">
					<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="bdeb4f5f-bd88-453c-9458-73b2aaa0eb98">
					<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="6f669bbe-ea91-424f-856b-257db25be0b2">
					<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="dbe352ec-cc01-4d7e-98a0-fee839bbfdbe">
					<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="1b9ec34d-9109-4a4e-9c6f-a43f5d27da1b"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="310" height="20" uuid="58024dcb-1b22-4ba0-8c88-77eb409123c7"/>
				<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="7cb472a9-20b5-445d-8d2a-5abd6025a341">
					<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="10997b41-4d24-4a10-a045-75bbdc91ba27">
					<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="03865e92-244d-4eca-9e71-ee928869e6f6"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="570" y="102" width="80" height="15" uuid="090da98b-a59c-4c50-b922-a9f2e739a905">
					<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="32526e92-d463-4511-ad28-c73cc3e9fde8">
					<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="a5fb71d7-4094-4eb1-95e4-9447d074d1d6">
					<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="bd5fbec4-301a-4a6e-af32-4ba772b3987c">
					<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="8c4d2bc3-380d-4458-a3a2-87c0bf5b47ce">
					<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="1170355a-7373-4da8-8726-80b61fc9ed57">
					<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="711514f6-fbeb-4fa2-b6bf-700c0f1180d1">
					<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="398daf59-1edc-479e-91f7-632fda4409ac">
					<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>
