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