ZuckerReport on Sugar 4.5.1

[mviret]

Hi all,

I have a problem with the ZuckerReport inplementation's. The module is correctly installed and run it but when I want to generate a Jasper report I receive systematically this error :

************************************************** ************************************************** *****************

Output


Error while running Report cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/_files/;modules/ZuckerReports/jasper/antlr-2.7.5H3.jar;modules/ZuckerReports/jasper/asm-attrs.jar;modules/ZuckerReports/jasper/asm.jar;modules/ZuckerReports/jasper/barbecue-1.1.jar;modules/ZuckerReports/jasper/bsh-1.3.0.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/classes12_01.jar;modules/ZuckerReports/jasper/commons-beanutils-1.5.jar;modules/ZuckerReports/jasper/commons-collections-2.1.jar;modules/ZuckerReports/jasper/commons-digester-1.7.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/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/groovy-all-1.0-beta-10.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.7.1.jar;modules/ZuckerReports/jasper/itext-1.3.1.jar;modules/ZuckerReports/jasper/jasperreports-1.2.2.jar;modules/ZuckerReports/jasper/jcmdline-1.0.2.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler.jar;modules/ZuckerReports/jasper/jfreechart-1.0.0.jar;modules/ZuckerReports/jasper/jr-bsh-compiler.jar;modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl.jar;modules/ZuckerReports/jasper/log4j-1.2.8.jar;modules/ZuckerReports/jasper/looks-2.0-rc.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar;modules/ZuckerReports/jasper/mysql_comp.jar;modules/ZuckerReports/jasper/nsisant-1.1.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-2.0-final-20040126.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.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/91091433-24bc-2adb-cc44-470e1e55bba0/cmd.properties 2>&1
JasperBatchMain :: compiling jasper design modules/ZuckerReports/resources/
JasperBatchMain :: modules\ZuckerReports\resources (Access is denied)
java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:166)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:111)

NESTED BY :
java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:166)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:111)

NESTED BY :
net.sf.jasperreports.engine.JRException: modules\ZuckerReports\resources (Access is denied)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:171)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:111)
Caused by: java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:166)
... 3 more

************************************************** ************************************************** *****************

Somebody has a good ideas ?

I run on this configuration :

Win XP
Sugar 4.5.1e
PHP 5.2.4
Apache 2.2.4

Thanks in advance for your help


And the twice question is : I want to make a report on Excel with 2D graphical solution. It's possible with Jasper ? And What is the solution if I can ?

[kbrill]

I think you might be more successful asking this on his website.It kinda looks like you do not have your Java runtimes installed correctly tho.

[Pdor]

Try to install ireport version 3.0.0.

Bye

[karimEgypt]

you must do 2 things

1)in the config file inside zuckerReportsFolder u will find this set of lines

// Enter the path to your java executable here, if autodetection doesn't work

//Windows Environment Default
"java_cmdline" => "D:\jdkSetup\bin\javaw.exe",

in the last line u must remove the comment from that line
and write the path of the executable java file

2) the path of the executable java file mustn't have spaces

after this every thing will be good

[karimEgypt]

you must do 3 things

1)in the config file inside zuckerReportsFolder u will find this set of lines

// Enter the path to your java executable here, if autodetection doesn't work

//Windows Environment Default
"java_cmdline" => "D:\jdkSetup\bin\javaw.exe %ARGS% 2>&1",

in the last line u must remove the comment from that line
and write the path of the executable java file

2) the path of the executable java file mustn't have spaces

3)download the new version of jar files which found in the jasper folder
specially
iText-2.1.5.jar
jasperreports-3.1.3.jar
poi-3.2-FINAL-20081019.jar
after this every thing will be good