tibco – jasper reports – ricardo malla's blog

August 19, 2018idempiere, java, openbravo, tibco - jasper reports

jasper reports: java compatibility

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). […]

May 27, 2017May 27, 2017tibco - jasper reports

jasper reports: start server on boot

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 […]

October 30, 2016November 1, 2016tibco - jasper reports

best bi software

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 […]

October 19, 2015October 19, 2015tibco - jasper reports

jasper reports: api configuration

http://192.168.1.220:8080/jasperserver/rest_v2/reports/reports/MG/Compras/Compras_Fabricantes_Notes.pdf?Fabricante=3M

October 17, 2015August 3, 2016java, tibco - jasper reports

java: compare boolean vale

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 […]

July 30, 2015tibco - jasper reports

jasperreports: timeouts in server

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 […]

July 21, 2015postgresql, tibco - jasper reports

pgsql: cannot use extract function inside a where clause

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 […]

January 2, 2015tibco - jasper reports

jasper reports: java.lang.classnotfoundexception: com.mysql.jdbc.driver

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 […]

November 4, 2014May 22, 2016backup strategies, tibco - jasper reports

jasper reports: backup all reports

cd /opt/jasperreports-server-cp-5.6.1/buildomatic ./js-export.sh –everything /public –output-zip backup.zip

May 18, 2014May 18, 2014tibco - jasper reports

jasper reports: backup strategy

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