jacky

Hi,slaisne,thanks for you reply,and I faced another puzzle,can you help me ? http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=19282&catid=8

OH,COME ON,EVERYONE,GIVE ME SOME ADVICE,THANKS A LOT.

when i set the the sql string as following code ,then run,i get an error----java.sql.SQLException: ORA-00937: éžå•ç»„分组函数.i know the reason is for the count(*).but who can help me out of it?thanks a lot defore hand. JRDesignQuery query = new JRDesignQuery(); sql = "select count(*) from res_info "; query.setText(sql);

slaisne wrote: Create a JRDesignBand and add element by using addElement() inherited from JRDesignElementGroupThank u very much slaisne . I almost finish my project.Great regards to you.Another request,where can I find some standard jrxml files? Thank you.

When I tried to create my own jrxml from code without using ireport,I met a question: how to add elements into band? Someone pls help me,thanks a lot.

slaisne wrote: Create a JasperDesign, add it JRBands and elements. After compile and export to pdfHello,slaisne. When I do as you said and the code is: JRDesignExpression expression1 = new JRDesignExpression(); JRDesignExpressionChunk expression_Chunk1 = new JRDesignExpressionChunk(); expression_Chunk1.setText("res_id"); group.setExpression(expression1); There poped an error: net.sf.jasperreports.engine.JRException: Report design not valid : 1. Class not set for group expression : res_id Can I get some help from you?Thanks a lot. ohoh,it is ok.it should be: expression1.addFieldChunk("res_id"); expression1.setValueClass(java.math.BigDecimal.class); then it works. Post edited by: jacky, at: 2006/12/11 06:17

slaisne wrote: Create a JasperDesign, add it JRBands and elements. After compile and export to pdfslaisne,thank you a lot.I will try then.

Hello,everyone,I want to create a jrxml from programming without using iReport.Now,What can I do?What classes in the jasperReport jar can I use?Thanks to any reply.Best regards.

I got it. they are "background, bottomMargin, columnCount, columnFooter, columnHeader, columnSpacing, columnWidth, datasets, defaultFont, defaultStyle, detail, fonts, ignorePagination, importsSet, isFloatColumnFooter, isSummaryNewPage, isTitleNewPage, language, lastPageFooter, leftMargin, mainDataset, name, orientation, pageFooter, pageHeader, pageHeight, pageWidth, printOrder, rightMargin, styles, summary, title, topMargin, whenNoDataType" are they? but i change the value of the key of 'title' then put it into the map ,output the html file but finally the html page has not any change.why?who can tell me?thanks Post edited by: jacky, at: 2006/11/07 06:51

I have a question about the keys of "(Map) parameters" in the mothod "JasperFillManager.fillReport(jasperReport, parameters, conn);" if the keys are reserved?what are they ?thanks a lot.

YES. It works now when I copied the jars from jasperreport sample lib to my project lib.

try generate your jrxml by using the ireport.and you'd better post your jrxml.

it seems your classpath is lack of some jars

and the .java is: package jasperReport; import java.util.HashMap; import net.sf.jasperreports.engine.JREmptyDataSource; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import org.apache.commons.digester.Digester.*; public class compileJrxml { public static void main(String[] args) { JasperReport jasperReport; JasperPrint jasperPrint; String xmlFileName = "D:/jasperreport/jasperreports-1.2.7-project/jasperreports-1.2.7/demo/samples/horizontal/HorizontalReport.jrxml"; String srcDirName = "D:/jasperreport/jasperreports-1.2.7-project/jasperreports-1.2.7/demo/samples/horizontal/"; try { jasperReport = JasperCompileManager.compileReport(xmlFileName); jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(), new JREmptyDataSource()); JasperExportManager.exportReportToPdfFile(jasperPrint, srcDirName); } catch (JRException e) { e.printStackTrace(); } } }

I got an error when i compiled the .jrxml: log4j:WARN No appenders could be found for logger (org.apache.commons.digester.Digester). log4j:WARN Please initialize the log4j system properly. org.xml.sax.SAXParseException: URI was not reported to parser for entity [document] at gnu.xml.aelfred2.SAXDriver.warn(SAXDriver.java:934) at gnu.xml.aelfred2.SAXDriver.startExternalEntity(SAXDriver.java:631) at gnu.xml.aelfred2.XmlParser.pushURL(XmlParser.java:3358) at gnu.xml.aelfred2.XmlParser.doParse(XmlParser.java:159) at gnu.xml.aelfred2.SAXDriver.parse(SAXDriver.java:320) at gnu.xml.aelfred2.XmlReader.parse(XmlReader.java:294) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:142) at jasperReport.compileJrxml.main(compileJrxml.java:32) NESTED BY : org.xml.sax.SAXParseException: URI was not reported to parser for entity [document] at gnu.xml.aelfred2.SAXDriver.warn(SAXDriver.java:934) at gnu.xml.aelfred2.SAXDriver.startExternalEntity(SAXDriver.java:631) at gnu.xml.aelfred2.XmlParser.pushURL(XmlParser.java:3358) at gnu.xml.aelfred2.XmlParser.doParse(XmlParser.java:159) at gnu.xml.aelfred2.SAXDriver.parse(SAXDriver.java:320) at gnu.xml.aelfred2.XmlReader.parse(XmlReader.java:294) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:142) at jasperReport.compileJrxml.main(compileJrxml.java:32) :( what's the reason?pls help me and thanks a lot.