<?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="Room nights" 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="advatar-1000"/>
	<parameter name="From" class="java.sql.Date"/>
	<parameter name="To" class="java.sql.Date"/>
	<queryString language="SQL">
		<![CDATA[SELECT 
	event_template.id,
	event_template.name,
	COUNT(CASE WHEN document.type='TRAVEL_CATALOG' THEN event.id ELSE null END) as count_offered,
	COUNT(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN event.id ELSE null END) as count_confirmed,
	(CASE WHEN geographic_location.type='DESTINATION' THEN geographic_location.name ELSE '' END) as geo_small,
	(CASE WHEN geographic_location.type='STATE' THEN geographic_location.name ELSE (
			CASE WHEN geographic_location.type='DESTINATION' THEN geo_state_destination.name ELSE '' END
		) END) as geo_medium,
	(CASE WHEN geographic_location.type='REGION' THEN geographic_location.name ELSE (
			CASE WHEN geographic_location.type='STATE' THEN geo_region_state.name ELSE (
				CASE WHEN geographic_location.type='DESTINATION' THEN geo_region_destination.name ELSE '' END
			) END
		) END) as geo_large,
	event_category.name as category_name,
	event_category.type as category_type,
	(CASE WHEN customer_location.number is not null THEN CONCAT('L', customer.number, '.',  customer_location.number) ELSE '' END) as supplier,
	customer.last_name as supplier_name,
	
	sum(CASE WHEN document.type='TRAVEL_CATALOG' THEN (extract('day' from age(date(event.jhi_end), date(event.start)))) ELSE 0 END) as room_nights_offered,
	sum(CASE WHEN document.type='TRAVEL_CONFIRMATION' THEN (extract('day' from age(date(event.jhi_end), date(event.start)))) ELSE 0 END) as room_nights_confirmed,
	
	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_template
	JOIN event_category on event_template.event_category_id = event_category.id
	LEFT JOIN customer_location on event_template.customer_location_id = customer_location.id
	LEFT JOIN customer on customer_location.customer_id = customer.id
	
	JOIN geographic_location on event_template.geographic_location_id = geographic_location.id
	LEFT JOIN destination geo_destination on geographic_location.id = geo_destination.id and geographic_location.type='DESTINATION'
	LEFT JOIN canton geo_state on geographic_location.id = geo_state.id and geographic_location.type='STATE'
	LEFT JOIN region geo_region on geographic_location.id = geo_region.id and geographic_location.type='REGION'
	
	LEFT JOIN geographic_location geo_state_destination on geo_destination.canton_id=geo_state_destination.id
	LEFT JOIN geographic_location geo_region_state on geo_state.region_id=geo_region_state.id
	
	LEFT JOIN canton geo_region_state_destination on geo_state_destination.id=geo_region_state_destination.id
	LEFT JOIN geographic_location geo_region_destination on geo_region_state_destination.region_id=geo_region_destination.id
	
	JOIN event on event_template.id = event.event_template_id
	JOIN document ON event.document_id = document.id 

WHERE event.event_template_id IS NOT NULL AND event_category.type='HOTEL' AND event.start BETWEEN $P{From} and  $P{To}
GROUP BY event_template.id, event_category.name, event_category.type, customer_location.number, customer.number, customer.last_name, geographic_location.name, geographic_location.type, geo_state_destination.name, geo_region_state.name, geo_region_destination.name
ORDER BY category_type ASC, category_name ASC, geo_large ASC, geo_medium ASC, geo_small ASC, customer_location.number ASC, customer.number ASC, name ASC]]>
	</queryString>
	<field name="id" class="java.lang.Long">
		<property name="com.jaspersoft.studio.field.name" value="id"/>
		<property name="com.jaspersoft.studio.field.label" value="id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_template"/>
	</field>
	<field name="name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="name"/>
		<property name="com.jaspersoft.studio.field.label" value="name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_template"/>
	</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="geo_small" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_small"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_small"/>
	</field>
	<field name="geo_medium" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_medium"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_medium"/>
	</field>
	<field name="geo_large" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="geo_large"/>
		<property name="com.jaspersoft.studio.field.label" value="geo_large"/>
	</field>
	<field name="category_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="category_name"/>
		<property name="com.jaspersoft.studio.field.label" value="category_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_category"/>
	</field>
	<field name="category_type" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="category_type"/>
		<property name="com.jaspersoft.studio.field.label" value="category_type"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event_category"/>
	</field>
	<field name="supplier" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="supplier"/>
		<property name="com.jaspersoft.studio.field.label" value="supplier"/>
	</field>
	<field name="supplier_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="supplier_name"/>
		<property name="com.jaspersoft.studio.field.label" value="supplier_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
	</field>
	<field name="room_nights_offered" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="room_nights_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="room_nights_offered"/>
	</field>
	<field name="room_nights_confirmed" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="room_nights_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="room_nights_confirmed"/>
	</field>
	<field name="sales_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_offered"/>
	</field>
	<field name="sales_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="sales_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="sales_turnover_confirmed"/>
	</field>
	<field name="profit_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_offered"/>
	</field>
	<field name="profit_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="profit_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="profit_confirmed"/>
	</field>
	<field name="purchase_turnover_offered" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_offered"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_offered"/>
	</field>
	<field name="purchase_turnover_confirmed" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="purchase_turnover_confirmed"/>
		<property name="com.jaspersoft.studio.field.label" value="purchase_turnover_confirmed"/>
	</field>
	<variable name="sales_turnover_confirmed3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_confirmed5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_confirmed5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_confirmed}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="sales_turnover_offered5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{sales_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered3" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered4" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="purchase_turnover_offered5" class="java.math.BigDecimal" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{purchase_turnover_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_offered5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{count_offered}]]></variableExpression>
	</variable>
	<variable name="count_confirmed3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="count_confirmed5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{count_confirmed}]]></variableExpression>
	</variable>
	<variable name="room_nights_offered3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_offered}]]></variableExpression>
	</variable>
	<variable name="room_nights_offered4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_offered}]]></variableExpression>
	</variable>
	<variable name="room_nights_offered5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_offered}]]></variableExpression>
	</variable>
	<variable name="room_nights_confirmed3" class="java.lang.Long" resetType="Group" resetGroup="Geo Large" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_confirmed}]]></variableExpression>
	</variable>
	<variable name="room_nights_confirmed4" class="java.lang.Long" resetType="Group" resetGroup="Geo Medium" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_confirmed}]]></variableExpression>
	</variable>
	<variable name="room_nights_confirmed5" class="java.lang.Long" resetType="Group" resetGroup="Geo Small" calculation="Sum">
		<variableExpression><![CDATA[$F{room_nights_confirmed}]]></variableExpression>
	</variable>
	<group name="Geo Large" isStartNewPage="true">
		<groupExpression><![CDATA[$F{geo_large}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<rectangle>
					<reportElement x="0" y="0" width="800" height="40" backcolor="#F5F5F5" uuid="8cb4a1a8-5335-453a-9736-13fb6cf9d824">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="0" y="20" width="399" height="19" uuid="5986b170-991b-4d4a-b3a7-2da4a8145a58"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="562" y="19" width="80" height="20" uuid="464b1fea-141d-4aaa-ba87-fa0bf0a7bf23">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_confirmed3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="29aaf380-a36f-4c73-863d-34ba91713757">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_offered3}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="0" y="0" width="399" height="19" uuid="5473a89a-6153-4d20-9d58-1fc10f061e4b"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large">
					<reportElement x="399" y="19" width="42" height="18" uuid="7d4455e9-cfd6-4936-bb7d-2fc75b86c0df"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered3}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Large">
					<reportElement x="523" y="19" width="38" height="18" uuid="0f16dd83-4f5f-4ea0-8929-8091981d9fc0"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed3}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Geo Medium" isStartNewPage="true">
		<groupExpression><![CDATA[$F{geo_medium}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<printWhenExpression><![CDATA[!$F{geo_medium}.equals("")]]></printWhenExpression>
				<rectangle>
					<reportElement x="10" y="0" width="789" height="40" backcolor="#F5F5F5" uuid="95146473-99cf-4b45-a0bc-af3962b9cdad">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="10" y="20" width="388" height="19" uuid="68dc9094-be4c-41ec-a736-f85c9e917763"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large} + " - " + $F{geo_medium}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="562" y="19" width="80" height="20" uuid="31c0c40d-2432-4537-863a-6a2d0a0f1dc2">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_confirmed4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="0d5493ec-b5b0-48fb-86ec-76e08f378ce7">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_offered4}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="10" y="0" width="388" height="19" uuid="c8797ebc-37ca-44de-aa09-c8ecec0f2c36"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium">
					<reportElement x="399" y="19" width="42" height="18" uuid="34cf0b57-f52e-4609-ae6d-db2d44b49e2b"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered4}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Medium">
					<reportElement x="523" y="19" width="38" height="18" uuid="d5430acc-fbe2-42dd-a403-6bb64e076d9c"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed4}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Geo Small">
		<groupExpression><![CDATA[$F{geo_small}]]></groupExpression>
		<groupHeader>
			<band height="42">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<printWhenExpression><![CDATA[!$F{geo_small}.equals("")]]></printWhenExpression>
				<rectangle>
					<reportElement x="20" y="0" width="780" height="40" backcolor="#F5F5F5" uuid="ffb63c7d-d06f-4882-bdea-8468d135d5c1">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement x="20" y="20" width="379" height="19" uuid="135432cf-d14a-4a19-b13b-480afa638ce8"/>
					<textElement>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{geo_large} + " - " + $F{geo_medium}  + " - " + $F{geo_small}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="562" y="19" width="80" height="20" uuid="61e1e1f9-754e-47fb-a73c-e1f5bb04454a">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_confirmed5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small" pattern="#,##0.00#;#,##0.00#-">
					<reportElement x="440" y="19" width="80" height="20" uuid="68a8f88e-dc8c-47be-b449-326bebdc13a1">
						<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>
					<textFieldExpression><![CDATA[$V{room_nights_offered5}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="20" y="0" width="379" height="19" uuid="afbacf2a-9af5-46c5-8fad-5ac4ca303fa8"/>
					<textElement verticalAlignment="Bottom">
						<font size="8" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{category_name}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small">
					<reportElement x="399" y="19" width="42" height="18" uuid="9dce5bd5-27bc-418a-9932-b4b6918f1d02"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_offered5}]]></textFieldExpression>
				</textField>
				<textField evaluationTime="Group" evaluationGroup="Geo Small">
					<reportElement x="523" y="19" width="38" height="18" uuid="8fa374d0-0348-44f0-8261-2f7578ab4336"/>
					<textElement textAlignment="Right">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{count_confirmed5}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<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[Room nights]]></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[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="50" height="20" uuid="58a68346-56d0-481a-8910-4f504f7b0b3a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a5ebb97-9ff6-4300-992b-578cfd5999b4"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[ID]]></text>
			</staticText>
			<staticText>
				<reportElement x="50" 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="439" 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[Room nights]]></text>
			</staticText>
			<staticText>
				<reportElement x="562" y="15" width="80" height="15" uuid="fc619706-f6ba-459f-933d-e38c232aac59">
					<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="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Room nights]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="400" y="0" width="122" height="15" 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="Center">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Offered]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="522" y="0" width="120" height="15" 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="Center">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Confirmed]]></text>
			</staticText>
			<staticText>
				<reportElement x="320" y="0" width="80" height="30" uuid="6136a7e8-44d1-488b-b2c3-2fe13225a45f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e4671070-94f2-4e00-82f0-370eeb035cfd"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Supplier]]></text>
			</staticText>
			<staticText>
				<reportElement x="522" y="15" width="39" height="15" uuid="f125d6d3-0034-41d4-b70b-509b024be3cd">
					<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="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
			<staticText>
				<reportElement x="400" 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="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[#]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="20" y="0" width="50" height="15" uuid="e96f9b83-2fc6-47f7-9e3c-16108e25094e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a5ebb97-9ff6-4300-992b-578cfd5999b4"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="70" y="0" width="250" 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{name}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="440" y="0" 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{room_nights_offered}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;#,##0.00#-">
				<reportElement x="561" y="0" 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{room_nights_confirmed}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="320" y="0" width="79" height="15" uuid="414cb2fe-6cfe-48da-8462-76814b7c8ea6">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e4671070-94f2-4e00-82f0-370eeb035cfd"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{supplier}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="400" y="0" 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="Right"/>
				<textFieldExpression><![CDATA[$F{count_offered}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="522" y="0" 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="Right"/>
				<textFieldExpression><![CDATA[$F{count_confirmed}]]></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>
			<textField evaluationTime="Group" evaluationGroup="Geo Small">
				<reportElement x="100" y="0" width="599" height="15" uuid="0155ea2a-a4b9-41b5-af10-907172a02a62">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement verticalAlignment="Top">
					<font size="8" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{category_name} + " - " + $F{geo_large} + " - " + $F{geo_medium}  + " - " + $F{geo_small}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
