anisbet

So, no one has any ideas at all on how I can get this to work????

Hi, I am trying to add a pie chart to a report I am writing and have run into some problems. Basically I want the pie chart to show a summary of the items displayed in the report(i.e. I have 30 items with one of four possible settings, The pie chart would list out how many of each setting there are, and the report itself would list all 30 items). adding the count and group statements to my main query obviously wouldn't work, as the full list wouldn't be returned, but setting up a separate subdata set using a new query with count statement doesn't work either. does anyone have any ideas on how I should approach this problem? Thanks!!

Hello all, I am having some problems getting a report uploaded to ZukcerReprots. I am designing the report templates using I-Report and that all seems to work fine, but when I try and upload the template to ZuckerReports I get the following Code: error compiling report COE_by_account.jrxml - cmdline: java -Djava.awt.headless=true -classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/COE_by_account.jasper_files/:modules/ZuckerReports/jasper/antlr-2.7.5.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/jasperreports-2.0.1.jar:modules/ZuckerReports/jasper/jpa.jar:modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar:modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/saaj-api-1.3.jar:modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/servlet.jar:modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:modules/ZuckerReports/jasper/commons-digester-1.7.jar:modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/xalan.jar:modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/groovy-all-1.0.jar:modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar:modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/jxl-2.6.jar:modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:modules/ZuckerReports/jasper/jaxen-1.1.1.jar:modules/ZuckerReports/jasper/jfreechart-1.0.0.jar:modules/ZuckerReports/jasper/xml-apis.jar:modules/ZuckerReports/jasper/commons-beanutils-1.7.jar:modules/ZuckerReports/jasper/ant-1.5.1.jar:modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:modules/ZuckerReports/jasper/bsh-2.0b4.jar:modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar" at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpBAr6op modules/ZuckerReports/resources/COE_by_account.jasper 2>&1 JasperBatchMain :: compiling jasper design /tmp/phpBAr6op to modules/ZuckerReports/resources/COE_by_account.jasper Apr 10, 2008 10:04:26 PM org.apache.commons.digester.Digester startElement SEVERE: Begin event threw exception java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:49) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) at org.apache.commons.digester.Digester.startElement(Digester.java:1361) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:168) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:151) at at.go_mobile.zuckerreports.JasperCompileMain.main(JasperCompileMain.java:17) JasperBatchMain :: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle net.sf.jasperreports.engine.JRException: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:168) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:151) at at.go_mobile.zuckerreports.JasperCompileMain.main(JasperCompileMain.java:17) Caused by: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.startElement(Digester.java:1364) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239) ... 6 more It seems that adding frames to the report is what is causing this. I am using IReport 2.0.5, ZuckerReports 1.8 and SugarCRM CE Version 5.0.0b (Build 3150) Any one have any ideas what might be causing this? Thanks