csabee csabee - 1 year ago 237
Java Question

JasperReports: CONCATENATE function not found

I'm developing some reports with Jaspersoft Studio.

I have a web app that should accept REST queries, and turn them into compiled reports.

So I have some of the JasperReports jars included:

  • groovy-all-2.0.1.jar

  • iText-2.1.7.js2.jar

  • jasperreports-5.2.0.jar

Problem is that when I compile my report and run from the Jaspersoft Studio, it works fine.

But when I compile and run it from my web app, it throws the exception:

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
Source text : CONCATENATE($V{startString}, " - ", $V{endString})
at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:244)
at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591)
at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559)
Caused by: net.sf.jasperreports.engine.JRRuntimeException: Function CONCATENATE not found

When I change my
call in the report it works fine.

So this leaves me with a solution that I'm missing one of the JasperReports jars, but which one?

Answer Source

You should also add jasperreports-functions-5.2.0.jar to your classpath.

This library contains net.sf.jasperreports.functions.standard.TextFunctions class with CONCATENATE function.

You can find this artifact at http://jaspersoft.artifactoryonline.com/jaspersoft/jr-ce-releases Maven repository.

The snippet from my test pom.xml:




The net.sf.jasperreports.jasperreports-functions:5.2.0 artifact depends on joda-time.joda-time:2.1 artifact - you should also add to classpath the joda-time-2.1.jar


You can find more information in Custom Functions in Report Expressions article