Help with zuckerReport

[RodolfoJesus]

Hello!

I'm having a little problem when I try to generate reports in ZuckerReport module.
I'm using iReport 3.6 to create the template and use ZuckerReport 1.11 to generate the report.
This is my query:

SELECT
a.codigo Codigo, a.canal Canal, a.status Status, a.sinal Sinal, a.tipo Tipo,
a.first_name Estacao, b.id, b.name Emissora, b.status em_Status, c.name Projeto,
d.name Cliente, COUNT(e.calix_estacx_estacoes_ida) Ocorrencias
FROM
calix_estacoes a
LEFT JOIN calix_emissoras b ON a.calix_emissora_id_c = b.id AND b.deleted=0
LEFT JOIN calix_projetos_gescom c ON a.project_id_c = c.id AND c.deleted=0
LEFT JOIN accounts d ON b.account_id_c = d.id AND d.deleted=0
LEFT JOIN calix_estacoes_cases_c e ON e.calix_estacx_estacoes_ida = a.id AND e.deleted=0
WHERE a.calix_emissora_id_c = $P{ID_EMISSORA} AND a.deleted = 0
GROUP BY a.codigo

I created these parameters in zuckerReport module:
Parameter Bindings

Friendly Name: ID_EMISSORA
Parameter Name: ID_EMISSORA
Selection: User-Defined Query


When I try to generate a report the following error appears:

Output

Error while running Report:

cmdline: java -Djava.awt.headless=true -classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/status_emissora.jasper_files/:modules/ZuckerReports/jasper/commons-vfs-1.0.jar:modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar:modules/ZuckerReports/jasper/rex-20080421.jar:modules/ZuckerReports/jasper/js_activation-1.1.jar:modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar:modules/ZuckerReports/jasper/barbecue-1.5-beta1.jar:modules/ZuckerReports/jasper/jcmdline-1.0.2.jar:modules/ZuckerReports/jasper/batik-awt-util.jar:modules/ZuckerReports/jasper/swingx-2007_05_13.jar:modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/commons-math-1.0.jar:modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/batik-gvt.jar:modules/ZuckerReports/jasper/jasperreports-extensions-1.3.1.jar:modules/ZuckerReports/jasper/looks-2.0-rc.jar:modules/ZuckerReports/jasper/batik-dom.jar:modules/ZuckerReports/jasper/mxmlc.jar:modules/ZuckerReports/jasper/commons-pool-1.3.jar:modules/ZuckerReports/jasper/xml-apis.jar:modules/ZuckerReports/jasper/js_axis-1.4patched.jar:modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/jfreechart-1.0.3.jar:modules/ZuckerReports/jasper/batik-ext.jar:modules/ZuckerReports/jasper/cincom-jr-xmla.jar:modules/ZuckerReports/jasper/jasperreports-flash-2.0.5.jar:modules/ZuckerReports/jasper/js_commons-discovery-0.2.jar:modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar:modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/ehcache-1.1.jar:modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/js_jaxrpc.jar:modules/ZuckerReports/jasper/eigenbase-xom.jar:modules/ZuckerReports/jasper/microba-0.4.1-bin.jar:modules/ZuckerReports/jasper/batik-anim.jar:modules/ZuckerReports/jasper/spring-hibernate3-2.0-m2.jar:modules/ZuckerReports/jasper/jasperreports-3.0.0.jar:modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/batik-parser.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:modules/ZuckerReports/jasper/javacup.jar:modules/ZuckerReports/jasper/cglib-2.1.jar:modules/ZuckerReports/jasper/batik-util.jar:modules/ZuckerReports/jasper/eigenbase-resgen.jar:modules/ZuckerReports/jasper/toniclf.jar:modules/ZuckerReports/jasper/asm-attrs.jar:modules/ZuckerReports/jasper/jpa.jar:modules/ZuckerReports/jasper/batik-svggen.jar:modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar:modules/ZuckerReports/jasper/xalan.jar:modules/ZuckerReports/jasper/jta.jar:modules/ZuckerReports/jasper/sqleonardo-2007.03.jar:modules/ZuckerReports/jasper/xml-apis-ext.jar:modules/ZuckerReports/jasper/asm.jar:modules/ZuckerReports/jasper/flexdock-0.4.1.jar:modules/ZuckerReports/jasper/spring-context-2.0-m2.jar:modules/ZuckerReports/jasper/batik-svg-dom.jar:modules/ZuckerReports/jasper/batik-css.jar:modules/ZuckerReports/jasper/mysql-connector-java-3.1.11-bin.jar:modules/ZuckerReports/jasper/commons-digester-1.7.jar:modules/ZuckerReports/jasper/antlr-2.7.5.jar:modules/ZuckerReports/jasper/iTextAsian.jar:modules/ZuckerReports/jasper/spring-2.0-m2.jar:modules/ZuckerReports/jasper/dom4j-1.6.jar:modules/ZuckerReports/jasper/groovy-all-1.5.5.jar:modules/ZuckerReports/jasper/commons-beanutils-1.7.jar:modules/ZuckerReports/jasper/batik-xml.jar:modules/ZuckerReports/jasper/nsisant-1.1.jar:modules/ZuckerReports/jasper/iReport.jar:modules/ZuckerReports/jasper/log4j-1.2.9.jar:modules/ZuckerReports/jasper/eigenbase-properties.jar:modules/ZuckerReports/jasper/js_mail-1.4.jar:modules/ZuckerReports/jasper/js_jasperserver-ireport-plugin-3.0.0.jar:modules/ZuckerReports/jasper/bsh-2.0b4.jar:modules/ZuckerReports/jasper/js_wsdl4j-1.5.1.jar:modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/batik-script.jar:modules/ZuckerReports/jasper/servlet.jar:modules/ZuckerReports/jasper/saaj-api-1.3.jar:modules/ZuckerReports/jasper/jaxen-1.1.1.jar:modules/ZuckerReports/jasper/mondrian-2.3.2.8944.jar:modules/ZuckerReports/jasper/js_jasperserver-common-ws-3.0.0.jar:modules/ZuckerReports/jasper/commons-httpclient-3.1.jar:modules/ZuckerReports/jasper/tinylaf.jar:modules/ZuckerReports/jasper/JasperBabylon-1.0.0.jar:modules/ZuckerReports/jasper/commons-dbcp-1.2.1.jar:modules/ZuckerReports/jasper/commons-codec-1.3.jar:modules/ZuckerReports/jasper/batik-bridge.jar:modules/ZuckerReports/jasper/jxl-2.6.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/7e10029a-5b50-3102-9e64-4b389706d9cc/cmd.properties 2>&1
JasperBatchMain :: loading jasper design modules/ZuckerReports/resources/status_emissora.jasper
JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => 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_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(ID_EMISSORA, java.lang.String) => 580a9d99-7ad5-5c13-c93c-49d60888c21b
JasperBatchMain :: Byte data not found at location : /home/calix/?rea de Trabalho/Relat?rios/company_logo.png
net.sf.jasperreports.engine.JRException: Byte data not found at location : /home/calix/?rea de Trabalho/Relat?rios/company_logo.png
at net.sf.jasperreports.engine.util.JRLoader.loadByte sFromLocation(JRLoader.java:482)
at net.sf.jasperreports.engine.JRImageRenderer.getIns tance(JRImageRenderer.java:177)
at net.sf.jasperreports.engine.fill.JRFillImage.evalu ateImage(JRFillImage.java:924)
at net.sf.jasperreports.engine.fill.JRFillImage.evalu ate(JRFillImage.java:871)
at net.sf.jasperreports.engine.fill.JRFillElementCont ainer.evaluate(JRFillElementContainer.java:275)
at net.sf.jasperreports.engine.fill.JRFillBand.evalua te(JRFillBand.java:426)
at net.sf.jasperreports.engine.fill.JRVerticalFiller. fillTitle(JRVerticalFiller.java:311)
at net.sf.jasperreports.engine.fill.JRVerticalFiller. fillReportStart(JRVerticalFiller.java:247)
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.fillRepo rt(JRFiller.java:63)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:126)

What could this causing this error?

[wsiedler]

Rodolfo,

As a first guess: Have your updated (on the server) the Jasper Reports files coming with ZuckerReports 1.11? IIRC, the included Jasper version is around 3.0. They might not understand the new JR version of iReports 3.6.0.

Regards,
Wolf

[wsiedler]

JasperBatchMain :: Byte data not found at location : /home/calix/?rea de Trabalho/Relat?rios/company_logo.png
net.sf.jasperreports.engine.JRException: Byte data not found at location : /home/calix/?rea de Trabalho/Relat?rios/company_logo.png

Second guess:
Do you have the the file "company_logo.png" in place on the server?

Third guess:
When working with images in iReports, I found that it inserts file name and path into the JRXML file. I run iReports on my workstation, which means of course that the path won't be available on the server. After storing in my workstation the image in the same directory as the jrxml file and eliminating the path from iReports, it worked.

Regards,
Wolf

[kuske]

I never got any iReport 3.6 report running on Zucker Reports.
I think iReport 3.6 has a completely redesigned environment.

So I used iReport 3.0 and had no problems.

In the readme.txt of Zucker Reports there is a hint how to run it with iReport 3.1.4, so I think this is the highest version you can use.

[wsiedler]

I never got any iReport 3.6 report running on Zucker Reports.

I am relatively new to iReports, but so far all my report templates work on later versions.

Right now, I am now using iReport 3.7.0 (3.6.0 worked before as well, 3.7.0 offers some font handling advantages to me) and used the ZuckerReports upgrade approach described by Marco Baumeler on Sept. 7, 2009 in the SugarForge forum:

If you want to use the latest versions of iReport and JasperReport (v 3.6 released
on 3. sept) just follow the same procedure indicated in the v1.11 readme:

Delete all jar files from the directory "modules\ZuckerReports\jasper", !!!except
"zuckerreports-1.0.jar"!!!

Copy the new jar files from your local iReport 3.6 installation
("ireport\modules\ext" and "ide8\modules\ext") to the directory
"modules\ZuckerReports\jasper.

Directory name "ide8" changed to "ide10" in iReport 3.7.0.

Regards,
Wolf

PS:
If you like to compare libraries/versions in modules/ZuckerReports/jasper/, let me know.

[kuske]

@wsiedler:

Would be nice if it would work.

I just installed iReport 3.7, did exactly what you described and...
the same issue as Rodolfo has!

What is the secret trick to run Zucker Reports an an XAMPP installation on WINXP with reports from iReport 3.7 ?

Any PATH? Any config.php setting?

[wsiedler]

What is the secret trick to run Zucker Reports an an XAMPP installation on WINXP with reports from iReport 3.7 ?

Harald, there is - honestly - no secret trick. At least as far as I know.

I did notice, however, one small difference: I run iReport on Linux (Fedora 11, to be precise), installed from the iReport zip file.

My server in running CentOS5 and Sun JDK 1.5.0_17.

Would you want to have an archive of directory modules/ZuckerReports/jasper from my server in its present state? If yes, please let me know a suitable email address by personal message.

Regards,
Wolf

[kuske]

OK, ok,

it's not my day today

I think the issue is a very simple one.

As you can see in the exception log the real problem is the following:

net.sf.jasperreports.engine.JRException: Byte data not found at location : /home/calix/?rea de Trabalho/Relat?rios/company_logo.png

I did exactly the same failure, I fogot to upload the image used in the iReport report.

If you load all images used in the report, it should run without exception...



Thank you @wsiedler for motivating to test ireport 3.7, it is really better to use than 3.0

[wsiedler]

If you load all images used in the report, it should run without exception

And I may add: Make sure the jrxml template does not contain any path references for the image. That spoiled the fun on some of my earlier attempts.

Thank you @wsiedler for motivating to test ireport 3.7, it is really better to use than 3.0

Glad I was at least able to provide some inspiration... ;-)

Regards,
Wolf

[kuske]

And I may add: Make sure the jrxml template does not contain any path references for the image. That spoiled the fun on some of my earlier attempts.

Ahhhhhhh, I knew there was a secret trick.....

Best whishes for the New Year