ReportServer Forum

Al3tz

Member

Registered: 2015-04-04

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

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

Arno Mittelbach

datenwerke

Registered: 2012-02-14

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

Hi Al3tz,

this is indeed a bug. Thanks for reporting this.

Cheers
-Arno

Arno Mittelbach

datenwerke

Registered: 2012-02-14

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

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