iReport or Custom Report Designer

[cruspy]

I need a custom report for Sugar and have Jasper installed. I've also installed iReport but am unsure how to move forward in linking with Sugar CRM and creating a report. Alternatively, does anyone know a low cost report designer?

[mcatling]

Hi you can use tools like

Pentaho; which is similar to Jasper.

Needs a bit of setup and need to access the SUgar Database directly. No predefined reports or Sugar models but it is a powerful tool..

I take a simple approach.... I use Open Office with the Sun report writer added as an extension.(This is based on the Pentahao tool). You can link OpenOffice database to the SugarCRM database through ODBC (use th especific MySQL driver option to get Database views)


You can put together quite sophisticated reports with this setup. I then run a scheduled job on WIndows to run a small command line script file "xxxx.cmd" which calls each report through the command line interface to OpenOffice.

You could also do this with Microsoft Access if you wanted.

Individual users would have to have direct access to the SugarCRM database if you wanted they to create or run reports (and if swcurity allows).

There are some instructions in the Zuckerreports module about how to create, integrate and run new iReport reports

Hope this helps.

[neo3matrix]

Hello Friends,
I have a problem and need your help.
I m writting a java class for jasper reports and i m getting error during compiling jrxml file by following code:-
JasperCompileManager.compileReport("//home//ubuntu//Reports//jaspertemplate.jrxml");
The error is:-
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.commons.collections.ArrayStack: method <init>(I)V not found

I have seen many posts on this and got answer as i should have proper versions of jars :-
commons-beanutils.jar
commons-collections.jar
commons-digester.jar
commons-logging.jar
jasper.jar

I tried many versions of above jars (compatible with each other , latest versions also) but didn't got answer for above error.

Also , one more thing is that ,
when i use FillManager for any .jasper file , using the code ,

JasperFillManager.fillReport("//home//ubuntu//Desktop//jasperexample.jasper",new HashMap<Object, Object>());
I got error , as ,
net.sf.jasperreports.engine.JRException: Error loading object from file : /home/ubuntu/Desktop/jasperexample.jasper

I have tried my code on both jdk 1.5 and 1.6 , but still not working.
Can you solve my problem , plz?