abalakrishnan95

Barchart not combining categories to single chart

abalakrishnan95 posted a topic in Products

This is a follow-up to a previous question I asked here https://stackoverflow.com/questions/51968001/bar-chart-not-showing-all-categories-jaspersoft-studio and here https://stackoverflow.com/questions/51900998/jasper-creating-a-bar-chart-for-each-series-variable Update: 10:06 AM 08/30/2018, I have added an update here https://stackoverflow.com/questions/52084723/jaspersoft-barchart-seperating-charts-by-category?noredirect=1&lq=1 I am at the point where I am able to see all the series on the same chart but now it is creating a chart for each quarter per title. However it should be creating a chart per title with all four quarters in the categories section The data coming back from the query looks like this +-----+---------+-----------+-----------+----------+------------+ | qtr | url_txt | pub_page | itm_page | cms_page | gst_page | +-----+---------+-----------+-----------+----------+------------+ | Q1 | url1 | 123 | 5 | 1 | 0 | | Q1 | url2 | 10 | 8 | 10 | 12 | | Q2 | url1 | 129 | 20 | 39 | 1 | | Q3 | url2 | 129 | 128 | 371 | 83 | +-----+---------+-----------+-----------+----------+------------+ The JRXML is as so <?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="DEL_sys_usg_rpt_bar" pageWidth="792" pageHeight="576" whenNoDataType="AllSectionsNoDetail" columnWidth="536" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" uuid="c90df0e9-ca70-4aa8-88ab-3cc66cad2ade"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.unit." value="inch"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="false"/> <subDataset name="Dataset1" uuid="7d5280b5-f2f1-4d32-9729-2bb222a23169"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <queryString><![CDATA[]]></queryString> </subDataset> <parameter name="START_DATE" class="java.util.Date"/> <parameter name="END_DATE" class="java.util.Date"/> <parameter name="START_DATE_RPT" class="java.lang.String"/> <parameter name="END_DATE_RPT" class="java.lang.String"/> <parameter name="SCREENS" class="java.util.Collection"/> <parameter name="Q1START" class="java.util.Date"/> <parameter name="Q1END" class="java.util.Date"/> <parameter name="Q2START" class="java.util.Date"/> <parameter name="Q2END" class="java.util.Date"/> <parameter name="Q3START" class="java.util.Date"/> <parameter name="Q3END" class="java.util.Date"/> <parameter name="Q4START" class="java.util.Date"/> <parameter name="Q4END" class="java.util.Date"/> <queryString> <![CDATA[select * from ( SELECT t.qtr, t.url_txt as url_txt, sum(t.pub) as pub_page, sum(t.itm) as itm_page, sum(t.gst) as gst_page, sum(t.lib) as lib_page from ( SELECT 'Q1' as qtr, url_txt, CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm, CASE when user_role_txt = 'Public' then 1 else 0 end as pub, CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib, CASE when user_role_txt = 'GST' then 1 else 0 end as gst from del_sys.sys_usg where acs_ts::date >= $P{Q1START} AND acs_ts::date <= $P{Q1END} AND $X{IN,url_txt,SCREENS} UNION ALL SELECT 'Q2' as qtr, url_txt, CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm, CASE when user_role_txt = 'Public' then 1 else 0 end as pub, CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib, CASE when user_role_txt = 'GST' then 1 else 0 end as gst from del_sys.sys_usg where acs_ts::date >= $P{Q2START} AND acs_ts::date <= $P{Q2END} AND $X{IN,url_txt,SCREENS} UNION ALL SELECT 'Q3' as qtr, url_txt, CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm CASE when user_role_txt = 'Public' then 1 else 0 end as pub, CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib, CASE when user_role_txt = 'GST' then 1 else 0 end as gst from del_sys.sys_usg where acs_ts::date >= $P{Q3START} AND acs_ts::date <= $P{Q3END} AND $X{IN,url_txt,SCREENS} UNION ALL SELECT 'Q4' as qtr, url_txt, CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm, CASE when user_role_txt = 'Public' then 1 else 0 end as pub, CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib, CASE when user_role_txt = 'GST' then 1 else 0 end as gst from del_sys.sys_usg where acs_ts::date >= $P{Q4START} AND acs_ts::date <= $P{Q4END} AND $X{IN,url_txt,SCREENS} ) as t group by t.qtr, t.url_txt ) as f]]> </queryString> <field name="url_txt" class="java.lang.String"/> <field name="qtr" class="java.lang.String"/> <field name="itm_page" class="java.lang.Integer"/> <field name="gst_page" class="java.lang.Integer"/> <field name="pub_page" class="java.lang.Integer"/> <field name="lib_page" class="java.lang.Integer"/> <sortField name="qtr"/> <group name="Group1" keepTogether="true"> <groupExpression> <![CDATA[$F{url_txt}]]> </groupExpression> </group> <pageHeader> <band height="98" splitType="Stretch"> <staticText> <reportElement key="t_4" mode="Opaque" x="130" y="-1" width="320" height="15" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF" uuid="70d07b08-a98f-462f-912c-86e8ca3cffa5"> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DEL Report]]></text> </staticText> <textField pattern="([GENERAL])" isBlankWhenNull="true"> <reportElement key="COMPUTE_5" mode="Opaque" x="140" y="15" width="300" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="fa243ebd-82b3-426a-8693-995a1d029d8c"> <property name="net.sf.jasperreports.export.pdf.tag.h2"/> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Data Element Library Usage Report"]]> </textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="DATE_1" mode="Opaque" x="430" y="0" width="102" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="8c30e5fd-4921-4b61-a07d-fec225f73dca"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="full"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Run Date: " + new SimpleDateFormat("MM/dd/yyyy").format(new Date())]]> </textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Opaque" x="430" y="12" width="40" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="d3278171-f2e1-4241-b57f-5e4f3fc2ee09"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="start"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]> </textFieldExpression> </textField> <textField evaluationTime="Report" pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Transparent" x="470" y="12" width="30" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="f12aa9ee-4dbb-4569-bad4-1994dcfc045c"> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="end"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA[$V{PAGE_NUMBER}]]> </textFieldExpression> </textField> <staticText> <reportElement x="0" y="70" width="280" height="12" uuid="9f93ebb5-6ca9-4f7f-be7c-d06093207859"> <property name="net.sf.jasperreports.export.pdf.tag.h3" value="start"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement verticalAlignment="Top"> </textElement> <text><![CDATA[Note: * indicates an empty value.]]></text> </staticText> <textField> <reportElement x="140" y="30" width="300" height="20" uuid="c2b0287c-ce1e-461c-aabb-1c6e28b0b30d"/> <textElement textAlignment="Center"/> <textFieldExpression> <![CDATA["From "+$P{START_DATE_RPT}+" to "+$P{END_DATE_RPT}]]> </textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="285"> <barChart> <chart isShowLegend="true"> <reportElement key="" x="-20" y="40" width="760" height="245" isPrintWhenDetailOverflows="true" uuid="3d590b3c-9ccb-4a25-a7a7-cf8bd486947a"> <property name="com.jaspersoft.studio.unit.y" value="inch"/> </reportElement> <chartTitle position="Top"> <titleExpression> <![CDATA[$F{url_txt}]]> </titleExpression> </chartTitle> <chartSubtitle/> <chartLegend position="Right"/> </chart> <categoryDataset> <dataset resetType="Page"/> <categorySeries> <seriesExpression><![CDATA["Public"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{pub_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["GST"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{gst_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Librarian"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{lib_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Item Developers"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{itm_page}]]></valueExpression> </categorySeries> </categoryDataset> <barPlot> <plot backgroundAlpha="1.0"> <seriesColor seriesOrder="0" color="#BD0009"/> <seriesColor seriesOrder="1" color="#90F000"/> <seriesColor seriesOrder="2" color="#204182"/> <seriesColor seriesOrder="3" color="#8F6900"/> <seriesColor seriesOrder="4" color="#C8EE8A"/> </plot> <itemLabel/> <categoryAxisLabelExpression> <![CDATA["Quarter"]]> </categoryAxisLabelExpression> <categoryAxisFormat> <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/> </categoryAxisFormat> <valueAxisLabelExpression> <![CDATA["Page Count"]]> </valueAxisLabelExpression> <valueAxisFormat> <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/> </valueAxisFormat> </barPlot> </barChart> </band> <band height="34"/> </detail> </jasperReport>[/code] It should show all quarters on the bottom with the series and it appropriate value for each quarter for the url title. each chart would be a separate url title. I believe it is because it is going row by row and creating a chart based on that but I am stumped on how to fix it. Here is how it currently is showing

August 30, 2018
- sql
- formatting
- (and 1 more)
  Tagged with:

Bar graph not reporting correct data

abalakrishnan95 posted a topic in Products

Hello, I am fairly new to creating charts in jasper but i'm at my wits end with this issue. I have a data set that is returning proper data that is set up like so qtrurl_txtuser_role_txtpage_cntQuarter 1some url1some role1154Quarter 1some url2some role211Quarter 2some url1some role212Quarter 3some url2some role1110But every iteration I have tried has failed so I tried another way to get this table qtrqtrurl_txturl_txtuser_role_txtrole1_pagerolerole2_pageQuarter 1qtr 1some url 1some url1some role115415411Quarter 1qtr 2some url2some url1001112Quarter 2qtr 1some url1some url2some role201211Quarter 3 qtr3some url2some url2some role111011012 something similar and this got closer with getting the correct numbers but not the right quarters showing on the chart Here is how it was Here is how it is now In both instances, only 2 quarters tend to show up no matter the date range I choose (bottom one is one month off from the first picture) it is usally quarter 1 and quarter 4 but there is obviously data in quarter 2 and 3 from when I run the query in the sql. Here is the jrxml of the latest version Any help would be amazing <?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="usg_rpt_bar" pageWidth="576" pageHeight="792" whenNoDataType="AllSectionsNoDetail" columnWidth="536" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" uuid="c90df0e9-ca70-4aa8-88ab-3cc66cad2ade"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.unit." value="inch"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="false"/> <subDataset name="Dataset1" uuid="7d5280b5-f2f1-4d32-9729-2bb222a23169"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <queryString> <![CDATA[]]> </queryString> </subDataset> <parameter name="START_DATE" class="java.util.Date"/> <parameter name="END_DATE" class="java.util.Date"/> <parameter name="START_DATE_RPT" class="java.lang.String"/> <parameter name="END_DATE_RPT" class="java.lang.String"/> <parameter name="SCREENS" class="java.util.Collection"/> <parameter name="Q1START" class="java.util.Date"/> <parameter name="Q1END" class="java.util.Date"/> <parameter name="Q2START" class="java.util.Date"/> <parameter name="Q2END" class="java.util.Date"/> <parameter name="Q3START" class="java.util.Date"/> <parameter name="Q3END" class="java.util.Date"/> <parameter name="Q4START" class="java.util.Date"/> <parameter name="Q4END" class="java.util.Date"/> <queryString> <![CDATA[sELECT DISTINCT ON (url_txt)t.qtr as qtr,t.url_txt as url_txt,sum(t.pub) as pub_page,sum(t.itm) as itm_page,sum(t.cms) as cms_page,sum(t.gst) as gst_page,sum(t.lib) as lib_pagefrom(SELECT'Quarter 1' as qtr,url_txt,CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm,CASE when user_role_txt = 'Public' then 1 else 0 end as pub,CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib,CASE when user_role_txt = 'GST' then 1 else 0 end as gst,CASE when user_role_txt = 'CMS' then 1 else 0 end as cmsfrom db.tablewhere acs_ts::date >= $P{Q1START}AND acs_ts::date <= $P{Q1END}AND $X{IN,url_txt,SCREENS}UNION ALLSELECT'Quarter 2' as qtr,url_txt,CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm,CASE when user_role_txt = 'Public' then 1 else 0 end as pub,CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib,CASE when user_role_txt = 'GST' then 1 else 0 end as gst,CASE when user_role_txt = 'CMS' then 1 else 0 end as cmsfrom db.tablewhere acs_ts::date >= $P{Q2START}AND acs_ts::date <= $P{Q2END}AND $X{IN,url_txt,SCREENS}UNION ALLSELECT'Quarter 3' as qtr,url_txt,CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm,CASE when user_role_txt = 'Public' then 1 else 0 end as pub,CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib,CASE when user_role_txt = 'GST' then 1 else 0 end as gst,CASE when user_role_txt = 'CMS' then 1 else 0 end as cmsfrom db.tablewhere acs_ts::date >= $P{Q3START}AND acs_ts::date <= $P{Q3END}AND $X{IN,url_txt,SCREENS}UNION ALLSELECT'Quarter 4' as qtr,url_txt,CASE when user_role_txt = 'Item Developers' then 1 else 0 end as itm,CASE when user_role_txt = 'Public' then 1 else 0 end as pub,CASE when user_role_txt = 'Librarian' then 1 else 0 end as lib,CASE when user_role_txt = 'GST' then 1 else 0 end as gst,CASE when user_role_txt = 'CMS' then 1 else 0 end as cmsfrom db.tablewhere acs_ts::date >= $P{Q4START}AND acs_ts::date <= $P{Q4END}AND $X{IN,url_txt,SCREENS}) as tgroup by t.qtr, t.url_txt]]> </queryString> <field name="url_txt" class="java.lang.String"/> <field name="qtr" class="java.lang.String"/> <field name="itm_page" class="java.lang.Integer"/> <field name="cms_page" class="java.lang.Integer"/> <field name="gst_page" class="java.lang.Integer"/> <field name="pub_page" class="java.lang.Integer"/> <field name="lib_page" class="java.lang.Integer"/> <sortField name="qtr"/> <group name="Group1" keepTogether="true"> <groupExpression> <![CDATA[$F{url_txt}]]> </groupExpression> </group> <pageHeader> <band height="98" splitType="Stretch"> <staticText> <reportElement key="t_4" mode="Opaque" x="130" y="-1" width="320" height="15" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF" uuid="70d07b08-a98f-462f-912c-86e8ca3cffa5"> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DEL Report]]></text> </staticText> <textField pattern="([GENERAL])" isBlankWhenNull="true"> <reportElement key="COMPUTE_5" mode="Opaque" x="140" y="15" width="300" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="fa243ebd-82b3-426a-8693-995a1d029d8c"> <property name="net.sf.jasperreports.export.pdf.tag.h2"/> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Data Element Library Usage Report"]]> </textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="DATE_1" mode="Opaque" x="430" y="0" width="102" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="8c30e5fd-4921-4b61-a07d-fec225f73dca"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="full"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Run Date: " + new SimpleDateFormat("MM/dd/yyyy").format(new Date())]]> </textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Opaque" x="430" y="12" width="40" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="d3278171-f2e1-4241-b57f-5e4f3fc2ee09"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="start"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]> </textFieldExpression> </textField> <textField evaluationTime="Report" pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Transparent" x="470" y="12" width="30" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="f12aa9ee-4dbb-4569-bad4-1994dcfc045c"> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="end"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression> <![CDATA[$V{PAGE_NUMBER}]]> </textFieldExpression> </textField> <image> <reportElement x="0" y="0" width="150" height="56" uuid="5c21389e-0147-4bab-8b2b-b2462883c4e4"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <imageExpression> <![CDATA[$P{CMSLOGO_DIR} + "CMS_logo.jpg"]]> </imageExpression> <hyperlinkTooltipExpression> <![CDATA["Centers for Medicare & Medicaid Services"]]> </hyperlinkTooltipExpression> </image> <staticText> <reportElement x="0" y="70" width="280" height="12" uuid="9f93ebb5-6ca9-4f7f-be7c-d06093207859"> <property name="net.sf.jasperreports.export.pdf.tag.h3" value="start"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement verticalAlignment="Top"> </textElement> <text><![CDATA[Note: * indicates an empty value.]]></text> </staticText> <textField> <reportElement x="140" y="30" width="300" height="20" uuid="c2b0287c-ce1e-461c-aabb-1c6e28b0b30d"/> <textElement textAlignment="Center"/> <textFieldExpression> <![CDATA["From "+$P{START_DATE_RPT}+" to "+$P{END_DATE_RPT}]]> </textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="285"> <barChart> <chart isShowLegend="true"> <reportElement key="" x="0" y="40" width="532" height="245" uuid="090b7b3c-b745-45bd-af08-3b79a027f3c6"> <property name="com.jaspersoft.studio.unit.y" value="inch"/> </reportElement> <chartTitle position="Top"> <titleExpression><![CDATA[$F{url_txt}]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend position="Right"/> </chart> <categoryDataset> <dataset resetType="Page"/> <categorySeries> <seriesExpression><![CDATA["Public"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{pub_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CMS"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{cms_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["GST"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{gst_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Librarian"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{lib_page}]]></valueExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Item Developers"]]></seriesExpression> <categoryExpression><![CDATA[$F{qtr}]]></categoryExpression> <valueExpression><![CDATA[$F{itm_page}]]></valueExpression> </categorySeries> </categoryDataset> <barPlot> <plot backgroundAlpha="1.0"/> <itemLabel/> <categoryAxisLabelExpression><![CDATA["Quarter"]]></categoryAxisLabelExpression> <categoryAxisFormat> <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Page Count"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/> </valueAxisFormat> </barPlot> </barChart> </band> </detail></jasperReport>[/code]

August 21, 2018
- bar charts
- charts
- (and 2 more)
  Tagged with:

Extra page appearing at start of report

abalakrishnan95 posted a topic in Products

Hi all I am creating a report with just using a summary and page header band and each time it is ran I keep getting a blank first page and then the 2nd- whatever is competly fine JRXML <?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="DEL_sys_usg_rpt" pageWidth="792" pageHeight="576" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" uuid="c90df0e9-ca70-4aa8-88ab-3cc66cad2ade"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.unit." value="inch"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="inch"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.topMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="inch"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="false"/> <style name="Table 1_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset4" uuid="0b326947-9951-41ae-a600-b29e69eccfca"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> <parameter name="START_DATE" class="java.util.Date"/> <parameter name="END_DATE" class="java.util.Date"/> <queryString language="SQL"> <![CDATA[sELECT t.url_txt as url_txt, t.pub as pub_page, t.itm as itm_page, t.cms as cms_page, t.gst as gst_page, t.lib as lib_page from ( SELECT url_txt, sum(CASE when user_role_txt = 'Item Developers' then 1 else 0 end )as itm, sum(CASE when user_role_txt = 'Public' then 1 else 0 end )as pub, sum(CASE when user_role_txt = 'Librarian' then 1 else 0 end) as lib, sum(CASE when user_role_txt = 'GST' then 1 else 0 end )as gst, sum(CASE when user_role_txt = 'CMS' then 1 else 0 end) as cms from del_sys.sys_usg WHERE (acs_ts::date BETWEEN $P{START_DATE} AND $P{END_DATE}) AND url_txt != '*' AND url_txt != 'secSignout' AND url_txt != 'pubLogIn' group by url_txt ) as t]]> </queryString> <field name="url_txt" class="java.lang.String"/> <field name="pub_page" class="java.lang.Long"/> <field name="itm_page" class="java.lang.Long"/> <field name="cms_page" class="java.lang.Long"/> <field name="gst_page" class="java.lang.Long"/> <field name="lib_page" class="java.lang.Long"/> <group name="url_txt"> <groupExpression><![CDATA[$F{url_txt}]]></groupExpression> </group> </subDataset> <parameter name="NEWPUB" class="java.lang.Long"/> <parameter name="NEWLIB" class="java.lang.Long"/> <parameter name="NEWCMS" class="java.lang.Long"/> <parameter name="NEWGST" class="java.lang.Long"/> <parameter name="NEWITM" class="java.lang.Long"/> <parameter name="RETPUB" class="java.lang.Long"/> <parameter name="RETLIB" class="java.lang.Long"/> <parameter name="RETCMS" class="java.lang.Long"/> <parameter name="RETGST" class="java.lang.Long"/> <parameter name="RETITM" class="java.lang.Long"/> <parameter name="AVGPGPUB" class="java.lang.String"/> <parameter name="AVGPGLIB" class="java.lang.String"/> <parameter name="AVGPGGST" class="java.lang.String"/> <parameter name="AVGPGITM" class="java.lang.String"/> <parameter name="AVGPGCMS" class="java.lang.String"/> <parameter name="AVGSESPUB" class="java.lang.String"/> <parameter name="AVGSESLIB" class="java.lang.String"/> <parameter name="AVGSESITM" class="java.lang.String"/> <parameter name="AVGSESCMS" class="java.lang.String"/> <parameter name="AVGSESGST" class="java.lang.String"/> <parameter name="CMSLOGO_DIR" class="java.lang.String"/> <parameter name="START_DATE" class="java.util.Date"/> <parameter name="END_DATE" class="java.util.Date"/> <parameter name="START_DATE_RPT" class="java.lang.String"/> <parameter name="END_DATE_RPT" class="java.lang.String"/> <field name="url_txt" class="java.lang.String"/> <field name="pub_page" class="java.lang.String"/> <field name="itm_page" class="java.lang.String"/> <field name="cms_page" class="java.lang.String"/> <field name="gst_page" class="java.lang.String"/> <field name="lib_page" class="java.lang.String"/> <group name="Group1" keepTogether="true"> <groupExpression><![CDATA[$F{url_txt}]]></groupExpression> </group> <pageHeader> <band height="84" splitType="Stretch"> <staticText> <reportElement key="t_4" mode="Opaque" x="220" y="0" width="310" height="15" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#FFFFFF" uuid="70d07b08-a98f-462f-912c-86e8ca3cffa5"> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DEL Report]]></text> </staticText> <textField pattern="([GENERAL])" isBlankWhenNull="true"> <reportElement key="COMPUTE_5" mode="Opaque" x="220" y="15" width="310" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="fa243ebd-82b3-426a-8693-995a1d029d8c"> <property name="net.sf.jasperreports.export.pdf.tag.h2"/> <property name="net.sf.jasperreports.export.pdf.tag.h1" value="full"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA["Data Element Library Usage Report"]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="DATE_1" mode="Opaque" x="640" y="0" width="102" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="8c30e5fd-4921-4b61-a07d-fec225f73dca"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="full"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA["Run Date: " + new SimpleDateFormat("MM/dd/yyyy").format(new Date())]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Opaque" x="640" y="12" width="40" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="d3278171-f2e1-4241-b57f-5e4f3fc2ee09"> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="start"/> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> </textField> <textField evaluationTime="Report" pattern="" isBlankWhenNull="true"> <reportElement key="PAGE_1" mode="Transparent" x="680" y="12" width="30" height="12" forecolor="#000000" backcolor="#FFFFFF" uuid="f12aa9ee-4dbb-4569-bad4-1994dcfc045c"> <property name="net.sf.jasperreports.export.pdf.tag.h3"/> <property name="net.sf.jasperreports.export.pdf.tag.h2" value="end"/> </reportElement> <box> <topPen lineWidth="0.0" lineColor="#000000"/> <leftPen lineWidth="0.0" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineColor="#000000"/> </box> <textElement verticalAlignment="Top"> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <image> <reportElement x="0" y="0" width="150" height="56" uuid="5c21389e-0147-4bab-8b2b-b2462883c4e4"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <imageExpression><![CDATA[$P{CMSLOGO_DIR} + "CMS_logo.jpg"]]></imageExpression> <hyperlinkTooltipExpression><![CDATA["Centers for Medicare & Medicaid Services"]]></hyperlinkTooltipExpression> </image> <staticText> <reportElement x="0" y="70" width="280" height="12" uuid="9f93ebb5-6ca9-4f7f-be7c-d06093207859"> <property name="net.sf.jasperreports.export.pdf.tag.h3" value="start"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement verticalAlignment="Top"> </textElement> <text><![CDATA[Note: * indicates an empty value.]]></text> </staticText> <textField> <reportElement x="210" y="30" width="350" height="20" uuid="c2b0287c-ce1e-461c-aabb-1c6e28b0b30d"/> <textElement textAlignment="Center"/> <textFieldExpression><![CDATA["From "+$P{START_DATE_RPT}+" to "+$P{END_DATE_RPT}]]></textFieldExpression> </textField> </band> </pageHeader> <summary> <band height="404" splitType="Prevent"> <frame> <reportElement x="60" y="25" width="500" height="60" isRemoveLineWhenBlank="true" uuid="0951694e-1069-40fa-9d57-937cd3e9eaa5"/> <componentElement> <reportElement x="0" y="0" width="500" height="72" isRemoveLineWhenBlank="true" uuid="7bc0ffcd-a3d5-4049-8732-5d97d1c2ed76"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/> <property name="net.sf.jasperreports.export.headertoolbar.table.name" value=""/> <property name="com.jaspersoft.studio.components.autoresize.next" value="true"/> <property name="com.jaspersoft.studio.components.autoresize.proportional" value="true"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="inch"/> </reportElement> <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="Dataset4" uuid="33c48d51-e6b7-46e7-a524-2c1ea95bf86c"> <datasetParameter name="START_DATE"> <datasetParameterExpression><![CDATA[$P{START_DATE}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="END_DATE"> <datasetParameterExpression><![CDATA[$P{END_DATE}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="130" uuid="4a78b136-445b-476f-bbe4-e1b369a0cbbb"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="130" height="30" uuid="2ab63740-a000-4104-b1d6-aea28568da16"/> <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"> </textElement> <text><![CDATA[Page]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="130" height="42" uuid="4db2f91f-2e40-4fe2-af6d-4e0d0d1cd5e5"/> <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"/> <textFieldExpression><![CDATA[$F{url_txt}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="67" uuid="657cef28-2a7f-4f97-ba98-9028b3b56754"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="67" height="30" uuid="926a7ac6-4a80-44c0-9515-cac4ebe9ce69"/> <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"> </textElement> <text><![CDATA[Public]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="67" height="42" uuid="a0a45c45-08dd-4e53-be1f-aa4e3dd830f8"/> <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"/> <textFieldExpression><![CDATA[$F{pub_page}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="79" uuid="c94b8a5f-f0d4-4d5b-ac60-5834853093c6"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="79" height="30" uuid="1982b7e6-1cff-4ad6-b327-17e269d3f1c5"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </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"> </textElement> <text><![CDATA[item Developer]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="79" height="42" uuid="81606c89-0aaa-4048-a979-22fc688997b0"/> <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"/> <textFieldExpression><![CDATA[$F{itm_page}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="76" uuid="9f096786-b4ef-4263-aaf9-29a9cb1595f2"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="76" height="30" uuid="14871761-1e60-4137-822b-7937cb918df8"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </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"> </textElement> <text><![CDATA[CMS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="76" height="42" uuid="920f77a9-14e8-4175-b44e-d8c3f4e1977f"/> <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"/> <textFieldExpression><![CDATA[$F{cms_page}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="74" uuid="797ccecf-4421-459a-925c-db1a32b134b4"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="74" height="30" uuid="5aec8956-7e39-411a-9087-ec616535231c"/> <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"> </textElement> <text><![CDATA[GST]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="74" height="42" uuid="c1012b6b-a1c2-4923-8033-3c210e69b52a"/> <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"/> <textFieldExpression><![CDATA[$F{gst_page}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="74" uuid="ad4cee65-3376-4ae5-9408-440dfd99b7d4"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="74" height="30" uuid="d917f431-009a-4fc8-ac82-bf0c619b1936"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </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"> </textElement> <text><![CDATA[Librarian]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table 1_TD" height="42"> <textField> <reportElement x="0" y="0" width="74" height="42" uuid="7f6e4a35-c967-4fda-a470-91c2305a8a0a"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="inch"/> </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"/> <textFieldExpression><![CDATA[$F{lib_page}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </frame> <textField> <reportElement positionType="Float" x="160" y="150" width="90" height="30" uuid="f761fd75-565d-4311-ab47-5fe9c7c0f048"/> <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"/> <textFieldExpression><![CDATA[$P{NEWPUB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="250" y="150" width="90" height="30" uuid="0048f3b6-50ed-47e3-8f42-5dc709b6d513"/> <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"/> <textFieldExpression><![CDATA[$P{NEWITM}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="160" y="120" width="90" height="30" uuid="809b6d1f-d42a-4eb7-a398-bcf7ea528e4e"/> <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"> </textElement> <text><![CDATA[Public]]></text> </staticText> <staticText> <reportElement positionType="Float" x="250" y="120" width="90" height="30" uuid="74d8b632-ef7b-422d-a537-57bb539ba7db"/> <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"> </textElement> <text><![CDATA[item Developer]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="150" width="100" height="30" uuid="a912f65d-5955-428c-8b61-b47fefa8655f"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center"> </textElement> <text><![CDATA[New]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="120" width="100" height="30" uuid="5d1e52ac-88bd-4090-af83-e0354dcbe908"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center"> </textElement> <text><![CDATA[user Type]]></text> </staticText> <textField> <reportElement positionType="Float" x="340" y="150" width="80" height="30" uuid="3e02674e-6a68-4f13-8997-392608f2a496"/> <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"/> <textFieldExpression><![CDATA[$P{NEWCMS}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="420" y="150" width="70" height="30" uuid="bdc0bdc8-7eae-4eb3-a225-77338df40d79"/> <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"/> <textFieldExpression><![CDATA[$P{NEWGST}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="340" y="120" width="80" height="30" uuid="8aab3628-b912-48f6-8a87-734473f0b6b4"/> <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"> </textElement> <text><![CDATA[CMS]]></text> </staticText> <staticText> <reportElement positionType="Float" x="420" y="120" width="70" height="30" uuid="7d638a64-c102-4790-8b00-09de42bfedf4"/> <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"> </textElement> <text><![CDATA[GST]]></text> </staticText> <textField> <reportElement positionType="Float" x="490" y="150" width="70" height="30" uuid="7a0fb7df-fd69-4282-a539-a482eda93d33"/> <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"/> <textFieldExpression><![CDATA[$P{NEWLIB}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="490" y="120" width="70" height="30" uuid="e1bb057a-bcb0-44e8-987c-0ff7c7af16c8"/> <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"> </textElement> <text><![CDATA[Librarian]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="100" width="180" height="20" uuid="6dfa3e16-0ab7-4651-96bf-c226d3d96ca9"/> <textElement textAlignment="Left"> </textElement> <text><![CDATA[user Information]]></text> </staticText> <textField> <reportElement positionType="Float" x="160" y="210" width="90" height="30" uuid="1de49f26-a554-41c5-98a2-e839b457bd49"/> <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"/> <textFieldExpression><![CDATA[$P{NEWPUB}+$P{RETPUB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="250" y="210" width="90" height="30" uuid="2b83eca9-ed9c-4491-8157-9b48a63635c8"/> <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"/> <textFieldExpression><![CDATA[$P{NEWITM}+$P{RETITM}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="60" y="210" width="100" height="30" uuid="2590fd1c-bd4e-4ae8-9d47-1f2a64daa794"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center"> </textElement> <text><![CDATA[Total]]></text> </staticText> <textField> <reportElement positionType="Float" x="340" y="210" width="80" height="30" uuid="5d3e3a7f-a388-4a02-b43c-169ced64c0b7"/> <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"/> <textFieldExpression><![CDATA[$P{NEWCMS}+$P{RETCMS}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="420" y="210" width="70" height="30" uuid="c9a98002-ee84-4569-9f91-06833b974097"/> <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"/> <textFieldExpression><![CDATA[$P{NEWGST}+$P{RETGST}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="490" y="210" width="70" height="30" uuid="19df18df-ad3f-414a-9b1c-1343aa980b1d"/> <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"/> <textFieldExpression><![CDATA[$P{NEWLIB}+$P{RETLIB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="160" y="180" width="90" height="30" uuid="bf2fa9e1-7942-495d-ab4c-045de77983aa"/> <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"/> <textFieldExpression><![CDATA[$P{RETPUB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="250" y="180" width="90" height="30" uuid="727e5ca7-1bbb-43b7-846c-b333f42043db"/> <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"/> <textFieldExpression><![CDATA[$P{RETITM}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="60" y="180" width="100" height="30" uuid="ccbbda79-52ac-4e5a-98a5-2d990c019e6c"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center"> </textElement> <text><![CDATA[Returning]]></text> </staticText> <textField> <reportElement positionType="Float" x="340" y="180" width="80" height="30" uuid="e488225a-3e69-4b84-bf0c-6cc5d54207de"/> <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"/> <textFieldExpression><![CDATA[$P{RETCMS}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="420" y="180" width="70" height="30" uuid="36458b66-2bda-4c5f-9698-050449b27c9b"/> <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"/> <textFieldExpression><![CDATA[$P{RETGST}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="490" y="180" width="70" height="30" uuid="8129627c-813f-41f7-99de-22f12f62859d"/> <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"/> <textFieldExpression><![CDATA[$P{RETLIB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="60" y="370" width="100" height="30" uuid="3a142c07-0ffd-4cc5-a953-094696f41238"/> <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"/> <textFieldExpression><![CDATA[$P{AVGSESPUB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="160" y="370" width="100" height="30" uuid="fd02c4e0-d0bb-4431-b7b8-a8dd404d390e"/> <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"/> <textFieldExpression><![CDATA[$P{AVGSESITM}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="60" y="340" width="100" height="30" uuid="240c732d-9c67-41b9-8067-cd704b16527c"/> <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"> </textElement> <text><![CDATA[Public]]></text> </staticText> <staticText> <reportElement positionType="Float" x="160" y="340" width="100" height="30" uuid="276e550c-254e-4484-8a09-c2a8765dcf66"/> <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"> </textElement> <text><![CDATA[item Developer]]></text> </staticText> <textField> <reportElement positionType="Float" x="260" y="370" width="100" height="30" uuid="a9010035-215d-48ec-ae0a-e47e18a7fb8f"/> <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"/> <textFieldExpression><![CDATA[$P{AVGSESCMS}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="360" y="370" width="100" height="30" uuid="281559c4-e615-4387-bf6a-2f2bbf025844"/> <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"/> <textFieldExpression><![CDATA[$P{AVGSESGST}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="260" y="340" width="100" height="30" uuid="929dc161-9d70-4f29-9207-eb01c68d594b"/> <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"> </textElement> <text><![CDATA[CMS]]></text> </staticText> <staticText> <reportElement positionType="Float" x="360" y="340" width="100" height="30" uuid="05fc7285-2c07-4c51-a6ce-f5e85e254175"/> <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"> </textElement> <text><![CDATA[GST]]></text> </staticText> <textField> <reportElement positionType="Float" x="460" y="370" width="100" height="30" uuid="1ef6e960-4a74-4738-9b23-1789a01a0c46"/> <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"/> <textFieldExpression><![CDATA[$P{AVGSESLIB}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="460" y="340" width="100" height="30" uuid="3c848da7-f689-432e-803f-64ea56232241"/> <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"> </textElement> <text><![CDATA[Librarian]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="320" width="180" height="20" uuid="bf71b67c-0ba5-4ed0-b4bf-996ecc522861"/> <textElement textAlignment="Left"> </textElement> <text><![CDATA[Average Session Time (In Minutes)]]></text> </staticText> <textField> <reportElement positionType="Float" x="60" y="290" width="100" height="30" uuid="ee3a9db0-b43a-4d22-991b-c4218e83f5a3"/> <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"/> <textFieldExpression><![CDATA[$P{AVGPGPUB}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="160" y="290" width="100" height="30" uuid="05f0fb17-7df7-4fd7-a6da-b1bd7e9a9965"/> <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"/> <textFieldExpression><![CDATA[$P{AVGPGITM}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="60" y="260" width="100" height="30" uuid="6035d29b-aa62-4d2d-b634-9ed5e9fc8e2c"/> <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"> </textElement> <text><![CDATA[Public]]></text> </staticText> <staticText> <reportElement positionType="Float" x="160" y="260" width="100" height="30" uuid="d6153b4f-7038-41b8-ac27-27cc20c873f6"/> <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"> </textElement> <text><![CDATA[item Developer]]></text> </staticText> <textField> <reportElement positionType="Float" x="260" y="290" width="100" height="30" uuid="e845d5de-d898-4b29-a189-5b476f0887b0"/> <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"/> <textFieldExpression><![CDATA[$P{AVGPGCMS}]]></textFieldExpression> </textField> <textField> <reportElement positionType="Float" x="360" y="290" width="100" height="30" uuid="9bc40a49-5594-4b60-ab7d-e7569497783b"/> <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"/> <textFieldExpression><![CDATA[$P{AVGPGGST}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="260" y="260" width="100" height="30" uuid="21c18f99-036c-4e25-8482-fef9aec58e17"/> <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"> </textElement> <text><![CDATA[CMS]]></text> </staticText> <staticText> <reportElement positionType="Float" x="360" y="260" width="100" height="30" uuid="5e72cb5e-bd23-46da-b5af-48fc9a412a02"/> <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"> </textElement> <text><![CDATA[GST]]></text> </staticText> <textField> <reportElement positionType="Float" x="460" y="290" width="100" height="30" uuid="4d10e86b-0105-4079-85eb-83a6cbde4321"/> <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"/> <textFieldExpression><![CDATA[$P{AVGPGLIB}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="460" y="260" width="100" height="30" uuid="0b45db72-b7d8-4cbb-a110-6ce134ab445a"/> <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"> </textElement> <text><![CDATA[Librarian]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="240" width="180" height="20" uuid="623c2162-b77b-4d8c-a667-00018e12f52b"/> <textElement textAlignment="Left"> </textElement> <text><![CDATA[Average Pages Per Session]]></text> </staticText> <staticText> <reportElement positionType="Float" x="60" y="5" width="180" height="20" uuid="cda83a63-c49f-4fce-8a54-3009245ef462"/> <textElement textAlignment="Left"> </textElement> <text><![CDATA[Number of Page Views]]></text> </staticText> </band> </summary> </jasperReport> I am not sure what is going on any help would be great thank you

Sign In

Posts

Joined

Last visited