Creating new ZuckerReport with jrxml template not working

[jlabuelo]

Hi all

I am having a problem with a jrxml report I have created for my ZuckerReport module I have installed on my SugarCRM 5.2i version running over Windows.

I have designed the iReport and produced the jrxml file correctly, and if I run it in IReport works fine. I can introduce the value of the parameters and get the pdf file with the results, no problem. (IReport Version is 3.6.1).

Now I would like to import the jrxml file I have designed to my SugarCRM system using the ZuckerReport Module I have installed on it (Version 1.9). I have done it as I did before with other reports, in the ZuckerReport Screen --Report and Query Templates,
a) I select new JasperReports Template

b) Introduce the name, jrxml file and pictures I use

c) Save it

d) Then I edit the report template and bind the parameters I have already created.

e) I try to Execute the report introducing the values of the parameters and I get this error message:

cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/Incidencia Ventas-Visitas.jasper_files/;modules/ZuckerReports/jasper/antlr-2.7.5.jar;modules/ZuckerReports/jasper/asm-attrs.jar;modules/ZuckerReports/jasper/asm.jar;modules/ZuckerReports/jasper/barbecue-1.5-beta1.jar;modules/ZuckerReports/jasper/batik-anim.jar;modules/ZuckerReports/jasper/batik-awt-util.jar;modules/ZuckerReports/jasper/batik-bridge.jar;modules/ZuckerReports/jasper/batik-css.jar;modules/ZuckerReports/jasper/batik-dom.jar;modules/ZuckerReports/jasper/batik-ext.jar;modules/ZuckerReports/jasper/batik-gvt.jar;modules/ZuckerReports/jasper/batik-parser.jar;modules/ZuckerReports/jasper/batik-script.jar;modules/ZuckerReports/jasper/batik-svg-dom.jar;modules/ZuckerReports/jasper/batik-svggen.jar;modules/ZuckerReports/jasper/batik-util.jar;modules/ZuckerReports/jasper/batik-xml.jar;modules/ZuckerReports/jasper/bsh-2.0b4.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/cincom-jr-xmla.jar;modules/ZuckerReports/jasper/commons-beanutils-1.7.jar;modules/ZuckerReports/jasper/commons-codec-1.3.jar;modules/ZuckerReports/jasper/commons-collections-2.1.jar;modules/ZuckerReports/jasper/commons-dbcp-1.2.1.jar;modules/ZuckerReports/jasper/commons-digester-1.7.jar;modules/ZuckerReports/jasper/commons-httpclient-3.1.jar;modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;modules/ZuckerReports/jasper/commons-logging-1.0.2.jar;modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar;modules/ZuckerReports/jasper/commons-math-1.0.jar;modules/ZuckerReports/jasper/commons-pool-1.3.jar;modules/ZuckerReports/jasper/commons-vfs-1.0.jar;modules/ZuckerReports/jasper/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/eigenbase-properties.jar;modules/ZuckerReports/jasper/eigenbase-resgen.jar;modules/ZuckerReports/jasper/eigenbase-xom.jar;modules/ZuckerReports/jasper/flexdock-0.4.1.jar;modules/ZuckerReports/jasper/groovy-all-1.5.5.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.7.1.jar;modules/ZuckerReports/jasper/iReport.jar;modules/ZuckerReports/jasper/itext-1.3.1.jar;modules/ZuckerReports/jasper/iTextAsian.jar;modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar;modules/ZuckerReports/jasper/JasperBabylon-1.0.0.jar;modules/ZuckerReports/jasper/jasperreports-3.0.0.jar;modules/ZuckerReports/jasper/jasperreports-extensions-1.3.1.jar;modules/ZuckerReports/jasper/jasperreports-flash-2.0.5.jar;modules/ZuckerReports/jasper/javacup.jar;modules/ZuckerReports/jasper/jaxen-1.1.1.jar;modules/ZuckerReports/jasper/jcmdline-1.0.2.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar;modules/ZuckerReports/jasper/jfreechart-1.0.3.jar;modules/ZuckerReports/jasper/jpa.jar;modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar;modules/ZuckerReports/jasper/js_activation-1.1.jar;modules/ZuckerReports/jasper/js_axis-1.4patched.jar;modules/ZuckerReports/jasper/js_commons-discovery-0.2.jar;modules/ZuckerReports/jasper/js_jasperserver-common-ws-3.0.0.jar;modules/ZuckerReports/jasper/js_jasperserver-ireport-plugin-3.0.0.jar;modules/ZuckerReports/jasper/js_jaxrpc.jar;modules/ZuckerReports/jasper/js_mail-1.4.jar;modules/ZuckerReports/jasper/js_wsdl4j-1.5.1.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl-2.6.jar;modules/ZuckerReports/jasper/log4j-1.2.9.jar;modules/ZuckerReports/jasper/looks-2.0-rc.jar;modules/ZuckerReports/jasper/microba-0.4.1-bin.jar;modules/ZuckerReports/jasper/mondrian-2.3.2.8944.jar;modules/ZuckerReports/jasper/mxmlc.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.11-bin.jar;modules/ZuckerReports/jasper/nsisant-1.1.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar;modules/ZuckerReports/jasper/rex-20080421.jar;modules/ZuckerReports/jasper/saaj-api-1.3.jar;modules/ZuckerReports/jasper/servlet.jar;modules/ZuckerReports/jasper/spring-2.0-m2.jar;modules/ZuckerReports/jasper/spring-context-2.0-m2.jar;modules/ZuckerReports/jasper/spring-hibernate3-2.0-m2.jar;modules/ZuckerReports/jasper/sqleonardo-2007.03.jar;modules/ZuckerReports/jasper/swingx-2007_05_13.jar;modules/ZuckerReports/jasper/tinylaf.jar;modules/ZuckerReports/jasper/toniclf.jar;modules/ZuckerReports/jasper/xalan.jar;modules/ZuckerReports/jasper/xercesImpl.jar;modules/ZuckerReports/jasper/xml-apis-ext.jar;modules/ZuckerReports/jasper/xml-apis.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar;" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/b695e903-ed2f-0f34-0fbc-4b6bf5f3b5cb/cmd.properties 2>&1
JasperBatchMain :: loading jasper design modules/ZuckerReports/resources/Incidencia Ventas-Visitas.jasper
JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null
JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
JasperBatchMain :: getParameterValue(User, java.lang.String) => VentasNorte
JasperBatchMain :: getParameterValue(FechaIni, java.util.Date) => Fri Jan 01 00:00:00 CET 2010
JasperBatchMain :: getParameterValue(FechaFin, java.util.Date) => Sun Feb 28 00:00:00 CET 2010
Exception in thread "main" java.lang.IllegalArgumentException: Null 'key' argument.
at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:234)
at org.jfree.data.general.DefaultPieDataset.setValue(DefaultPieDataset.java:199)
at net.sf.jasperreports.charts.fill.JRFillPieDataset.customIncrement(JRFillPieDataset.java:159)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:782)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at at.go_mobile.zuckerreports.JasperBatchMain.main(JasperBatchMain.java:126)

It is strange because error refers to a Key parameter being null.

Dont know exactly why the report does not work now in SugarCRM, when in IReport works fine and I introduce the same values for parameters "User","FechaIn","FechaFin".

Also another thing I noticed is that if the query of the report returns no values, then PDF appears blank.... so dont know if it is a problem of the MySQL configuration, ZuckerReports???......


Any ideas what I am doing wrong? I just create reports from long time to long time... so dont understand why this does not work now.

(Also error happens with other reports previously created and which worked fine)

Thanks a lot

[salesagility]

The best place for Zucker support is the zucker forums on sugarforge .. active and helpful forum

[jlabuelo]

Thanks a lot, did not know about it. Will take a look at it now... but in any case if you see my error like a normal error easy to solve, I would appreciate if you could pass me some info about how to solve it

Thanks again

[salesagility]

I would have offered any suggestions if I had any ...