I am new to Java and to JasperReports/iReports.
I downloaded JasperReports 1.2.4 and iReports 1.2.3.
I am trying to run my report from within a Java Servlet.
I am connecting to as/400.
Using iReports version 1.2.3 I am able to create jasper file, place into directory used to hold my jasper files on my local machine.
When I send in my resultSet to the JasperRunManager.runReportToPdf method I get my pdf with data.
Using iReports 1.2.4 and 1.2.5 I create the same report place into directory as above.
Again using same code in Java Servlet when I pass in my resultset I get back a blank page.
Again I am new to both technologies so may have missed something but would greatly appreciate any help.
Did a test this morning taking a .jrxml file and loading it into iReports ver 1.2.3 compiling, took the jasper file created and placed in my webapps report directory and ran. Report showed as expected.
Took the same .jrxml file loaded into iReports ver 1.2.5 and compiled. Noticed jasper file was slightly bigger. I took the jasper file and placed into my webapps report directory replacing the 1.2.3 compiled version. Report brings up empty page only. I can switch out the jasper files 1.2.3 will work as expected 1.2.5 continues to show empty page.
If anybody can point me to relevant documentation I would be most greatful plus for any help given. I can't understand why one would work and the other one wouldn't. Could it be I don't have all the needed Jar files in the ClassPath?
Respectfully,
Post edited by: sneatherlin, at: 2006/07/20 14:38
I downloaded JasperReports 1.2.4 and iReports 1.2.3.
I am trying to run my report from within a Java Servlet.
I am connecting to as/400.
Using iReports version 1.2.3 I am able to create jasper file, place into directory used to hold my jasper files on my local machine.
When I send in my resultSet to the JasperRunManager.runReportToPdf method I get my pdf with data.
Using iReports 1.2.4 and 1.2.5 I create the same report place into directory as above.
Again using same code in Java Servlet when I pass in my resultset I get back a blank page.
Again I am new to both technologies so may have missed something but would greatly appreciate any help.
Did a test this morning taking a .jrxml file and loading it into iReports ver 1.2.3 compiling, took the jasper file created and placed in my webapps report directory and ran. Report showed as expected.
Took the same .jrxml file loaded into iReports ver 1.2.5 and compiled. Noticed jasper file was slightly bigger. I took the jasper file and placed into my webapps report directory replacing the 1.2.3 compiled version. Report brings up empty page only. I can switch out the jasper files 1.2.3 will work as expected 1.2.5 continues to show empty page.
If anybody can point me to relevant documentation I would be most greatful plus for any help given. I can't understand why one would work and the other one wouldn't. Could it be I don't have all the needed Jar files in the ClassPath?
Respectfully,
Post edited by: sneatherlin, at: 2006/07/20 14:38
2 Answers:
Posted on July 20, 2006 at 6:31pm
Thank you for your response.
I am getting no exceptions.
Here is the jrxml that is in my templates file for ver 1.2.3.
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="SevenDayOAReport"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.encoding" value="UTF-8" />
<property name="ireport.scriptlethandling" value="0" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<queryString><![CDATA[SELECT ALUSID AS USER_ID,
ALIPAD,
ALUSTP,
MONTH(ALDTTM) AS USE_MONTH,
DAYOFMONTH(ALDTTM) AS USE_DAY,
YEAR(ALDTTM) AS USE_YEAR,
SUBSTRING(DIGITS(MINUTE(ALDTTM)),9,2)AS USE_MIN,
TRIM(UFFRNM)AS USER_FIRST_NAME,
TRIM(UFNMMI)AS USER_MIDDLE_INITIAL,
TRIM(UFLSNM)AS USER_LAST_NAME,
CASE HOUR(ALDTTM)
WHEN 13 THEN 1
WHEN 14 THEN 2
WHEN 15 THEN 3
WHEN 16 THEN 4
WHEN 17 THEN 5
WHEN 18 THEN 6
WHEN 19 THEN 7
WHEN 20 THEN 8
WHEN 21 THEN 9
WHEN 22 THEN 10
WHEN 23 THEN 11
WHEN 24 THEN 12
ELSE HOUR(ALDTTM)
END AS USE_HOUR,
CASE HOUR(ALDTTM)
WHEN 12 THEN 'PM'
WHEN 13 THEN 'PM'
WHEN 14 THEN 'PM'
WHEN 15 THEN 'PM'
WHEN 16 THEN 'PM'
WHEN 17 THEN 'PM'
WHEN 18 THEN 'PM'
WHEN 19 THEN 'PM'
WHEN 20 THEN 'PM'
WHEN 21 THEN 'PM'
WHEN 22 THEN 'PM'
WHEN 23 THEN 'PM'
WHEN 24 THEN 'PM'
ELSE 'AM'
END AS USE_AMPM,
CASE UFUSTP
WHEN 'AG' THEN 'Sales Agent'
WHEN 'FH' THEN 'Funeral Home'
WHEN 'CH' THEN 'Contract Holder'
WHEN 'AY' THEN 'Agency'
WHEN 'MG' THEN 'Sales Manager'
ELSE UFUSTP
END AS USER_TYPE,
UFENST AS USER_STATUS,
UFFMNM AS USER_FIRM
FROM GENMODDTA4.OALOGF, GENMODDTA4.OAUSRFL
WHERE ALUSID = UFUSID
AND DATE(ALDTTM) >= DATE(NOW()-7 DAY)
ORDER BY DATE(ALDTTM), UFUSTP, ALUSID]]></queryString>
<field name="USER_ID" class="java.lang.String"/>
<field name="ALIPAD" class="java.lang.String"/>
<field name="ALUSTP" class="java.lang.String"/>
<field name="USE_MONTH" class="java.lang.Integer"/>
<field name="USE_DAY" class="java.lang.Integer"/>
<field name="USE_YEAR" class="java.lang.Integer"/>
<field name="USE_MIN" class="java.lang.String"/>
<field name="USER_FIRST_NAME" class="java.lang.String"/>
<field name="USER_MIDDLE_INITIAL" class="java.lang.String"/>
<field name="USER_LAST_NAME" class="java.lang.String"/>
<field name="USE_HOUR" class="java.lang.Integer"/>
<field name="USE_AMPM" class="java.lang.String"/>
<field name="USER_TYPE" class="java.lang.String"/>
<field name="USER_STATUS" class="java.lang.String"/>
<field name="USER_FIRM" class="java.lang.String"/>
<variable name="USE_DATE" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_MONTH} + "/" + $F{USE_DAY} + "/" + $F{USE_YEAR}]]></variableExpression>
</variable>
<variable name="USER_FULL_NAME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USER_FIRST_NAME} + " " + $F{USER_MIDDLE_INITIAL} + " " + $F{USER_LAST_NAME}]]></variableExpression>
</variable>
<variable name="USE_TIME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_HOUR} + ":" + $F{USE_MIN} + " " + $F{USE_AMPM}]]></variableExpression>
</variable>
<variable name="USE_TOTAL_BY_TYPE" class="java.lang.Integer" resetType="Group" resetGroup="user_type" calculation="Count">
<variableExpression><![CDATA[$V{COLUMN_COUNT}]]></variableExpression>
</variable>
<group name="oa_use_date" isStartNewColumn="true" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$V{USE_DATE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="oa_use_date" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="142"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_DATE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="50" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="user_type" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$F{USER_TYPE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="532"
height="18"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="36"
y="2"
width="100"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="43" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="49"
y="1"
width="325"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<staticText>
<reportElement
mode="Opaque"
x="49"
y="2"
width="37"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Total:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="87"
y="2"
width="81"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
mode="Opaque"
x="169"
y="2"
width="60"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-3"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Logins]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="230"
y="2"
width="78"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{USE_TOTAL_BY_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="26" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="0"
width="533"
height="26"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<staticText>
<reportElement
mode="Transparent"
x="8"
y="1"
width="517"
height="24"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="17" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Online Access User Report - Past Seven Days]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="29" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="49"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="false"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USER_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="212"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_TIME}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="37" isSplitAllowed="true" >
</band>
</pageFooter>
<lastPageFooter>
<band height="25" isSplitAllowed="true" >
</band>
</lastPageFooter>
<summary>
<band height="26" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
Here is the jrxml file in my templates folder for version 1.2.5
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="SevenDayOAReport"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<queryString><![CDATA[SELECT ALUSID AS USER_ID,
ALIPAD,
ALUSTP,
MONTH(ALDTTM) AS USE_MONTH,
DAYOFMONTH(ALDTTM) AS USE_DAY,
YEAR(ALDTTM) AS USE_YEAR,
SUBSTRING(DIGITS(MINUTE(ALDTTM)),9,2)AS USE_MIN,
TRIM(UFFRNM)AS USER_FIRST_NAME,
TRIM(UFNMMI)AS USER_MIDDLE_INITIAL,
TRIM(UFLSNM)AS USER_LAST_NAME,
CASE HOUR(ALDTTM)
WHEN 13 THEN 1
WHEN 14 THEN 2
WHEN 15 THEN 3
WHEN 16 THEN 4
WHEN 17 THEN 5
WHEN 18 THEN 6
WHEN 19 THEN 7
WHEN 20 THEN 8
WHEN 21 THEN 9
WHEN 22 THEN 10
WHEN 23 THEN 11
WHEN 24 THEN 12
ELSE HOUR(ALDTTM)
END AS USE_HOUR,
CASE HOUR(ALDTTM)
WHEN 12 THEN 'PM'
WHEN 13 THEN 'PM'
WHEN 14 THEN 'PM'
WHEN 15 THEN 'PM'
WHEN 16 THEN 'PM'
WHEN 17 THEN 'PM'
WHEN 18 THEN 'PM'
WHEN 19 THEN 'PM'
WHEN 20 THEN 'PM'
WHEN 21 THEN 'PM'
WHEN 22 THEN 'PM'
WHEN 23 THEN 'PM'
WHEN 24 THEN 'PM'
ELSE 'AM'
END AS USE_AMPM,
CASE UFUSTP
WHEN 'AG' THEN 'Sales Agent'
WHEN 'FH' THEN 'Funeral Home'
WHEN 'CH' THEN 'Contract Holder'
WHEN 'AY' THEN 'Agency'
WHEN 'MG' THEN 'Sales Manager'
ELSE UFUSTP
END AS USER_TYPE,
UFENST AS USER_STATUS,
UFFMNM AS USER_FIRM
FROM GENMODDTA4.OALOGF, GENMODDTA4.OAUSRFL
WHERE ALUSID = UFUSID
AND DATE(ALDTTM) >= DATE(NOW()-7 DAY)
ORDER BY DATE(ALDTTM), UFUSTP, ALUSID]]></queryString>
<field name="USER_ID" class="java.lang.String"/>
<field name="ALIPAD" class="java.lang.String"/>
<field name="ALUSTP" class="java.lang.String"/>
<field name="USE_MONTH" class="java.lang.Integer"/>
<field name="USE_DAY" class="java.lang.Integer"/>
<field name="USE_YEAR" class="java.lang.Integer"/>
<field name="USE_MIN" class="java.lang.String"/>
<field name="USER_FIRST_NAME" class="java.lang.String"/>
<field name="USER_MIDDLE_INITIAL" class="java.lang.String"/>
<field name="USER_LAST_NAME" class="java.lang.String"/>
<field name="USE_HOUR" class="java.lang.Integer"/>
<field name="USE_AMPM" class="java.lang.String"/>
<field name="USER_TYPE" class="java.lang.String"/>
<field name="USER_STATUS" class="java.lang.String"/>
<field name="USER_FIRM" class="java.lang.String"/>
<variable name="USE_DATE" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_MONTH} + "/" + $F{USE_DAY} + "/" + $F{USE_YEAR}]]></variableExpression>
</variable>
<variable name="USER_FULL_NAME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USER_FIRST_NAME} + " " + $F{USER_MIDDLE_INITIAL} + " " + $F{USER_LAST_NAME}]]></variableExpression>
</variable>
<variable name="USE_TIME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_HOUR} + ":" + $F{USE_MIN} + " " + $F{USE_AMPM}]]></variableExpression>
</variable>
<variable name="USE_TOTAL_BY_TYPE" class="java.lang.Integer" resetType="Group" resetGroup="user_type" calculation="Count">
<variableExpression><![CDATA[$V{COLUMN_COUNT}]]></variableExpression>
</variable>
<group name="oa_use_date" isStartNewColumn="true" isReprintHeaderOnEachPage="true" >
<groupExpression><![CDATA[$V{USE_DATE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="oa_use_date" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="142"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_DATE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="50" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="user_type" >
<groupExpression><![CDATA[$F{USER_TYPE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="532"
height="18"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-2"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="36"
y="2"
width="100"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="43" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="49"
y="1"
width="325"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line-1"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<staticText>
<reportElement
mode="Opaque"
x="49"
y="2"
width="37"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-2"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Total:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="87"
y="2"
width="81"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
mode="Opaque"
x="169"
y="2"
width="60"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Logins]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="230"
y="2"
width="78"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{USE_TOTAL_BY_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="26" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="0"
width="533"
height="26"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-1"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<staticText>
<reportElement
mode="Transparent"
x="8"
y="1"
width="517"
height="24"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="17" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Online Access User Report - Past Seven Days]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="29" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="49"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
isPrintRepeatedValues="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USER_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="212"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_TIME}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="37" isSplitAllowed="true" >
</band>
</pageFooter>
<lastPageFooter>
<band height="25" isSplitAllowed="true" >
</band>
</lastPageFooter>
<summary>
<band height="26" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
I feel, like I think you do, that it is a missing jar file that is needed for newer version.
I can't find any documentation regarding what files are needed and hate to shotgun it by placing all the jar files that reside in the lib file for iReports into my webapp lib file.
Yes iReports for both versions create an identical pdf document.
Thank you again for your response and hope to hear from you soon.
cheers,
Sam
I am getting no exceptions.
Here is the jrxml that is in my templates file for ver 1.2.3.
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="SevenDayOAReport"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.encoding" value="UTF-8" />
<property name="ireport.scriptlethandling" value="0" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<queryString><![CDATA[SELECT ALUSID AS USER_ID,
ALIPAD,
ALUSTP,
MONTH(ALDTTM) AS USE_MONTH,
DAYOFMONTH(ALDTTM) AS USE_DAY,
YEAR(ALDTTM) AS USE_YEAR,
SUBSTRING(DIGITS(MINUTE(ALDTTM)),9,2)AS USE_MIN,
TRIM(UFFRNM)AS USER_FIRST_NAME,
TRIM(UFNMMI)AS USER_MIDDLE_INITIAL,
TRIM(UFLSNM)AS USER_LAST_NAME,
CASE HOUR(ALDTTM)
WHEN 13 THEN 1
WHEN 14 THEN 2
WHEN 15 THEN 3
WHEN 16 THEN 4
WHEN 17 THEN 5
WHEN 18 THEN 6
WHEN 19 THEN 7
WHEN 20 THEN 8
WHEN 21 THEN 9
WHEN 22 THEN 10
WHEN 23 THEN 11
WHEN 24 THEN 12
ELSE HOUR(ALDTTM)
END AS USE_HOUR,
CASE HOUR(ALDTTM)
WHEN 12 THEN 'PM'
WHEN 13 THEN 'PM'
WHEN 14 THEN 'PM'
WHEN 15 THEN 'PM'
WHEN 16 THEN 'PM'
WHEN 17 THEN 'PM'
WHEN 18 THEN 'PM'
WHEN 19 THEN 'PM'
WHEN 20 THEN 'PM'
WHEN 21 THEN 'PM'
WHEN 22 THEN 'PM'
WHEN 23 THEN 'PM'
WHEN 24 THEN 'PM'
ELSE 'AM'
END AS USE_AMPM,
CASE UFUSTP
WHEN 'AG' THEN 'Sales Agent'
WHEN 'FH' THEN 'Funeral Home'
WHEN 'CH' THEN 'Contract Holder'
WHEN 'AY' THEN 'Agency'
WHEN 'MG' THEN 'Sales Manager'
ELSE UFUSTP
END AS USER_TYPE,
UFENST AS USER_STATUS,
UFFMNM AS USER_FIRM
FROM GENMODDTA4.OALOGF, GENMODDTA4.OAUSRFL
WHERE ALUSID = UFUSID
AND DATE(ALDTTM) >= DATE(NOW()-7 DAY)
ORDER BY DATE(ALDTTM), UFUSTP, ALUSID]]></queryString>
<field name="USER_ID" class="java.lang.String"/>
<field name="ALIPAD" class="java.lang.String"/>
<field name="ALUSTP" class="java.lang.String"/>
<field name="USE_MONTH" class="java.lang.Integer"/>
<field name="USE_DAY" class="java.lang.Integer"/>
<field name="USE_YEAR" class="java.lang.Integer"/>
<field name="USE_MIN" class="java.lang.String"/>
<field name="USER_FIRST_NAME" class="java.lang.String"/>
<field name="USER_MIDDLE_INITIAL" class="java.lang.String"/>
<field name="USER_LAST_NAME" class="java.lang.String"/>
<field name="USE_HOUR" class="java.lang.Integer"/>
<field name="USE_AMPM" class="java.lang.String"/>
<field name="USER_TYPE" class="java.lang.String"/>
<field name="USER_STATUS" class="java.lang.String"/>
<field name="USER_FIRM" class="java.lang.String"/>
<variable name="USE_DATE" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_MONTH} + "/" + $F{USE_DAY} + "/" + $F{USE_YEAR}]]></variableExpression>
</variable>
<variable name="USER_FULL_NAME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USER_FIRST_NAME} + " " + $F{USER_MIDDLE_INITIAL} + " " + $F{USER_LAST_NAME}]]></variableExpression>
</variable>
<variable name="USE_TIME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_HOUR} + ":" + $F{USE_MIN} + " " + $F{USE_AMPM}]]></variableExpression>
</variable>
<variable name="USE_TOTAL_BY_TYPE" class="java.lang.Integer" resetType="Group" resetGroup="user_type" calculation="Count">
<variableExpression><![CDATA[$V{COLUMN_COUNT}]]></variableExpression>
</variable>
<group name="oa_use_date" isStartNewColumn="true" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="true" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$V{USE_DATE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="oa_use_date" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="142"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_DATE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="50" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="user_type" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >
<groupExpression><![CDATA[$F{USER_TYPE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="532"
height="18"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="36"
y="2"
width="100"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="43" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="49"
y="1"
width="325"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<staticText>
<reportElement
mode="Opaque"
x="49"
y="2"
width="37"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Total:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="87"
y="2"
width="81"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
mode="Opaque"
x="169"
y="2"
width="60"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-3"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Logins]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="230"
y="2"
width="78"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{USE_TOTAL_BY_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="26" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="0"
width="533"
height="26"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<staticText>
<reportElement
mode="Transparent"
x="8"
y="1"
width="517"
height="24"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="17" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Online Access User Report - Past Seven Days]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="29" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="49"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="false"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USER_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="212"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_TIME}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="37" isSplitAllowed="true" >
</band>
</pageFooter>
<lastPageFooter>
<band height="25" isSplitAllowed="true" >
</band>
</lastPageFooter>
<summary>
<band height="26" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
Here is the jrxml file in my templates folder for version 1.2.5
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="SevenDayOAReport"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<queryString><![CDATA[SELECT ALUSID AS USER_ID,
ALIPAD,
ALUSTP,
MONTH(ALDTTM) AS USE_MONTH,
DAYOFMONTH(ALDTTM) AS USE_DAY,
YEAR(ALDTTM) AS USE_YEAR,
SUBSTRING(DIGITS(MINUTE(ALDTTM)),9,2)AS USE_MIN,
TRIM(UFFRNM)AS USER_FIRST_NAME,
TRIM(UFNMMI)AS USER_MIDDLE_INITIAL,
TRIM(UFLSNM)AS USER_LAST_NAME,
CASE HOUR(ALDTTM)
WHEN 13 THEN 1
WHEN 14 THEN 2
WHEN 15 THEN 3
WHEN 16 THEN 4
WHEN 17 THEN 5
WHEN 18 THEN 6
WHEN 19 THEN 7
WHEN 20 THEN 8
WHEN 21 THEN 9
WHEN 22 THEN 10
WHEN 23 THEN 11
WHEN 24 THEN 12
ELSE HOUR(ALDTTM)
END AS USE_HOUR,
CASE HOUR(ALDTTM)
WHEN 12 THEN 'PM'
WHEN 13 THEN 'PM'
WHEN 14 THEN 'PM'
WHEN 15 THEN 'PM'
WHEN 16 THEN 'PM'
WHEN 17 THEN 'PM'
WHEN 18 THEN 'PM'
WHEN 19 THEN 'PM'
WHEN 20 THEN 'PM'
WHEN 21 THEN 'PM'
WHEN 22 THEN 'PM'
WHEN 23 THEN 'PM'
WHEN 24 THEN 'PM'
ELSE 'AM'
END AS USE_AMPM,
CASE UFUSTP
WHEN 'AG' THEN 'Sales Agent'
WHEN 'FH' THEN 'Funeral Home'
WHEN 'CH' THEN 'Contract Holder'
WHEN 'AY' THEN 'Agency'
WHEN 'MG' THEN 'Sales Manager'
ELSE UFUSTP
END AS USER_TYPE,
UFENST AS USER_STATUS,
UFFMNM AS USER_FIRM
FROM GENMODDTA4.OALOGF, GENMODDTA4.OAUSRFL
WHERE ALUSID = UFUSID
AND DATE(ALDTTM) >= DATE(NOW()-7 DAY)
ORDER BY DATE(ALDTTM), UFUSTP, ALUSID]]></queryString>
<field name="USER_ID" class="java.lang.String"/>
<field name="ALIPAD" class="java.lang.String"/>
<field name="ALUSTP" class="java.lang.String"/>
<field name="USE_MONTH" class="java.lang.Integer"/>
<field name="USE_DAY" class="java.lang.Integer"/>
<field name="USE_YEAR" class="java.lang.Integer"/>
<field name="USE_MIN" class="java.lang.String"/>
<field name="USER_FIRST_NAME" class="java.lang.String"/>
<field name="USER_MIDDLE_INITIAL" class="java.lang.String"/>
<field name="USER_LAST_NAME" class="java.lang.String"/>
<field name="USE_HOUR" class="java.lang.Integer"/>
<field name="USE_AMPM" class="java.lang.String"/>
<field name="USER_TYPE" class="java.lang.String"/>
<field name="USER_STATUS" class="java.lang.String"/>
<field name="USER_FIRM" class="java.lang.String"/>
<variable name="USE_DATE" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_MONTH} + "/" + $F{USE_DAY} + "/" + $F{USE_YEAR}]]></variableExpression>
</variable>
<variable name="USER_FULL_NAME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USER_FIRST_NAME} + " " + $F{USER_MIDDLE_INITIAL} + " " + $F{USER_LAST_NAME}]]></variableExpression>
</variable>
<variable name="USE_TIME" class="java.lang.String" resetType="Column" calculation="Nothing">
<variableExpression><![CDATA[$F{USE_HOUR} + ":" + $F{USE_MIN} + " " + $F{USE_AMPM}]]></variableExpression>
</variable>
<variable name="USE_TOTAL_BY_TYPE" class="java.lang.Integer" resetType="Group" resetGroup="user_type" calculation="Count">
<variableExpression><![CDATA[$V{COLUMN_COUNT}]]></variableExpression>
</variable>
<group name="oa_use_date" isStartNewColumn="true" isReprintHeaderOnEachPage="true" >
<groupExpression><![CDATA[$V{USE_DATE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="oa_use_date" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="142"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_DATE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="50" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="user_type" >
<groupExpression><![CDATA[$F{USER_TYPE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="1"
y="1"
width="532"
height="18"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-2"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="36"
y="2"
width="100"
height="15"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
<groupFooter>
<band height="43" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
mode="Opaque"
x="49"
y="1"
width="325"
height="0"
forecolor="#000000"
backcolor="#FFFFFF"
key="line-1"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</line>
<staticText>
<reportElement
mode="Opaque"
x="49"
y="2"
width="37"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-2"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Total:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="87"
y="2"
width="81"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{USER_TYPE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
mode="Opaque"
x="169"
y="2"
width="60"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Logins]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="230"
y="2"
width="78"
height="13"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{USE_TOTAL_BY_TYPE}]]></textFieldExpression>
</textField>
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="26" isSplitAllowed="true" >
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="0"
width="533"
height="26"
forecolor="#000000"
backcolor="#CCCCCC"
key="rectangle-1"/>
<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />
</rectangle>
<staticText>
<reportElement
mode="Transparent"
x="8"
y="1"
width="517"
height="24"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="17" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Online Access User Report - Past Seven Days]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="29" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="14" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="49"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
isPrintRepeatedValues="false"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USER_FULL_NAME}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="212"
y="0"
width="163"
height="12"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="Helvetica" size="5" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$V{USE_TIME}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="37" isSplitAllowed="true" >
</band>
</pageFooter>
<lastPageFooter>
<band height="25" isSplitAllowed="true" >
</band>
</lastPageFooter>
<summary>
<band height="26" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
I feel, like I think you do, that it is a missing jar file that is needed for newer version.
I can't find any documentation regarding what files are needed and hate to shotgun it by placing all the jar files that reside in the lib file for iReports into my webapp lib file.
Yes iReports for both versions create an identical pdf document.
Thank you again for your response and hope to hear from you soon.
cheers,
Sam
