-
-
Save netslow/500d503a6bb9314f28604a78cd9b773e to your computer and use it in GitHub Desktop.
Forks and spoons with fixed layout
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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