help me,please

[moxie]

hi,

i'm very new in jasperreport and ireport1.2.5.

currently i use jasperreport1.2.5 and ireport1.2.5 to create a report. the follow:

 

////////////////classic.jrxml is :

 

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

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 AAB020_1,COUNT(*) ,SUM(AAB216) FROM JF1 WHERE AAE043='200603' GROUP BY AAB020_1]]></queryString>

 

<field name="AAB020_1" class="java.lang.String"/>

<field name="COUNT(*)" class="java.math.BigDecimal"/>

<field name="SUM(JF1.AAB216)" class="java.math.BigDecimal"/>

 

<background>

<band height="0" isSplitAllowed="true" >

</band>

</background>

<title>

<band height="50" isSplitAllowed="true" >

<staticText>

<reportElement

x="61"

y="5"

width="412"

height="40"

key="staticText"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">

<font size="28" isBold="true"/>

</textElement>

<text><![CDATA[Classic Report Template]]></text>

</staticText>

<line direction="TopDown">

<reportElement

x="0"

y="48"

width="534"

height="0"

forecolor="#000000"

key="line"

positionType="FixRelativeToBottom"/>

<graphicElement stretchType="NoStretch" pen="2Point"/>

</line>

<line direction="TopDown">

<reportElement

x="0"

y="3"

width="534"

height="0"

forecolor="#000000"

key="line"/>

<graphicElement stretchType="NoStretch" pen="2Point"/>

</line>

</band>

</title>

<pageHeader>

<band height="9" isSplitAllowed="true" >

</band>

</pageHeader>

<columnHeader>

<band height="20" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="1"

y="1"

width="534"

height="17"

forecolor="#000000"

backcolor="#999999"

key="element-22"/>

<graphicElement stretchType="NoStretch" pen="Thin"/>

</rectangle>

<staticText>

<reportElement

x="0"

y="1"

width="178"

height="16"

forecolor="#FFFFFF"

key="element-90"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="" size="12"/>

</textElement>

<text><![CDATA[AAB020_1]]></text>

</staticText>

<staticText>

<reportElement

x="178"

y="1"

width="178"

height="16"

forecolor="#FFFFFF"

key="element-90"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="" size="12"/>

</textElement>

<text><![CDATA[COUNT(*)]]></text>

</staticText>

<staticText>

<reportElement

x="356"

y="1"

width="178"

height="16"

forecolor="#FFFFFF"

key="element-90"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="" size="12"/>

</textElement>

<text><![CDATA[sUM(JF1.AAB216)]]></text>

</staticText>

</band>

</columnHeader>

<detail>

<band height="19" isSplitAllowed="true" >

<line direction="TopDown">

<reportElement

x="0"

y="17"

width="535"

height="0"

forecolor="#808080"

key="line"

positionType="FixRelativeToBottom"/>

<graphicElement stretchType="NoStretch" pen="Thin"/>

</line>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="0"

y="1"

width="178"

height="15"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="Times-Roman" size="12"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{AAB020_1}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="178"

y="1"

width="178"

height="15"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="Times-Roman" size="12"/>

</textElement>

<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COUNT(*)}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="356"

y="1"

width="178"

height="15"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="Times-Roman" size="12"/>

</textElement>

<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SUM(JF1.AAB216)}]]></textFieldExpression>

</textField>

</band>

</detail>

<columnFooter>

<band height="0" isSplitAllowed="true" >

</band>

</columnFooter>

<pageFooter>

<band height="27" isSplitAllowed="true" >

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="325"

y="4"

width="170"

height="19"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">

<font fontName="Helvetica" size="10"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="499"

y="4"

width="36"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

x="0"

y="1"

width="535"

height="0"

forecolor="#000000"

key="line"/>

<graphicElement stretchType="NoStretch" pen="2Point"/>

</line>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="1"

y="6"

width="209"

height="19"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font fontName="Times-Roman" size="10"/>

</textElement>

<textFieldExpression class="java.util.Date"><![CDATA[ new Date() ]]></textFieldExpression>

</textField>

</band>

</pageFooter>

<summary>

<band height="0" isSplitAllowed="true" >

</band>

</summary>

</jasperReport>

 

 

///////////////java file is :

 

import java.io.*;

import java.sql.*;

import java.util.HashMap;

import java.util.Map;

import javax.sql.*;

import javax.naming.*;

import net.sf.jasperreports.engine.*;

import org.apache.commons.digester.*;

import java.util.*;

//import java.io.InputStream;

public class demo

{

public static void main(String[] args) {

try {

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

Connection con = DriverManager.getConnection("jdbc:sybase:Tds:127.0.0.1:6889", "JHKFX", "JSJHKFX");

File f1 = new File("classic.jrxml");

JasperCompileManager jcom=new JasperCompileManager();

JasperReport main1 = JasperCompileManager.compileReport( f1.getAbsolutePath() );

Map props = new HashMap();

JasperPrint print = JasperFillManager.fillReport(main1, props,con);

//JasperPrintManager.printReport(print,true);

JasperExportManager.exportReportToPdfFile(print, "a.pdf");

//JasperRunManager.runReportToPdfFile("Account.jasper", "a.pdf", props, con);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} catch (JRException e) {

e.printStackTrace();

}

}

}

classpath setup is ok,my classpath is

.;

C:j2sdk1.4.2libdt.jar;

C:j2sdk1.4.2libtools.jar;

C:Program FilesAltovaxmlspyXMLSpyInterface.jar;

E:Program FilesSybaseSharedjConnect-5_5classesjconn2.jar;

E:beaweblogic81serverlibweblogic.jar;

E:jasperreportjasperreports-1.2.5libjasperreports-1.2.5.jar;

E:jasperreportjasperreports-1.2.5libjfreechart-1.0.0.jar;

E:jasperreportjasperreports-1.2.5libjcommon-1.0.0.jar;

E:jfreechart-1.0.0-rc1libgnujaxp.jar;

E:jfreechart-1.0.0-rc1libjunit.jar;

E:jasperreportjasperreports-1.2.5libservlet.jar;

E:jasperreportjasperreports-1.2.5libitext-1.3.1.jar;

E:jasperreportjasperreports-1.2.5libiTextAsian.jar;

E:jasperreportjasperreports-1.2.5libcommons-beanutils-1.5.jar;

E:jasperreportjasperreports-1.2.5libcommons-collections-2.1.jar;

E:jasperreportjasperreports-1.2.5libcommons-digester-1.7.jar;

E:jasperreportjasperreports-1.2.5libcommons-javaflow-20060411.jar;

E:jasperreportjasperreports-1.2.5libcommons-logging-1.0.2.jar;

E:jasperreportjasperreports-1.2.5libcommons-logging-api-1.0.2.jar;

E:jasperreportjasperreports-1.2.5lib;

 

javac demo.java is OK,

but show error when to execute java demo command in cmd.exe .

 

//////////////////////The error information listing:

 

net.sf.jasperreports.engine.JRException: Errors were encountered when compiling

report expressions class file:

E:jasperreportjasperreports-1.2.5classic_1155265904140_53310.java:273: cannot resolve symbol

symbol : class Dte

location: package util

value = (java.util.Dte)(new Date()); /////////here, errot point is java.util.Dte ,but it is java.util.Date in classic.jrxml,why? ^

1 error

 

at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:192)

at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105)

at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127)

at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109)

at demo.main(demo.java:26)

 

 

//////////////////////////////

 

 

why shows the error message?

 

 

 

 

 

TQ

[aiellomau]

Looks up,

It seems to be the

"java.util.Dte" (It missing the "a" between "D" and "te")

Find out where is this declaration and replace it with

"java,util.Date"