Error un using function $X{GREATER}, $X{BETWEEN}

ReportServer (EN)
1

Hi, everyone
When i try use functions $X{GREATER}, $X{BETWEEN} ReportServer show message “No clause function for id GREATER found”
In logs, error is on net.sf.jasperreports.engine.query.JRAbstractQueryExecuter
Cheking source exist JasperStyleParameterParser extending from JRAbstractQueryExecuter at the package net.datenwerke.rs.base.service.datasources.table.impl.utils

In this class is implemented methods for IN and NOT IN statements, but not for GREATER or BETWEEN

is Administration Guide incorrect ?

Regards

2

Hi Al3tz,

this is indeed a bug. Thanks for reporting this.

Cheers
-Arno

3

One way to work around this is to simply use standard SQL, e.g.,

WHERE ${param} > column

We have also already fixed this in the trunk. For support customers who need a patch release please raise a ticket in the support portal.

Cheers
-Arno