devendra.616 Posted March 27, 2016 Posted March 27, 2016 I am using jasper ireprot v 5.6.0I have 3 tables with each grouped on category to display top 5 records of each category. The problem is when there is lesser no of records in a category or no records in the category, the allignment fails. I want every category band to be of same height ie 5 records.The current output snapshot that I am getting is
hozawa Posted March 27, 2016 Posted March 27, 2016 As of now, you'll have to add empty rows to your dataset to make it 5 rows. If you can program, you can add properties to fill rows like I did.http://community.jaspersoft.com/questions/976121/what-easiest-way-fill-empty-rows
devendra.616 Posted March 28, 2016 Author Posted March 28, 2016 @Hozawa I was not getting link to comment to your answer so am writing here. I did not get "FillTo" attribute in ireport , is it to be written via java program where the report jasper is being called ?Adding empty rows in the dataset is not easy as my dataset is composed of groups and want to display top 5 from each group. I tried adding empty data but in report I am using group band which categorise data on cat_code.(For empty row this will also be empty so all empty rows are going to seperate group in report)
Solution devendra.616 Posted April 2, 2016 Author Solution Posted April 2, 2016 I have done it in other way. Have modified the query and no of tables. Kept seperate table for each group category and have handled the no of rows to be fetched as 5 in each of the dataset query. This way will get fixed no of rows. Set "when no datatype" = all sections no details so that it shows header for the section but blank data. It occupies space and so alignment of data is maintained. here is now jrxml file <?xml version="1.0" encoding="UTF-8"?><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="highestInc" pageWidth="1080" pageHeight="905" orientation="Landscape" columnWidth="1040" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5a37eff7-9c16-489d-ace4-ec6bea566c8e"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="535"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 5_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 6_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 7_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 8_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 9"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 9_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 9_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 9_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 10"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 10_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 10_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 10_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 11"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 11_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 11_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 11_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 12"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 12_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 12_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 12_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 13"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 13_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 13_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 13_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 14"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 14_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 14_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 14_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 15"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 15_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 15_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 15_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 16"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 16_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 16_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 16_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 17"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 17_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 17_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 17_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 18"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 18_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 18_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 18_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 19"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 19_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 19_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 19_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 20"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 20_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 20_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 20_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="dumpDep14" uuid="8ae1c304-c7d2-4b04-b29f-c651fe4033af"> <parameter name="submonthyr" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{submonthyr} AND INDINC_REPHIS_T."DEP" = '14' AND INDINC_REPHIS_T."CAT" = 'D'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="dumpDep11C" uuid="a653422b-9306-4cc9-92b7-6bd197aed892"> <parameter name="submonthyr" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{submonthyr} AND INDINC_REPHIS_T."DEP" = '11C' AND INDINC_REPHIS_T."CAT" = 'D'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="dumpDep11B" uuid="ef88af1b-9247-4f3e-959b-98724bab8dbe"> <parameter name="submonthyr" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{submonthyr} AND INDINC_REPHIS_T."DEP" = '11B' AND INDINC_REPHIS_T."CAT" = 'D'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="shovDep14" uuid="c6cbe5ca-7e02-4e49-90d7-0719bf6cb634"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '14' AND INDINC_REPHIS_T."CAT" = 'S'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="shovDep11C" uuid="29acfbc0-4a5d-4f5f-922a-64f89b0c0745"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11C' AND INDINC_REPHIS_T."CAT" = 'S'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="shovDep11B" uuid="5242ad6e-9dd3-4b8c-adec-4f37b0076dd6"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11B' AND INDINC_REPHIS_T."CAT" = 'S'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="drillDep14" uuid="3cf691a7-a258-4117-9d95-2a39a4f641b2"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '14' AND INDINC_REPHIS_T."CAT" = 'R'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="drillDep11C" uuid="bfab9852-6192-48d9-8719-4be809edf5e2"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11C' AND INDINC_REPHIS_T."CAT" = 'R'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="drillDep11B" uuid="95d042e6-fc1c-4349-bc17-5db37f474f6a"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11B' AND INDINC_REPHIS_T."CAT" = 'R'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="felDep14" uuid="9964a3e2-29ae-4e1e-8568-91b9d671984d"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '14' AND INDINC_REPHIS_T."CAT" = 'F'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="felDep11C" uuid="af6e90a5-8eb7-4bd9-bc8f-b40db1e1af00"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11C' AND INDINC_REPHIS_T."CAT" = 'F'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="felDep11B" uuid="d0e83f4b-828d-4c64-878e-1ef3ee85b7bd"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11B' AND INDINC_REPHIS_T."CAT" = 'F'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="thdDep14" uuid="185754ea-85bf-42ed-841f-39ea4d9f0d95"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '14' AND INDINC_REPHIS_T."CAT" = 'G'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="thdDep11C" uuid="796f7f0b-6971-424a-8707-57bf27e3aef8"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11C' AND INDINC_REPHIS_T."CAT" = 'G'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <subDataset name="thdDep11B" uuid="72a448e2-13d5-47ca-b236-32aec3ae6389"> <parameter name="subMonthYr" class="java.lang.String"/> <queryString> <![CDATA[select * from (SELECT INDINC_REPHIS_T."TOKEN" AS TOKEN, INDINC_REPHIS_T."NAME" AS NAME, amt , round(TRIPS/SHIFT,2) AS AVG_TRIPSFROM "INCPKG"."INDINC_REPHIS_T" INDINC_REPHIS_T INNER JOIN "INCPKG"."DEP_M" DEP_M ON (INDINC_REPHIS_T."DEP" = DEP_M."DEP_CODE") INNER JOIN "INCPKG"."CAT_M" CAT_M ON (INDINC_REPHIS_T."CAT" = CAT_M."CAT_CODE")WHERE INDINC_REPHIS_T."MONTH_YR" = $P{subMonthYr} AND INDINC_REPHIS_T."DEP" = '11B' AND INDINC_REPHIS_T."CAT" = 'G'GROUP BY dep,CAT,TOKEN,NAME,TRIPS,SHIFT,DEP_NAME,CAT_NAME,amtorder by amt desc) where rownum <=5]]> </queryString> <field name="TOKEN" class="java.lang.String"/> <field name="NAME" class="java.lang.String"/> <field name="AMT" class="java.math.BigDecimal"/> <field name="AVG_TRIPS" class="java.math.BigDecimal"/> </subDataset> <parameter name="monthyr" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="year" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select 1 from dual]]> </queryString> <field name="1" class="java.math.BigDecimal"/> <title> <band height="50" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="227" height="20" uuid="aa76bc22-f17d-4553-b3b7-5a2b1fe90b1a"/> <text><![CDATA[NMDC Ltd, BIOM KIRANDUAL COMPLEX]]></text> </staticText> <staticText> <reportElement x="5" y="25" width="1020" height="20" forecolor="#3333FF" uuid="46685c90-6f5e-4890-893c-8f4fa46dcc1b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[HIGHEST INCENTIVE REPORT FOR MONTH ]]></text> </staticText> </band> </title> <pageHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="5" y="0" width="176" height="20" uuid="73c124b0-2fc7-439f-ba50-8f32645a861a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[DEPOSIT 14]]></text> </staticText> <staticText> <reportElement x="367" y="0" width="176" height="20" uuid="0dd83c7a-d25b-40b4-92ad-3fd2c76131d6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[DEPOSIT 11C]]></text> </staticText> <staticText> <reportElement x="715" y="0" width="176" height="20" uuid="f37e542c-412d-47ec-8eb8-7675c9e778d5"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[DEPOSIT 11B]]></text> </staticText> </band> </pageHeader> <detail> <band height="795" splitType="Stretch"> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="0" y="20" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="b8dd79db-ea3f-4ba2-a833-89d940682f95"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="dumpDep14" uuid="f1ba2c48-9cd9-4357-842e-70f0d4b0227d"> <datasetParameter name="submonthyr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="74cfd696-9d30-498e-a9d0-bb9fbe787f54"> <jr:columnHeader style="table 2_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="e4e453a2-d61a-4e15-ad3a-06fd33170003"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 2_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" uuid="fe289b9e-a418-45ca-9675-fefc6bc89e0c"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="04aa4c7e-b4c2-4932-b08c-d2b682ca7279"> <jr:columnHeader style="table 2_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="3cf24401-c2e7-4a5f-a536-c690da31cc30"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 2_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="180" height="20" uuid="cb29024c-a180-43cf-afa7-341ee1484507"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="65c0114a-28e6-4a8c-8c5d-5211cf2924eb"> <jr:columnHeader style="table 2_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="74890463-9567-4f13-8017-28a09b232a1a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 2_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" uuid="32a7be67-cdae-4fb2-b92a-4c7845909935"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="083c8962-e06a-40e8-8509-c2e58e2724b0"> <jr:columnHeader style="table 2_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="892e9b98-cbae-4f60-9758-f5279e33129f"/> <box rightPadding="0"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS ]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 2_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="55" height="20" uuid="4e5a32b3-328b-48d6-9d39-9f917d362d19"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="355" y="20" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="4d877122-7727-4688-8450-e8fd8a06170d"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="dumpDep11C" uuid="fde6034f-0319-45b4-9570-b19fff907378"> <datasetParameter name="submonthyr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="726ede6b-72f9-48cd-bf82-1c67728ae3a1"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="13423e18-eb5f-4070-8f7d-5f4503692af6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="57e5d05f-f5e4-47ce-93db-da935a44c33a"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="0fcd4913-4702-4638-8004-d7914fbe0795"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="32bd625a-d22f-42a2-9fd6-953c94f24d29"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="180" height="20" isPrintWhenDetailOverflows="true" uuid="a42e109b-1495-4546-88be-eda0a9a89452"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="f4e28b88-dbc2-4bee-ac0c-36ec4e83671a"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="df7a20b5-790b-494e-93ad-5b1b1480425e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="d1b3f017-4fb0-4a5c-84de-a643ca4c4c03"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="945e6c0c-b591-4549-9439-818823dfcba8"> <jr:columnHeader style="table 3_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="db718d76-d89d-4b2d-8ba5-5a5a3622f9b2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 3_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true" uuid="55630e53-c02e-480d-af72-14bed08c5ac8"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="715" y="20" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="3f32626a-03ff-44ae-be02-17b895be9fd6"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="dumpDep11B" uuid="36de05a2-f499-4fd8-93de-c4fc14038d46"> <datasetParameter name="submonthyr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="6c0040ad-94b9-40f6-90b5-a2682b325a95"> <jr:columnHeader style="table 4_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="4d356223-17c2-4a05-b0b6-eb23c58ad50e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 4_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="8f9db8c9-2cd9-4dca-a8f4-2aa65207f939"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="8643a6af-8253-4c44-90d4-1ca0f16c0866"> <jr:columnHeader style="table 4_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="cb53afc9-f176-498b-a522-879f2dcb25cd"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 4_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="180" height="20" isPrintWhenDetailOverflows="true" uuid="c99ad09e-381e-41ea-b97c-cbe1bbe239fc"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="2fe3a01e-145e-46f5-b95e-bba3f4885005"> <jr:columnHeader style="table 4_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="46cdc3fc-9c88-4bb1-ba3e-6d61116afcfb"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 4_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="8cd5776d-172a-4b56-b2e4-946de25036c2"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="e92de977-985e-48b6-9699-c5cdb98f67d1"> <jr:columnHeader style="table 4_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="22dd0fc2-6590-401b-9a7a-0fcda120def6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 4_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true" uuid="4ff01190-37fb-4c63-a5d2-978521badc0f"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="0" y="175" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="7a75c157-b106-4d5e-ab6f-c3d1cda4e891"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="shovDep14" uuid="3576ffdb-66e2-43b1-9e13-086d6e649b46"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="4abefb0c-5b02-4625-ab80-00b4c4f09110"> <jr:columnHeader style="table 5_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="10bec618-f52a-4297-b6cb-c706e0ad11b9"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 5_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="54dda228-e37d-4dec-975d-3ae4de49c4e0"/> <box leftPadding="5" rightPadding="5"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="d5ecf3b0-b796-4fba-8a98-115cbc23e836"> <jr:columnHeader style="table 5_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="09bcde6c-6869-468a-8eab-d174edf0c59b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 5_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="180" height="20" isPrintWhenDetailOverflows="true" uuid="a5bc9ce4-e0be-415d-a444-cb186ceeb836"/> <box leftPadding="5" rightPadding="5"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="7e53326b-ab04-40d0-bf55-642a1aa3d6de"> <jr:columnHeader style="table 5_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="b3fbf4e8-e439-45fe-a225-c2babecdc675"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 5_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="ea4abe7e-4335-4cbc-b54c-b60debd6a553"/> <box leftPadding="5" rightPadding="5"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="e727412c-bf14-480e-9862-17949aebc551"> <jr:columnHeader style="table 5_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="1a70291c-faa5-4005-ad81-3918d28c4236"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 5_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true" uuid="e2821cca-3a77-4057-829d-6f095c48f244"/> <box leftPadding="5" rightPadding="5"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="355" y="175" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="4dd45382-3817-46d2-be59-010056afa6fe"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="shovDep11C" uuid="48452f03-d65d-45c3-a82b-86b5b74db1fa"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="e7d00d33-1d03-4ec9-8a9f-02032f815010"> <jr:columnHeader style="table 6_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="e8b30f90-3757-4579-8c07-04c7d5030baa"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 6_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="44b023fa-b114-4f6f-8e07-6b009ea46bd6"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="d07f5143-562b-4b9c-91ba-db80d201e1f8"> <jr:columnHeader style="table 6_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="99dd0ee6-a72b-4120-a389-ccc737cf065e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPARATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 6_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="180" height="20" isPrintWhenDetailOverflows="true" uuid="4cd25c28-2b39-4998-8fa8-df4fb9f5e7ba"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="f6b094c4-22eb-4a60-8a5a-9fe40e1c1336"> <jr:columnHeader style="table 6_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="a0d90f64-03c0-4f1e-bffe-be6723ba99be"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT ]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 6_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="3c121f4c-cfb5-4d47-8bf8-2e81e6b44890"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="d03effad-db65-439e-bc48-c19e252e8b89"> <jr:columnHeader style="table 6_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="947c5d73-1075-4eab-a025-cf0692107e16"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 6_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true" uuid="3bea06b0-02ef-4c52-99d9-7226c005a140"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="" stretchType="RelativeToTallestObject" x="710" y="175" width="325" height="130" isPrintWhenDetailOverflows="true" uuid="c6144f7d-6e56-44f0-92a2-274878d481dc"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="shovDep11B" uuid="a6052acd-ffde-469e-83b4-67c56ac909bc"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="cfd436eb-7232-45b7-b574-704d5114711e"> <jr:columnHeader style="table 7_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="f6193518-c25e-4da0-bea0-dda68923d3e8"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 7_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="455c344f-344a-4538-9873-0a1775670034"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="4128cf7c-ad8f-4785-a2b1-8eaf86e3c701"> <jr:columnHeader style="table 7_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="92c58442-af86-4ca5-beb1-b0ae9cf0557b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 7_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="180" height="20" isPrintWhenDetailOverflows="true" uuid="c6950cc7-699d-4a31-8aa7-a34f8160c1ba"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="7592dac5-47c1-4dac-bec0-a57a25ed70a4"> <jr:columnHeader style="table 7_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="7704bc96-6f65-4353-b03f-c25e2e69f591"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 7_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="45" height="20" isPrintWhenDetailOverflows="true" uuid="60b991cc-5dbe-4e9a-89b7-aae3b4a51cc7"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="530a244c-867e-45c7-8330-7aa3170570a0"> <jr:columnHeader style="table 7_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="5ca92105-7546-4b92-ad17-a5bba8d785bc"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 7_TD" height="20" rowSpan="1"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement mode="Opaque" x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true" uuid="23cbd442-0d7e-4e3b-8c7b-e2e4ab8f1ce9"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 10" style="table 10" x="0" y="330" width="325" height="130" uuid="53513c4f-b04f-4292-aa27-353fb93d6d2a"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="drillDep14" uuid="adf8ba58-8f52-424e-9f57-f21ad5bef4ba"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="aab0f426-854a-4eb1-9f19-ff0186b0b31b"> <jr:columnHeader style="table 10_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="32654765-4184-4680-add6-363b96cfc0df"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 10_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="bc9d4363-a840-4843-a0b6-8a217d82dfd8"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="501f7bdf-c2cb-4531-9ca7-3476083e73b8"> <jr:columnHeader style="table 10_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="6b4c9e0f-2b15-47ae-b3fa-214942c4a335"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 10_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="b52f3c0f-b41a-4807-a757-5f043a3267ed"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="4d002fe8-a665-414f-8171-e5139852df16"> <jr:columnHeader style="table 10_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="19f9c6c9-2aee-4cec-b87e-030bb42f48ba"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 10_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="130228e7-cddf-4bcc-b2e8-a3052a27a0df"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="0e46f2ed-ef2b-4f80-92ed-262663af8248"> <jr:columnHeader style="table 10_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="0ad27240-22dd-49a7-8470-d38fd26b9894"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 10_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="b62badd4-45d2-48cb-b9dd-f93a5bf8193b"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 11" style="table 11" x="355" y="330" width="325" height="130" uuid="345ea073-ae28-438b-a910-3846cec2dec0"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="drillDep11C" uuid="f198e18b-f3e7-441d-9207-705c5b48061d"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="b2afb983-0cd8-4c6e-9c2e-987c9d87c8a7"> <jr:columnHeader style="table 11_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="0ed2f9b3-e026-4a6a-9993-257fec7d5dfd"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 11_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="e4301ca1-85bd-4921-b8b5-4f5749473b22"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="a4a630ec-3be6-4592-96f0-2be515f50f59"> <jr:columnHeader style="table 11_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="7d7634c3-8ba1-4970-b109-bb78b2e71283"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 11_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="90026f9d-8dbe-4a1a-aa4a-5fb47d3d22ee"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="c15ab191-6920-42bf-806a-e5aa671631f3"> <jr:columnHeader style="table 11_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="a8d9fd82-3e0f-4b28-b7e7-d1fa9089f533"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 11_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="e76b3860-5edf-4698-852f-b8f973919312"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="90f66abf-03f8-45a9-9010-62f13b045da5"> <jr:columnHeader style="table 11_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="921d6d94-8c06-40b6-b216-ed40d60974a3"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 11_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="d4c6f2eb-a3fe-4a68-be39-6143250d2d27"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 12" style="table 12" x="710" y="330" width="325" height="130" uuid="d1ce73f2-716a-4be0-a796-3d2b3fa626b7"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="drillDep11B" uuid="fc0d63e9-37c3-4e87-bfc7-ac171544be26"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="e2a759f6-55a1-4404-965a-6e56063fbd6a"> <jr:columnHeader style="table 12_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="ca9241bd-f9ac-4c7a-a822-036a403890ed"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 12_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="5cec801f-92d1-43c9-a181-af57f37b18d5"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="740d2197-bb7c-47c7-be2c-67035945d99b"> <jr:columnHeader style="table 12_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="90" height="30" uuid="108a811a-3fdd-4cb9-bc4f-52a94abacaf1"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 12_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="deebbae5-0aa8-4c7a-b482-90557f81a66f"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="b7cc4389-54f9-4c93-847d-377430fe950b"> <jr:columnHeader style="table 12_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="a5ca0708-2ad6-4b6d-a306-91c047ddeb50"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 12_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="da14f165-4633-45ec-b068-5e1d3b1d448b"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="d741bd8c-c6d0-4628-b5c7-b608ac366bb4"> <jr:columnHeader style="table 12_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="7253b30b-d629-406e-8db9-7e3d0867547a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 12_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="14962df5-b623-4185-9504-0572130cc8f1"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 13" style="table 13" x="0" y="485" width="325" height="130" uuid="715ffa16-e771-44d1-8334-12c466bb1b1c"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="felDep14" uuid="782754c5-71be-4ecc-9467-d4a7dda64f82"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="46252924-69ca-4056-a61d-0c08733e17e6"> <jr:columnHeader style="table 13_CH" height="32" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="5746e07f-b87d-4c76-85cb-8bfde2073912"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="false"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 13_TD" height="21" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="c1929e92-1725-4d8b-bde5-0420154d408f"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="3200e55b-9649-4a65-8e98-c85438bbf1ac"> <jr:columnHeader style="table 13_CH" height="32" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="26ce5786-a286-49c8-b40c-341f62a55549"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="false"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 13_TD" height="21" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="142797c4-6b1f-44f4-837d-646b10a65307"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="771e430e-1744-4ca6-9ee6-5b8c8f7b733e"> <jr:columnHeader style="table 13_CH" height="32" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="be68303c-72d9-4aa5-b986-44346d84740a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="false"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 13_TD" height="21" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="eae5697c-156a-4629-a000-065925d81c4c"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="e1dd81f3-ba1f-43f6-ab99-73c05d7042f8"> <jr:columnHeader style="table 13_CH" height="32" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="c599563c-0b62-4739-ba52-06830e70e5a0"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="false"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 13_TD" height="21" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="340cf3cc-a5aa-4b23-87c9-a55e0c9fb386"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 16" style="table 16" x="355" y="485" width="325" height="130" uuid="46ac7db6-e37b-4852-8b41-3c0bb121e6f7"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="felDep11C" uuid="47e5920c-5ac6-4560-855f-b4936205a674"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="17ffa1be-7e5a-4e84-8f40-6243e0085fd2"> <jr:columnHeader style="table 16_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="2a63d498-3f04-477d-b50d-f7c13c7ab6ec"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 16_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="a28e847f-d990-4b38-a698-90f2f9e0fb12"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="de6eabf4-d5a7-44c2-969f-60c2a59a1240"> <jr:columnHeader style="table 16_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="78de59be-54bd-4c14-8d71-b550ac648b6e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 16_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="a3a65d38-760a-42a1-aadb-f8315c03e603"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="a5fec4d7-3f23-4d0e-ab47-225d717d84ab"> <jr:columnHeader style="table 16_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="26c789e4-babb-4765-971e-91fd81bf1c78"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 16_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="4318f1e7-5edd-4907-848a-7138946e8b1e"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="08589840-8d5d-4261-8bbe-2cbab0884b87"> <jr:columnHeader style="table 16_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="7de3b311-2924-484f-9074-39a5bfdd8349"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 16_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="d42c89d6-504b-4486-a5f0-2af1e0750ffe"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 17" style="table 17" x="710" y="485" width="325" height="130" uuid="bb344ef8-42b3-46d4-8004-62704f5c2dfe"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="felDep11B" uuid="19848f5c-a08d-49fc-803c-c944f51ebaab"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="8502c908-5854-4d10-9f1b-a06385bf9143"> <jr:columnHeader style="table 17_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="60b3e62b-2281-48bb-8774-1f8ed85c0a8b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 17_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="782f6b47-869d-4aeb-bd30-367b83160e63"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="0fa4a357-dca5-45b7-87e2-0832a9cccd37"> <jr:columnHeader style="table 17_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="26eec904-3f60-4e56-adfd-e15385987717"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 17_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="af170261-fe00-4d0b-ab35-985d7303b760"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="207d655c-8484-4925-bc97-91f30ded094a"> <jr:columnHeader style="table 17_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="51bb176a-0ed9-4469-b094-0d52fa95c56a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 17_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="9ed4ffac-c34b-4014-95c3-0a180f8a5582"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="d37258fd-b6f0-4543-987a-20dc953384ec"> <jr:columnHeader style="table 17_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="f404eaa7-ceca-4462-9231-f9a599210238"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 17_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="76e4d47b-5dc0-4089-b811-2ea16fdd8a0c"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 18" style="table 18" x="5" y="640" width="325" height="130" uuid="65671131-e117-4274-beab-2d99a078a8b2"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="thdDep14" uuid="a4bb4189-4e53-4c4c-93ae-225a1d979ef0"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="55a1be87-7d12-41f1-93f7-93ff1951aa9e"> <jr:columnHeader style="table 18_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="7e95965a-3b9f-4610-b682-702653cd779b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 18_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="b32d39fc-4b99-4d43-b1b0-b908e75fbed1"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="1161f4ea-db19-4d91-98b8-0f4bcb9a81c8"> <jr:columnHeader style="table 18_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="a5a882c8-9d6e-4a32-a91a-3ef7b50e0968"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 18_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="b0a322fc-e489-4434-bf7c-7efc32d7b547"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="9d52d2a1-47b0-4352-8019-2e84f09332f2"> <jr:columnHeader style="table 18_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="ca4e1f1a-831b-4cb0-86d9-4b60e33f76a2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 18_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="7a3b2fc5-f69e-455b-9cca-ebc4832808bd"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="a7f65889-8cc9-4800-b042-0c00c9e7584a"> <jr:columnHeader style="table 18_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="746d9066-806e-4b41-8562-6c4e9a7c6706"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 18_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="5e38b5da-1723-4d4d-8490-c6142bed8d08"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 19" style="table 19" x="355" y="640" width="325" height="130" uuid="1b555e3b-2816-495a-b19c-18812ada2525"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="thdDep11C" uuid="904cbdca-4025-4a66-9377-f33755021c11"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="68cac11e-fc03-43c0-9a3a-f411dd761701"> <jr:columnHeader style="table 19_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="d8c6ebfd-4ca4-4aed-a2c6-1bb552afdf23"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 19_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="2ddc641a-9d1c-480e-94cd-82495a21f4ef"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="2e99ab54-eaae-4125-81a5-cecc30229604"> <jr:columnHeader style="table 19_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="111de579-5c2f-4750-b849-8cf96bcd5895"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 19_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="02b68427-0de9-40df-9a41-34903558787f"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="5ad9265a-55c9-4c51-8b71-658d7a7fbbe8"> <jr:columnHeader style="table 19_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="dbf3c32d-8272-466b-9a4e-3c8fb92b31a4"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 19_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="6eabfd99-59cd-4880-867e-fadbd43c480a"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="2a8c1cae-cbcd-40e1-a704-6c6afc82bfd5"> <jr:columnHeader style="table 19_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="bcb05390-0d5e-43a4-ad56-a24f57a5d716"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 19_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="300c3df5-bc94-4c21-814b-63f7475c5547"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement key="table 20" style="table 20" x="710" y="640" width="325" height="130" uuid="c1a5cedc-2a84-426a-94fa-d97247a914fb"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="thdDep11B" uuid="4cd937c5-f162-443a-b07b-456e02e5f025"> <datasetParameter name="subMonthYr"> <datasetParameterExpression><![CDATA[$P{monthyr}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="45" uuid="ec0df963-7c46-46e2-bfbc-dffe2ab4152f"> <jr:columnHeader style="table 20_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="ea26ca66-1e94-46a5-bc1f-a659fb2a20f6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[TOKEN]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 20_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="c07ca5c3-e886-472f-b625-23abf8ec46b2"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TOKEN}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="180" uuid="7dace136-7bec-4c4b-9421-48e56ab8f18e"> <jr:columnHeader style="table 20_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="9ad7d4b5-f28b-43f9-8678-7766617633b2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[OPERATOR NAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 20_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="180" height="20" uuid="bc9638a5-36a0-4764-aeeb-2b901f02ae8f"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="45" uuid="19ac4842-f634-4493-8acf-ab424b4c5c43"> <jr:columnHeader style="table 20_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="45" height="30" uuid="70ad6c41-c210-4119-abc7-eedf3dafbce5"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 20_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="45" height="20" uuid="c8215be9-e4ce-42f7-a53f-19e86ed0f3f0"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="55" uuid="cd927cae-d200-4c07-bd21-5efe4743994f"> <jr:columnHeader style="table 20_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="55" height="30" uuid="3f8092ab-7ef9-4621-8b5e-72259e4ca34c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[AVERAGE TRIPS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="table 20_TD" height="20" rowSpan="1"> <textField> <reportElement x="0" y="0" width="55" height="20" uuid="9923dedc-5853-4eb4-a4e0-8d6e53b356d3"/> <box leftPadding="5" rightPadding="5"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{AVG_TRIPS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <staticText> <reportElement mode="Opaque" x="5" y="0" width="120" height="20" forecolor="#009999" uuid="b91b15c1-63a7-4a9e-a9f4-327e7d74f507"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font size="10" isBold="true"/> </textElement> <text><![CDATA[DUMPER OPERATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="5" y="155" width="120" height="20" forecolor="#009999" uuid="07d1ae4e-40eb-4d05-85fc-fd80bc849eff"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[sHOVEL OPERATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="310" width="120" height="20" forecolor="#009999" uuid="ff2bb8f9-d847-4222-a9c1-28323c43bb7e"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[DRILL OPERATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="5" y="465" width="120" height="20" forecolor="#009999" uuid="052a403d-72a6-42cc-842e-30287967ddf2"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[FEL OPERATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="5" y="620" width="120" height="20" forecolor="#009999" uuid="ccde662a-0ea4-4512-871b-d5926f6fcf9e"/> <textElement textAlignment="Justified" verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[THD OPERATOR]]></text> </staticText> <line> <reportElement x="0" y="154" width="1040" height="1" uuid="33cf407a-fc7b-4504-acfb-0aad1e3a0c3e"/> <graphicElement> <pen lineStyle="Dashed"/> </graphicElement> </line> <line> <reportElement x="0" y="309" width="1040" height="1" uuid="79b77117-fae7-4c76-8d15-bb07e0932899"/> <graphicElement> <pen lineStyle="Dashed"/> </graphicElement> </line> <line> <reportElement x="0" y="464" width="1040" height="1" uuid="3888b469-a72b-4c79-bb69-9ae62d676a92"/> <graphicElement> <pen lineStyle="Dashed"/> </graphicElement> </line> <line> <reportElement x="0" y="619" width="1040" height="1" uuid="05d94dbb-cd39-412b-8f6f-5fe85695bae9"/> <graphicElement> <pen lineStyle="Dashed"/> </graphicElement> </line> <line> <reportElement x="0" y="778" width="1040" height="1" uuid="b47c4fb5-e42f-4a8d-9f99-25612925ee04"/> <graphicElement> <pen lineStyle="Dashed"/> </graphicElement> </line> </band> </detail></jasperReport>[/code]
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now