<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.21.3.final using JasperReports Library version 6.21.3-4a3078d20785ebe464f18037d738d12fc98c13cf  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Canceled Dossiers" 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(MIN(customer.last_name), ' ', MIN(customer.first_name)) as customer,
	CONCAT('D', dossier.number) as dossier_nr,
	dossier.name as dossier_name,
	dossier.status as dossier_status,
	department.name as dossier_department,
	dossier.opening_date as dossier_opening_date,
	MIN(travel_document.start) as travel_start,
	(MIN(travel_document.start) - dossier.opening_date) as days_before_travel,
	
	sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.brutto_price ELSE 0 END) as sales_turnover_offered,
	sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.brutto_price ELSE 0 END) as sales_turnover_confirmed,
	sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.profit_after_discount ELSE 0 END) as profit_offered,
	sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.profit_after_discount ELSE 0 END) as profit_confirmed,
	(sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_offered,
	(sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.brutto_price ELSE 0 END) - sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.profit_after_discount ELSE 0 END)) as purchase_turnover_confirmed


FROM event
	JOIN document ON event.document_id = document.id
	JOIN travel_document ON document.id = travel_document.id
	JOIN dossier ON document.dossier_id = dossier.id
	JOIN customer_location ON dossier.customer_location_id = customer_location.id
	JOIN customer on customer_location.customer_id = customer.id
	JOIN department on dossier.department_id = department.id
	
WHERE event.start BETWEEN $P{From} and  $P{To} AND dossier.status = 'CANCELED'
GROUP BY dossier.id, department.name
ORDER BY department.name, dossier.number]]>
	</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="dossier_nr" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_nr"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_nr"/>
	</field>
	<field name="dossier_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_name"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="dossier_status" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_status"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_status"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="dossier_department" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="dossier_department"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_department"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="department"/>
	</field>
	<field name="dossier_opening_date" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="dossier_opening_date"/>
		<property name="com.jaspersoft.studio.field.label" value="dossier_opening_date"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="dossier"/>
	</field>
	<field name="travel_start" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="travel_start"/>
		<property name="com.jaspersoft.studio.field.label" value="travel_start"/>
	</field>
	<field name="days_before_travel" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="days_before_travel"/>
		<property name="com.jaspersoft.studio.field.label" value="days_before_travel"/>
	</field>
	<field name="sales_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_offered"/>
	</field>
	<field name="sales_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_confirmed"/>
	</field>
	<field name="profit_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_offered"/>
	</field>
	<field name="profit_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_confirmed"/>
	</field>
	<field name="purchase_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_offered"/>
	</field>
	<field name="purchase_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_confirmed"/>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="55" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<image>
				<reportElement x="0" y="0" width="170" height="30" uuid="58347aa4-4f49-4c04-8c39-b8a0b97e1cf8"/>
				<imageExpression><![CDATA["https://cdn.simplit.swiss/advatra/logo.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="170" y="0" width="400" height="20" uuid="dac20ad5-35eb-4fe1-aab4-ac3db438831e"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Canceled dossiers]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="20" width="310" height="15" uuid="33ab0374-ca13-47bb-8602-cf38d7130761">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Travel dates: " + DATEFORMAT($P{From},"dd/MM/yyyy") + " - "+DATEFORMAT($P{To},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="170" y="35" width="400" height="15" uuid="ef249afa-85e3-4241-96b9-da344516fed6"/>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[ordered by days before travel start, ascending]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="36" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<rectangle>
				<reportElement x="0" y="2" width="800" height="30" backcolor="#F5F5F5" uuid="9b5e32a5-ac08-4b72-9b4b-c668d65ce6a5">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<graphicElement>
					<pen lineColor="#F5F5F5"/>
				</graphicElement>
			</rectangle>
			<staticText>
				<reportElement x="0" y="9" width="100" height="23" uuid="e1e2e129-ca8d-43fe-8de3-6aa57e23ebb4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Customer
Dossier]]></text>
			</staticText>
			<staticText>
				<reportElement x="560" y="15" width="80" height="15" uuid="28589ca9-91f4-4d68-a89b-2fdee26c908e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Sales]]></text>
			</staticText>
			<staticText>
				<reportElement x="478" y="15" width="80" height="15" uuid="27b74f34-b7ca-4957-98c4-5cbfc358600f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Profit]]></text>
			</staticText>
			<staticText>
				<reportElement x="398" y="15" width="80" height="15" uuid="369965a8-d713-41d9-9af9-13a8bd1783b4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Purchase]]></text>
			</staticText>
			<staticText>
				<reportElement x="639" y="15" width="80" height="15" uuid="57daaac3-df2b-4551-acce-67222edb98ab">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Markup %]]></text>
			</staticText>
			<staticText>
				<reportElement x="719" y="15" width="80" height="15" uuid="45301730-3e3e-4328-9cef-d76301bba34c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Margin %]]></text>
			</staticText>
			<staticText>
				<reportElement x="190" y="10" width="60" height="21" uuid="37c039ae-a9fc-4172-b647-953c763302c2">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Opening
date]]></text>
			</staticText>
			<staticText>
				<reportElement x="250" y="10" width="60" height="21" uuid="0396bebf-2762-4575-92d0-9761e98cb29b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Travel
start]]></text>
			</staticText>
			<staticText>
				<reportElement x="310" y="10" width="48" height="21" uuid="30241181-9d2d-42b5-8baa-499fb54be47c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Days before travel start]]></text>
			</staticText>
			<staticText>
				<reportElement x="110" y="17" width="70" height="15" uuid="40a948e4-70b9-435b-b95f-20647a6068f8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Reason]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="62" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<staticText>
				<reportElement mode="Transparent" x="358" y="0" width="440" height="14" backcolor="rgba(0, 0, 255, 0.13333334)" uuid="6561cf5a-b5fa-4c0a-8395-20a73acba2f7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="358" y="19" width="440" height="14" backcolor="rgba(0, 255, 0, 0.16862746)" uuid="566deab5-3b42-4053-b127-1fc2c5a6420d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="190" height="15" uuid="52860d11-1450-4c78-9151-b9df90db2e52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{customer}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="559" y="20" width="80" height="15" uuid="33aa7f1a-b1bd-459e-94ad-e6bef027c88b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64ed4e3-a0a4-4736-9149-d11f24ea5267"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{sales_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="559" y="1" width="80" height="15" uuid="3454d714-a7db-4954-b66d-24cac0e51807">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{sales_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="478" y="1" width="80" height="15" uuid="9f88a151-969c-4d71-a242-0ba2458931cc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{profit_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="478" y="20" width="80" height="15" uuid="8f917b82-1e42-4ae1-97e2-b67c35e63fdc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="34e6482f-f9b3-4d54-bab3-662b5204bec0"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{profit_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="1" width="80" height="15" uuid="1d879581-429f-4a86-a531-d4518af3f1c5">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{purchase_turnover_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="1" width="80" height="15" uuid="040e7279-657c-43de-851d-c7cec1ecc898">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{purchase_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="1" width="80" height="15" uuid="d4dbe929-16de-4b53-a3f7-a4684d2bab1c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_offered}.doubleValue() / $F{sales_turnover_offered}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="56" width="800" height="1" uuid="db114094-4d1a-40a7-b399-df2c304a09fe"/>
			</line>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="398" y="20" width="80" height="15" uuid="92af0efa-d508-48be-ae59-ee624225a8b5">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bf0b49f3-b9f7-45e6-8f00-5af6fdee3797"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{purchase_turnover_confirmed}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="639" y="20" width="80" height="15" uuid="4bdaf803-8ac3-4fa8-89db-272b03acbdaa">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{purchase_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="719" y="20" width="80" height="15" uuid="2365dcbd-54ad-4ddc-a4e7-47a6cfe078a0">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1a56e6-2fe7-4899-a3d0-eb91e2b4bba3"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($F{profit_confirmed}.doubleValue() / $F{sales_turnover_confirmed}.doubleValue())*100]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="16" width="110" height="15" uuid="ff1e09d3-b0a6-42bc-ab71-d9b7b81448b1">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dossier_nr}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="33" width="190" height="17" uuid="e3574c29-3e3b-416f-926a-18c0cd72e061">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dossier_name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="110" y="16" width="80" height="15" uuid="2ece9e0e-b960-4f60-91ef-ae8279b0155c">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false" isItalic="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dossier_department}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="190" y="1" width="60" height="15" uuid="5f4eb392-8264-4d2c-a67e-7d95dabde1c2">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[DATEFORMAT($F{dossier_opening_date},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="250" y="1" width="60" height="15" uuid="de979f91-c411-4435-bf36-00413a5f8e08">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[DATEFORMAT($F{travel_start},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="310" y="1" width="48" height="15" uuid="141bac4c-7c8e-4d55-8424-c3ac11f68f02">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d264a419-cc28-4afc-a2b4-363e146b0989"/>
				</reportElement>
				<textElement>
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{days_before_travel}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="17" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="0" y="0" width="100" height="15" uuid="7ac7cf54-f6d6-4e10-8854-383452db3c5f">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["advatra - " + DATEFORMAT(TODAY( ),"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="700" y="0" width="100" height="15" uuid="280d34e0-be05-4180-a898-fe7ac07e904a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
