Unexpected token while compiling JasperReport's jrxml

Classic Servoy
1

Hi,

I am experiencing a problem while compiling a jrxml with a column name having a dollar ($) sign. I guess this sign is a keyword of Jasper Report to represent a variable. In the case of servoy, dollar sign is used for naming Relations due to certain coding convention. There is a conflict in the usage of the sign so when I try to compile the following error is displayed:

net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, my_jrxml_001_1283497414671_244426: 46: unexpected token: field_object_to_object46object_to_object @ line 46, column 25. 1 error
at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:88)
at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
…

Does Servoy have a way to handle this or should we just change all our Relations with dollar($) sign to a certain keyword?

2

Erikd,

You need to check if there is some dollar-escaping in the jrxml-format possible.
Try orders$$order_lines or orders$order_lines or orders\$order_lines.
If that works, the jasper_reports plugin just receives the relation name with the $ sign.

If that does not work how could the servoy jasper report plugin get to the correct relation name?
Do some renaming (convert orders!order_line to orders$order_lines)?
That looks ugly.

Rob

3

rgansevles:
Try orders$$order_lines or orders$order_lines or orders\$order_lines.

The escape characters above didn’t work. I am still looking for a possible escape character because it’s better than changing the Relation name.

Does anybody know how to bypass $-dollar sign processing? My code should be something like the syntax below:

But I know the above statements don’t work because property “name” should be inside the field element.

I hope Servoy has something like a conversion tool for this so that we need not to change our Relation names.

Thanks.