iDempiere

Jasper Studio: JAVA Compatibility

Posted on

We user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance  We have an iDempiere ERP Instance Running (same fork root as Openbravo). The Jasper Studio is used to configure the reports and compile them, the problem is […]

Jasper Reports

JasperServer: Start Server on Boot

Posted on

This is an excellent post, which not only shows you how to solve the startup problem, but illustrate the use of startup scripts. http://community.jaspersoft.com/questions/541044/auto-start-boot   Key Points. To creste "service type" scripts you need to create the bash script on /etc/init.d/NAME_OF_SCRIPT To have this script run on server boot, you need to run update-rc.d NAME_OF_SCRIPT defaults […]

Jasper Reports

Best BI Software

Posted on

JasperSoft Pentaho Watson Analytics *** Very Poor (even cancelled the trial) *** Microsoft Power BI AWS Quick Sight *** Still on Trial *** DELL - Boomi *** No Trial that I was Able to see ***   SQL Graphs review from Quora...   Chartio : for the data-consuming portion of the company.  Most of our small […]

Jasper Reports

JAVA: Compare Boolean Vale

Posted on

I require this to limit the Print when Expression Field on Jasper Studio. I had some trouble getting the comparison formule, because I used the typical: $F{rfq_c} == "VALUE" This formula did not work because it only applies when comparing strings. After a lot of trial and error the correct formula would be: new Boolean($F{rfq_c}.booleanValue() […]

Jasper Reports

JasperReports: Timeouts in Server

Posted on

Session timeouts dictate how long a user is allowed to be inactive before being automatically logged out of JasperReports Server. Tomcat Edit <tomcat>\webapps\jasperserver-pro\WEB-INF\web.xml and change the sesssion-timeout. The default is 20 minutes. <session-config> <session-timeout>20</session-timeout> </session-config> Restart the application server to make the setting take effect.

Jasper Reports

PgSql: Cannot use Extract function inside a Where Clause

Posted on

For Exmple:   AND (date_part('YEAR',fin_finacc_transaction.statementdate) = $P{Año}) or AND ((extract(Year from  fin_finacc_transaction.statementdate) LIKE $P{Año}) OR $P{Año} = 'ALL') Neither of these work, I guess it has something to do with the Parameter type, as it works when I use a number instead of the Parameter. See error Log. net.sf.jasperreports.engine.JRException: Error executing SQL statement for : […]

Jasper Reports

Jasper Reports: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Posted on

https://community.jaspersoft.com/questions/542137/where-put-jdbc-driver-jars-or-add-path Thanks for the reply. I missed the "Driver Classpath" tab in the Data Adapter dialog. Obvious really! It would still be useful to add the driver to the classpath so it is always available. The only thing I could find which looks anything like the standard Eclipse way was in Preferences as I mentioned […]

Jasper Reports

JasperServer: Backup Strategy

Posted on

http://it.toolbox.com/blogs/rajasekar/export-and-import-utility-in-jasper-server-33190 http://community.jaspersoft.com/wiki/how-backup-your-jasperreports-server-prepare-upgrade   Export Reports sudo ./js-export.sh --everything  --output-zip backup_reportes.zip

Jasper Reports

JasperReports: Server Automatic Start

Posted on

Souce: http://community.jaspersoft.com/questions/541044/auto-start-boot   Those scripts won't work as supplied as the paths are all wrong, and the bundle doesn't include apache anyway (it's supplied by the OS). Since jasper does have a functional control script, I've rewritten the control script to use it and match the paths used by the install bundle, saved it at /etc/init.d/jasperserver and given […]

Jasper Reports

JasperReports: Configure Datasource on Server

Posted on

1. Check if you have all the database connectors installed On my case, I did not have the MySQL connector installed (com.mysql.jdbc.driver) 1.1. Download Connector This connector can be downloaded from the official MySQL website http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.25.zip/from/http://cdn.mysql.com/   1.2. Copy Connector to Following Folder /opt/jasperreports-server-cp-5.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/lib   1.3. Confiure JasperServer's DataSource 1.3.1. For SugarCRM Database Type: JDBC […]

Jasper Reports

JasperReports: Same File for Server and Desktop

Posted on

http://stackoverflow.com/questions/7413216/linking-subreports-in-ireport-so-they-also-work-in-jasper-server   The best solution to this is to add an additional parameter like $P{IsOnServer}. Set the default value to true. For your subreport expression use this: $P{IsOnServer} ? "repo:mySubReport.jrxml" : "/local/path/to/mySubReport.jasper" When you run the report in iReport, you'll be prompted for the value of IsOnServer. Make it false; the subreport expression will resolve to your […]

Jasper Reports

JasperReports: Email Configuration (GMAIL)

Posted on

1.1. Edit js.quartz.properties sudo vim /opt/jasperreports-server-cp-5.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties report.scheduler.mail.sender.host=smtp.gmail.com report.scheduler.mail.sender.username=username@gmail.com report.scheduler.mail.sender.password=s3cr3t report.scheduler.mail.sender.from=username@gmail.com report.scheduler.mail.sender.protocol=smtps report.scheduler.mail.sender.port=465 1.2. Edit "applicationContext-report-scheduling.xml"   sudo vim /opt/jasperreports-server-cp-5.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/applicationContext-report-scheduling.xml   Add the following Lines to the Code. <prop key="mail.smtps.auth">true</prop> <prop key="mail.smtps.starttls.enable">true</prop> As seen below:   <bean id="reportSchedulerMailSender"> <property name="host" value="${report.scheduler.mail.sender.host}"/> <property name="username" value="${report.scheduler.mail.sender.username}"/> <property name="password" value="${report.scheduler.mail.sender.password}"/> <property name="protocol" value="${report.scheduler.mail.sender.protocol}"/> <property name="port" value="${report.scheduler.mail.sender.port}"/> <property name="javaMailProperties"> <props> […]

Jasper Reports

JasperReports: Installation

Posted on

INSTALATION PROCESS 1. INSTALL JAVA sudo apt-get install openjdk-6-jdk 1.1. SETUP JAVA_HOME sudo vim /etc/profile Add the following code to the profile JAVA_HOME=/usr/lib/jvm/java-6-openjdk-amd64 export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH export PATH 1.2. Reboot the Server 1.3. Check if JAVA_HOME has been successfully setup. echo $JAVA_HOME   2. INSTALL MAVEN sudo apt-get install maven 2.1. Check if Installation has […]