<?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="Product_without_template" pageWidth="595" pageHeight="842" columnWidth="555" 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.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<parameter name="From" class="java.sql.Date"/>
	<parameter name="To" class="java.sql.Date"/>
	<queryString language="SQL">
		<![CDATA[SELECT event.title,
	event.type,
	event.sub_title,
	event.description,
	event.start,
	event.id,
	document.date as document_date,
	CONCAT('D', dossier.number, '.',  document.number) as nr
FROM event
	RIGHT JOIN document ON 
	 event.document_id = document.id 
	RIGHT JOIN dossier ON 
	 document.dossier_id = dossier.id 
WHERE 
	 event.event_template_id IS NULL AND document.date BETWEEN $P{From} and  $P{To} AND event.id IS NOT null
ORDER BY event.type, event.title ASC]]>
	</queryString>
	<field name="title" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="title"/>
		<property name="com.jaspersoft.studio.field.label" value="title"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event"/>
	</field>
	<field name="type" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="type"/>
		<property name="com.jaspersoft.studio.field.label" value="type"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event"/>
	</field>
	<field name="sub_title" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="sub_title"/>
		<property name="com.jaspersoft.studio.field.label" value="sub_title"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event"/>
	</field>
	<field name="description" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="description"/>
		<property name="com.jaspersoft.studio.field.label" value="description"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event"/>
	</field>
	<field name="start" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="start"/>
		<property name="com.jaspersoft.studio.field.label" value="start"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="event"/>
	</field>
	<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"/>
	</field>
	<field name="document_date" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="document_date"/>
		<property name="com.jaspersoft.studio.field.label" value="document_date"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="document"/>
	</field>
	<field name="nr" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nr"/>
		<property name="com.jaspersoft.studio.field.label" value="nr"/>
	</field>
	<group name="type" isStartNewPage="true">
		<groupExpression><![CDATA[$F{type}]]></groupExpression>
		<groupHeader>
			<band height="22">
				<property name="com.jaspersoft.studio.unit.height" value="px"/>
				<rectangle>
					<reportElement x="0" y="0" width="550" height="20" backcolor="#F5F5F5" uuid="39ac9418-a128-47c1-980b-5d83c31306ad"/>
					<graphicElement>
						<pen lineColor="#F5F5F5"/>
					</graphicElement>
				</rectangle>
				<textField>
					<reportElement mode="Transparent" x="0" y="0" width="550" height="20" backcolor="#FFFFFF" uuid="cfa61e08-512d-4bc4-a030-b3c11faed661">
						<property name="com.jaspersoft.studio.unit.spacingBefore" value="px"/>
						<property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
					<textElement textAlignment="Center">
						<font isBold="true"/>
						<paragraph spacingBefore="4"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{type}]]></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[Products with no template assigned]]></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="32" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<rectangle>
				<reportElement x="0" y="0" width="550" 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="150" y="0" width="240" height="30" uuid="924e0461-483e-47d1-91d8-1dc8c14d711d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="68b94204-e35d-43c3-a095-ed262cf6a1a8"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Title
Subtitle]]></text>
			</staticText>
			<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="390" y="0" width="90" height="20" uuid="bffc20bf-5c5a-4977-891d-74b455dde657">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c5f83b56-9729-4753-a73e-45fc1ffc9bac"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Document]]></text>
			</staticText>
			<staticText>
				<reportElement x="50" y="0" width="100" height="20" uuid="0ba47ac1-6e6c-4436-9eb9-a3a1bd589fc5">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0026369d-4566-46f5-8ca1-2cee3cbfdc39"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Date/Time]]></text>
			</staticText>
			<staticText>
				<reportElement x="480" y="0" width="70" height="20" uuid="3952aa64-cbc6-4fb4-9ecf-1e3f36677084">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6980e22-6eef-4e60-933c-b6b3956ead90"/>
				</reportElement>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Date]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="32" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="150" y="0" width="240" height="15" uuid="9157d5e9-1805-4ac5-9a35-9ceb9def7a50">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="68b94204-e35d-43c3-a095-ed262cf6a1a8"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="150" y="15" width="240" height="15" uuid="86a9a93b-ce67-4e80-9079-026025058672">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="78edfa10-4694-4783-9101-27b834f7796f"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[IF(EQUALS($F{sub_title},null),"-",$F{sub_title})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="50" height="30" uuid="e96f9b83-2fc6-47f7-9e3c-16108e25094e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a5ebb97-9ff6-4300-992b-578cfd5999b4"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="390" y="0" width="90" height="30" uuid="1f51663e-4caa-4576-a892-a3eae7494b4b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c5f83b56-9729-4753-a73e-45fc1ffc9bac"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{nr}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="50" y="0" width="100" height="30" uuid="455ae63c-aacd-4b5b-844d-5e4d254c7c11">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0026369d-4566-46f5-8ca1-2cee3cbfdc39"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{start}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="480" y="0" width="70" height="30" uuid="3d030f09-1104-4f24-85c3-1aa16ca7162a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6980e22-6eef-4e60-933c-b6b3956ead90"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[DATEFORMAT($F{document_date},"dd/MM/yyyy")]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="15" 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="450" 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>
