Skip to content

Instantly share code, notes, and snippets.

@netslow
Created February 27, 2023 12:55
Show Gist options
  • Save netslow/500d503a6bb9314f28604a78cd9b773e to your computer and use it in GitHub Desktop.
Save netslow/500d503a6bb9314f28604a78cd9b773e to your computer and use it in GitHub Desktop.
Forks and spoons with fixed layout
<?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="forks-and-spoons" pageWidth="1191" pageHeight="842" orientation="Landscape" columnWidth="1151" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e56c1564-4137-482a-bd33-dbdae76075ae">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="localTst"/>
<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="daysCount" class="java.lang.Integer">
<defaultValueExpression><![CDATA[31]]></defaultValueExpression>
</parameter>
<queryString language="SQL">
<![CDATA[select distinct i.item_id, i.name, s.country,
d1.amount d1,
d2.amount d2,
d3.amount d3,
d4.amount d4,
d5.amount d5,
d6.amount d6,
d7.amount d7,
d8.amount d8,
d9.amount d9,
d10.amount d10,
d11.amount d11,
d12.amount d12,
d13.amount d13,
d14.amount d14,
d15.amount d15,
d16.amount d16,
d17.amount d17,
d18.amount d18,
d19.amount d19,
d20.amount d20,
d21.amount d21,
d22.amount d22,
d23.amount d23,
d24.amount d24,
d25.amount d25,
d26.amount d26,
d27.amount d27,
d28.amount d28,
d29.amount d29,
d30.amount d30,
d31.amount d31
from items i
left join items_sales s on s.item_id = i.item_id
left join items_sales d1 on s.country = d1.country and d1."day" = 1 and s.item_id = d1.item_id
left join items_sales d2 on s.country = d2.country and d2."day" = 2 and s.item_id = d2.item_id
left join items_sales d3 on s.country = d3.country and d3."day" = 3 and s.item_id = d3.item_id
left join items_sales d4 on s.country = d4.country and d4."day" = 4 and s.item_id = d4.item_id
left join items_sales d5 on s.country = d5.country and d5."day" = 5 and s.item_id = d5.item_id
left join items_sales d6 on s.country = d6.country and d6."day" = 6 and s.item_id = d6.item_id
left join items_sales d7 on s.country = d7.country and d7."day" = 7 and s.item_id = d7.item_id
left join items_sales d8 on s.country = d8.country and d8."day" = 8 and s.item_id = d8.item_id
left join items_sales d9 on s.country = d9.country and d9."day" = 9 and s.item_id = d9.item_id
left join items_sales d10 on s.country = d10.country and d10."day" = 10 and s.item_id = d10.item_id
left join items_sales d11 on s.country = d11.country and d11."day" = 11 and s.item_id = d11.item_id
left join items_sales d12 on s.country = d12.country and d12."day" = 12 and s.item_id = d12.item_id
left join items_sales d13 on s.country = d13.country and d13."day" = 13 and s.item_id = d13.item_id
left join items_sales d14 on s.country = d14.country and d14."day" = 14 and s.item_id = d14.item_id
left join items_sales d15 on s.country = d15.country and d15."day" = 15 and s.item_id = d15.item_id
left join items_sales d16 on s.country = d16.country and d16."day" = 16 and s.item_id = d16.item_id
left join items_sales d17 on s.country = d17.country and d17."day" = 17 and s.item_id = d17.item_id
left join items_sales d18 on s.country = d18.country and d18."day" = 18 and s.item_id = d18.item_id
left join items_sales d19 on s.country = d19.country and d19."day" = 19 and s.item_id = d19.item_id
left join items_sales d20 on s.country = d20.country and d20."day" = 20 and s.item_id = d20.item_id
left join items_sales d21 on s.country = d21.country and d21."day" = 21 and s.item_id = d21.item_id
left join items_sales d22 on s.country = d22.country and d22."day" = 22 and s.item_id = d22.item_id
left join items_sales d23 on s.country = d23.country and d23."day" = 23 and s.item_id = d23.item_id
left join items_sales d24 on s.country = d24.country and d24."day" = 24 and s.item_id = d24.item_id
left join items_sales d25 on s.country = d25.country and d25."day" = 25 and s.item_id = d25.item_id
left join items_sales d26 on s.country = d26.country and d26."day" = 26 and s.item_id = d26.item_id
left join items_sales d27 on s.country = d27.country and d27."day" = 27 and s.item_id = d27.item_id
left join items_sales d28 on s.country = d28.country and d28."day" = 28 and s.item_id = d28.item_id
left join items_sales d29 on s.country = d29.country and d29."day" = 29 and s.item_id = d29.item_id
left join items_sales d30 on s.country = d30.country and d30."day" = 30 and s.item_id = d30.item_id
left join items_sales d31 on s.country = d31.country and d31."day" = 31 and s.item_id = d31.item_id]]>
</queryString>
<field name="item_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.name" value="item_id"/>
<property name="com.jaspersoft.studio.field.label" value="item_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="items"/>
</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="items"/>
</field>
<field name="country" class="java.lang.String">
<property name="com.jaspersoft.studio.field.name" value="country"/>
<property name="com.jaspersoft.studio.field.label" value="country"/>
<property name="com.jaspersoft.studio.field.tree.path" value="items_sales"/>
</field>
<field name="d1" class="java.lang.Float"/>
<field name="d2" class="java.lang.Float"/>
<field name="d3" class="java.lang.Float"/>
<field name="d4" class="java.lang.Float"/>
<field name="d5" class="java.lang.Float"/>
<field name="d6" class="java.lang.Float"/>
<field name="d7" class="java.lang.Float"/>
<field name="d8" class="java.lang.Float"/>
<field name="d9" class="java.lang.Float"/>
<field name="d10" class="java.lang.Float"/>
<field name="d11" class="java.lang.Float"/>
<field name="d12" class="java.lang.Float"/>
<field name="d13" class="java.lang.Float"/>
<field name="d14" class="java.lang.Float"/>
<field name="d15" class="java.lang.Float"/>
<field name="d16" class="java.lang.Float"/>
<field name="d17" class="java.lang.Float"/>
<field name="d18" class="java.lang.Float"/>
<field name="d19" class="java.lang.Float"/>
<field name="d20" class="java.lang.Float"/>
<field name="d21" class="java.lang.Float"/>
<field name="d22" class="java.lang.Float"/>
<field name="d23" class="java.lang.Float"/>
<field name="d24" class="java.lang.Float"/>
<field name="d25" class="java.lang.Float"/>
<field name="d26" class="java.lang.Float"/>
<field name="d27" class="java.lang.Float"/>
<field name="d28" class="java.lang.Float"/>
<field name="d29" class="java.lang.Float"/>
<field name="d30" class="java.lang.Float"/>
<field name="d31" class="java.lang.Float"/>
<sortField name="country"/>
<group name="country">
<groupExpression><![CDATA[$F{country}]]></groupExpression>
<groupHeader>
<band height="25" splitType="Stretch">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField textAdjust="StretchHeight" isBlankWhenNull="true">
<reportElement mode="Opaque" x="0" y="0" width="1151" height="25" backcolor="#FAEEED" uuid="c175dddf-e626-46c6-a19e-2356627bf1dc">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
</group>
<columnHeader>
<band height="50">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="63" height="30" backcolor="#D1D1D1" uuid="b996be13-deba-4fee-b694-8d094810d57d">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8de634f7-8396-4ae7-999c-863fdc0b0429"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[item_id]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="63" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="41ed6b29-af3d-43ae-9edc-f98e99543308">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bc29b12d-a3e9-4090-a67e-485659a3374c"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[name]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="97" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="9ebeede0-68bb-47b2-a639-0ff8103c4380">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="95e38911-19ea-444c-acd5-504001a32cc1"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d1]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="131" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="d8c79264-9b68-4118-b31b-30271efb817e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="734850da-8232-46de-b38a-b8bdd4735c0d"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d2]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="165" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="cf18cfa4-37e1-4f8f-ba41-fe70016149ee">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2508252f-b980-42c7-8e1e-4d6ea072ea2f"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d3]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="199" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="d96571b2-8726-496f-8975-80d46800298d">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b1f35301-b6f8-44be-ad27-4d127614ae27"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d4]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="233" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="be84dcfd-e1c2-4123-a177-4155a4ab43ac">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3cef17f6-991f-4540-b271-cb2576690dab"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d5]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="267" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="7c9a56f8-ecc8-481c-8a49-2a0dbf96e2e0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9526b35a-8e3d-46f3-a56a-d9a2b0f4c4bc"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d6]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="301" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="710e0e92-6e4f-4a4d-8f92-2c1509e7ca8e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb5620e4-87b2-4d41-ade0-7c93f6d035ce"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d7]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="335" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="5c1accd5-0376-4d8b-9f67-03a44bac352c">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ba43a013-0c67-453f-9c61-795fb550c0d5"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d8]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="369" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="a5468462-2f90-4ad8-b0a5-6475edbdd5e1">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e5f0138a-eb12-49b3-9893-27b45672c923"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d9]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="403" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="614b7664-72ae-459c-a955-338fc7cc03c3">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="12b46166-6f36-4562-9b88-b5b2fb34b76b"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d10]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="437" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="bc8f4d73-ef71-4a25-9eff-33eba210e6ac">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7cc0187f-342f-4e3d-8700-4f166a897bfc"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d11]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="471" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="a95cc0fe-bfbd-4b50-89ea-4b968af44fc4">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="24bd1148-fd3c-4224-8300-bdf41b93da45"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d12]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="505" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="36cc171a-4b4f-46ee-ad8d-9188ca4e195c">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="948c6190-71b1-465b-8b0f-d3a1d209ace8"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d13]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="539" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="5cf7ed8c-4b97-479f-b835-27ebc4abe29d">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6e31c5e7-db46-46e8-bd1d-cbd0e4be55a9"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d14]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="573" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="35695371-1cbe-4016-b02b-8cf924dd7938">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86d2cd24-a334-4b77-8fc1-fe4e8f8b9116"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d15]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="607" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="0a5293b0-8f04-4b31-a2a4-48382cbd48d6">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a943eed-1a4b-48dc-9969-3c853c28dc26"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d16]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="641" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="3390cb79-e7de-4269-95f0-8b9c808a2218">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5b0a3bfe-3ad8-4408-8f91-86cd173ac850"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d17]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="675" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="e8ed2f5b-ca50-43cd-a2f3-74cd3a667676">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="340e8def-30ee-471e-86e5-feee78b1adf3"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d18]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="709" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="1cc698a4-1eb6-4076-b229-7658bb3c2e71">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5d912cd1-421e-4603-a29a-2f526a5ca90b"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d19]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="743" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="897c4c2b-b489-4818-866d-3c55d18efc86">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4e0c00ad-e418-4da0-a007-e88e58391f82"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d20]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="777" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="82270e99-c8a3-4670-bac6-7a8f61e342d7">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8179b636-a9ef-43b0-bc1e-e8dad05e57e7"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d21]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="811" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="906bb822-c828-454b-b764-5f263986a2ce">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="baeddec3-6cc7-4f86-9280-5141cadefe55"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d22]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="845" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="daf4e561-1022-4a7e-9e6c-b5b9cff6f6be">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1101965a-0187-47ea-aaee-903c0c14e5a6"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d23]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="879" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="b779aa7a-4be5-4cd7-9e1a-550d1a37fa01">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c3e47755-a81c-472f-906f-5767c4bc9899"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d24]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="913" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="76409c2d-cbe8-4934-942a-5c6abbc6e19e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="65504bb3-7755-4be7-992f-6a64f38ffb9c"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d25]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="947" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="6b0364c2-cb2c-4b72-bfc2-a356430d0484">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5ed4e460-2c83-4477-a408-3891c83f9d85"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d26]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="981" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="643da503-f8c5-4a64-9a48-4452394fce27">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8dadd4e3-729d-4d83-9352-2ff4fee722c3"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d27]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="1015" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="09df88ee-4b5c-436d-baac-9cb14ab9e413">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a4f471f9-4c9c-4380-b761-c28784417eb0"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d28]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="1049" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="0aeaf998-b438-460d-a0de-c9ac029618a4">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fa0350ff-a7c7-4d42-aee9-9589059a271a"/>
<printWhenExpression><![CDATA[$P{daysCount} >= 29]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d29]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="1083" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="fa4106b0-448d-4423-9026-49535617749d">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="71320df5-ce3d-45de-ab77-6157f2df698f"/>
<printWhenExpression><![CDATA[$P{daysCount} >= 30]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d30]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="1117" y="0" width="34" height="30" backcolor="#D1D1D1" uuid="40d99f22-87ff-404e-bd45-5e2908857c72">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="368871a9-5ea3-45d5-be29-61eb4591fed6"/>
<printWhenExpression><![CDATA[$P{daysCount} == 31]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[d31]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="30">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField isBlankWhenNull="true">
<reportElement x="0" y="0" width="63" height="30" uuid="7a00fa66-09aa-49bc-b052-2f4069cc5a82">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8de634f7-8396-4ae7-999c-863fdc0b0429"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{item_id}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="63" y="0" width="34" height="30" uuid="14e925dd-4eee-405e-9b9f-6c86690805d6">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bc29b12d-a3e9-4090-a67e-485659a3374c"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="97" y="0" width="34" height="30" uuid="2f6a03b9-e9d9-4e58-b60b-3f7d2b278731">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="95e38911-19ea-444c-acd5-504001a32cc1"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d1}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="131" y="0" width="34" height="30" uuid="35e62597-eebb-4720-922f-582e8307ca17">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="734850da-8232-46de-b38a-b8bdd4735c0d"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d2}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="165" y="0" width="34" height="30" uuid="85f3b57f-3ad0-41b1-983b-be316b4e28ab">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2508252f-b980-42c7-8e1e-4d6ea072ea2f"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d3}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="199" y="0" width="34" height="30" uuid="250a2189-a060-404b-8bb9-3e358c4b2394">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b1f35301-b6f8-44be-ad27-4d127614ae27"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d4}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="233" y="0" width="34" height="30" uuid="d062d7a4-4927-4ce0-914f-14b7a07cca22">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3cef17f6-991f-4540-b271-cb2576690dab"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d5}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="267" y="0" width="34" height="30" uuid="e03829a6-e165-4d68-90b6-16da3d51da07">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9526b35a-8e3d-46f3-a56a-d9a2b0f4c4bc"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d6}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="301" y="0" width="34" height="30" uuid="5784a6d7-a297-4f04-ba0a-5f7492b50475">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb5620e4-87b2-4d41-ade0-7c93f6d035ce"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d7}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="335" y="0" width="34" height="30" uuid="45915f2d-29e2-4f23-8fe5-530c716fc140">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ba43a013-0c67-453f-9c61-795fb550c0d5"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d8}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="369" y="0" width="34" height="30" uuid="418b045d-352a-41ff-a606-721454cf2408">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e5f0138a-eb12-49b3-9893-27b45672c923"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d9}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="403" y="0" width="34" height="30" uuid="69b9483f-410d-4ec1-8a28-e0bbfd31d9d5">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="12b46166-6f36-4562-9b88-b5b2fb34b76b"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d10}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="437" y="0" width="34" height="30" uuid="bcd766ae-124c-40c5-bdb3-2d784a8a945e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7cc0187f-342f-4e3d-8700-4f166a897bfc"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d11}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="471" y="0" width="34" height="30" uuid="a203e12b-ef76-47f6-a000-746a71209c97">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="24bd1148-fd3c-4224-8300-bdf41b93da45"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d12}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="505" y="0" width="34" height="30" uuid="17b3dc48-7a8b-4d1f-84aa-01ead8cb48e0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="948c6190-71b1-465b-8b0f-d3a1d209ace8"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d13}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="539" y="0" width="34" height="30" uuid="71b56cab-4351-4680-8f09-8932a184eac9">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6e31c5e7-db46-46e8-bd1d-cbd0e4be55a9"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d14}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="573" y="0" width="34" height="30" uuid="ece12bfc-1e7b-4619-8714-1720b16aa83b">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86d2cd24-a334-4b77-8fc1-fe4e8f8b9116"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d15}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="607" y="0" width="34" height="30" uuid="0186348e-3959-476b-9f4d-28a1596df5d0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a943eed-1a4b-48dc-9969-3c853c28dc26"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d16}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="641" y="0" width="34" height="30" uuid="21bb516f-f1ff-4b6d-aaee-fcb34a9fd6a8">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5b0a3bfe-3ad8-4408-8f91-86cd173ac850"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d17}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="675" y="0" width="34" height="30" uuid="ef88aacd-5a04-4430-845a-8d217158005e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="340e8def-30ee-471e-86e5-feee78b1adf3"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d18}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="709" y="0" width="34" height="30" uuid="d5d1ddd2-39a0-4cea-9497-17101d0c1b6f">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5d912cd1-421e-4603-a29a-2f526a5ca90b"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d19}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="743" y="0" width="34" height="30" uuid="d2b54448-c1e2-4f2a-9b12-bb1998dd9eb3">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4e0c00ad-e418-4da0-a007-e88e58391f82"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d20}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="777" y="0" width="34" height="30" uuid="7d36e3d8-08a1-44fd-9073-7d3cf05b22eb">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8179b636-a9ef-43b0-bc1e-e8dad05e57e7"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d21}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="811" y="0" width="34" height="30" uuid="4d935d03-1350-420a-9e55-2a7f3f242868">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="baeddec3-6cc7-4f86-9280-5141cadefe55"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d22}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="845" y="0" width="34" height="30" uuid="f1398068-50a2-4726-899e-7c969094f3f6">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1101965a-0187-47ea-aaee-903c0c14e5a6"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d23}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="879" y="0" width="34" height="30" uuid="8d7b8adc-f904-4c11-8c86-3ca264a054c7">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c3e47755-a81c-472f-906f-5767c4bc9899"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d24}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="913" y="0" width="34" height="30" uuid="cec211b3-a678-40d3-b6aa-25fb6f7cdfb3">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="65504bb3-7755-4be7-992f-6a64f38ffb9c"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d25}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="947" y="0" width="34" height="30" uuid="e9d14b2a-9129-41d3-97de-96a613380ba2">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5ed4e460-2c83-4477-a408-3891c83f9d85"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d26}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="981" y="0" width="34" height="30" uuid="e63e25a0-9a10-41a1-be4e-9c9b250d23a6">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8dadd4e3-729d-4d83-9352-2ff4fee722c3"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d27}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="1015" y="0" width="34" height="30" uuid="3d7dec1e-b82a-4941-bd22-0a451e307dea">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a4f471f9-4c9c-4380-b761-c28784417eb0"/>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d28}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="1049" y="0" width="34" height="30" uuid="b84f0de3-7867-4b13-b911-a1b8fbe0ccce">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fa0350ff-a7c7-4d42-aee9-9589059a271a"/>
<printWhenExpression><![CDATA[$P{daysCount} >= 29]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d29}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="1083" y="0" width="34" height="30" uuid="d58c46e1-714d-4bc8-a587-df97d2ddd897">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="71320df5-ce3d-45de-ab77-6157f2df698f"/>
<printWhenExpression><![CDATA[$P{daysCount} >= 30]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d30}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="1117" y="0" width="34" height="30" uuid="6ea7d923-2e84-4d83-8301-3a6e07f5c7d0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="368871a9-5ea3-45d5-be29-61eb4591fed6"/>
<printWhenExpression><![CDATA[$P{daysCount} == 31]]></printWhenExpression>
</reportElement>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{d31}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment