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
