Jump to content
Changes to the Jaspersoft community edition download ×

abalakrishnan95

Members
  • Posts

    3
  • Joined

  • Last visited

abalakrishnan95's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2018-08-29T14:10:32 --><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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" isBold="false"/> </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
  2. 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"?><!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --><!-- 2018-08-21T14:23:03 --><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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" isBold="false"/> </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]
  3. 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"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2018-02-28T08:54:26 --> <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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="12" isBold="true"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" size="8"/> <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"> <font fontName="Arial" isBold="false"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font fontName="SansSerif" isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true" isUnderline="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true" isUnderline="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true" isUnderline="true"/> </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"> <font isBold="true" isUnderline="true"/> </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
×
×
  • Create New...