Reports not working with new versions

sneatherlin · July 20, 2006

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

Giulio Toffoli · July 21, 2006

Do you see any exception?

Perhaps a new needed jar is missing...

Can you post here your jrxml?

Are you able to run the jrxml on iReport 1.2.5?

Giulio

sneatherlin · July 21, 2006

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" ?>

<!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">

<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>

</variable>

</variable>

</variable>

</variable>

<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"/>

</textElement>

</textField>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

<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"/>

</rectangle>

<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"/>

</textElement>

</textField>

</band>

</groupHeader>

<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"/>

</line>

<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"/>

</textElement>

</staticText>

<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"/>

</textElement>

</textField>

<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"/>

</textElement>

</staticText>

<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"/>

</textElement>

</textField>

</band>

</groupFooter>

</group>

</band>

</background>

<title>

<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"/>

</rectangle>

<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"/>

</textElement>

</staticText>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

<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"/>

</textElement>

</textField>

<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"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</lastPageFooter>

</band>

</summary>

</jasperReport>

Here is the jrxml file in my templates folder for version 1.2.5

<?xml version="1.0" encoding="UTF-8" ?>

<!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">

<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>

</variable>

</variable>

</variable>

</variable>

<reportElement

mode="Opaque"

x="1"

y="1"

width="142"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

</textElement>

</textField>

</band>

</groupHeader>

</band>

</groupFooter>

</group>

<reportElement

mode="Opaque"

x="1"

y="1"

width="532"

height="18"

forecolor="#000000"

backcolor="#CCCCCC"

key="rectangle-2"/>

</rectangle>

<reportElement

mode="Transparent"

x="36"

y="2"

width="100"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

</textElement>

</textField>

</band>

</groupHeader>

<reportElement

mode="Opaque"

x="49"

y="1"

width="325"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="line-1"/>

</line>

<reportElement

mode="Opaque"

x="49"

y="2"

width="37"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-2"/>

</textElement>

</staticText>

<reportElement

mode="Transparent"

x="87"

y="2"

width="81"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="169"

y="2"

width="60"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-3"/>

</textElement>

</staticText>

<reportElement

mode="Opaque"

x="230"

y="2"

width="78"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

</textElement>

</textField>

</band>

</groupFooter>

</group>

</band>

</background>

<title>

<reportElement

mode="Opaque"

x="0"

y="0"

width="533"

height="26"

forecolor="#000000"

backcolor="#CCCCCC"

key="rectangle-1"/>

</rectangle>

<reportElement

mode="Transparent"

x="8"

y="1"

width="517"

height="24"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-1"/>

</textElement>

</staticText>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

<reportElement

mode="Opaque"

x="49"

y="0"

width="163"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"

isPrintRepeatedValues="false"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="212"

y="0"

width="163"

height="12"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</lastPageFooter>

</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

Sign In

Reports not working with new versions

Recommended Posts

sneatherlin

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Giulio Toffoli

Link to comment

Share on other sites

sneatherlin

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore