Report on Change Log

[sacramentojoe]

Is there a way using Sugar, Zucker or Jasper reports to report off of the change log?

Sugar 4.51. pro with the latest patch.

[ftreml]

with ZuckerReports and JasperReports: yes.

[sacramentojoe]

Great, thank you.

[ftreml]

You have to enabled audit in the required module, and afterwards you have to join the "<module>_audit" table to your query (for example "accounts_audit", "contact_audit"). The audit-table contains the record identifier ("parent_id") as well as the changed field, the old value and the new value.

[maya]

Hi,I m using
MySQL Server : MySQL 5.0.38-Ubuntu_0ubuntu1.4-log
Port no : 3306
SugarCRM Version 5.0.0b
Operating System : Linux 2.6.20-15-generic
MySQL running on the same box as Sugar.
There is nothing special about Sugar /MySQL authentication
I have installed java-1.5.0-sun (JRE 5.0 ,JDK 5.0)
Here the procedure which i follow while loading module : Zucker Reports
1. From Module Loader I upload the zucker report zip file.
2. But there is no jasper folder in Zuckerreport module for that i copied jasper folder from zip file and after loading module i added it in zuckerreport module
3. Then Report and query template menu i select New JasperReports Template tab
filling the fields :Template name
Allowed formats : checked pdf format
Team name
use one *.jrxml file
Save it .
Run the report.
Afterwords it gives the error
Error :
Error while running Report cmdline: java -Djava.awt.headless=true -classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/Try.jasper_files/:modules/ZuckerReports/jasper/xml-apis.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar:modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:modules/ZuckerReports/jasper/servlet.jar:modules/ZuckerReports/jasper/jfreechart-1.0.0.jar:modules/ZuckerReports/jasper/xalan.jar:modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar:modules/ZuckerReports/jasper/bsh-2.0b4.jar:modules/ZuckerReports/jasper/jpa.jar:modules/ZuckerReports/jasper/saaj-api-1.3.jar:modules/ZuckerReports/jasper/commons-digester-1.7.jar:modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/ant-1.5.1.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar:modules/ZuckerReports/jasper/jaxen-1.1.1.jar:modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/jasperreports-2.0.1.jar:modules/ZuckerReports/jasper/jxl-2.6.jar:modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/commons-beanutils-1.7.jar:modules/ZuckerReports/jasper/groovy-all-1.0.jar:modules/ZuckerReports/jasper/antlr-2.7.5.jar:modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:modules/ZuckerReports/jasper/zuckerreports-1.0.jar" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/dae8e0d8-a059-54e1-005e-48282b619ccb/cmd.properties 2>&1
JasperBatchMain :: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2565)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at at.go_mobile.zuckerreports.JasperBatchMain.getConn ection(JasperBatchMain.java:216)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:91)
** END NESTED EXCEPTION **
Last packet sent to the server was 11 ms ago.
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2565)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at at.go_mobile.zuckerreports.JasperBatchMain.getConn ection(JasperBatchMain.java:216)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:91)
** END NESTED EXCEPTION **
Last packet sent to the server was 11 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2631)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at at.go_mobile.zuckerreports.JasperBatchMain.getConn ection(JasperBatchMain.java:216)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:91)

------------------------------------------------------------------------------------------------------------------------------
I have not installed irepert.
Is there necessary to install Tomcat server?
There is need to create DSN.
If yes then plz tell me how it will be done.
Thank u.

[sidh211]

Hiii all

i am also getting the same error can any one plss help i am using sugar 4.5.1i on windows xp with zucker reports 1.8 installed
but when i try to upload .jrxml file it gives the commnad line path error

regds

sid