mark84

this forum is literaly dead :huh:

I m trying to make a pie chart of phone brands. I have a sql phone table with say col brand and models. Now i want to show the no phones that each brand has. I have done everything correctly and the chart shows fine but it shows repeadedly in 29 PAGES!! I just want it to be shown for 1 once on 1 page. How can i corrent this ? To tell you the details, Sql query: SELECT brand FROM phone 1 group variable created: Name: brandgrpValue Expr: $F{brand} 1 varaible created: Name: total Class type: java.lang.Integer Calc Type: Count Reset Type: brandgrp Value Expr: $F{brand} In chart: Key Expr: $F{brand} Value Expr: $V{total} Please help.

Anyone ? Still looking for a olution with no luck so far. Someone should be able to help ? btw, i'm using WinXP.

Hi everyone, I need some immediate help, been trying to sort this for the last 8 hrs, still no luck. I'm using iReport 1.3.0 with jasperreports-1.3.0_2.jar. The jasperreports-1.3.0_2.jar is copied to, C:Program FilesJavajdk1.5.0_06jrelibext, C:Program FilesJavajre1.5.0_06libext In iReport CLASSPATH (Options -> Classpath) i added (saved)only one jar that is mysql-connector-java-5.0.3-bin.jar which is in C:Program FilesJavajdk1.5.0_06jrelibext And I have set the Data-> Connection/Datasources with my mysql database information and tested it. It was sucessful and saved. Then I used the iReport wizard to create a simple report with a simple sql query and i get this error when i try to complie :- Error compiling the report Java source. java.lang.NoClassDefFoundError: org/apache/log4j/Layout at org.apache.commons.logging.impl.Log4jFactory.getInstance(Log4jFactory.java:153) at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:285) at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:409) at org.apache.commons.digester.Digester.<init>(Digester.java:304) at net.sf.jasperreports.engine.xml.JRXmlDigester.<init>(JRXmlDigester.java:62) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:953) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:202) 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.compileReportToFile(JasperCompileManager.java:107) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:529) at java.lang.Thread.run(Unknown Source) Compilation running time: 62 I tried but couuld solve this erro on my own ? I even tried adding ALL jars in ext/lib/ to iReport classpath. No luck. Any help is greatly appereciated. Thank you.Post edited by: mark84, at: 2007/02/21 09:00