problem with $ sign in field name

[sisosuwar]

Hi,

I get an error when I create a report where there's a $ sign in field name.

For example, report query is "select t$name from test".

And the report field is $F{T$NAME}.

When I compile it, error message is

"SyntaxÂerrorÂonÂtokenÂ"$F",ÂAssignmentOperatorÂexpectedÂafterÂthisÂtoken

ÂvalueÂ=Â(java.lang.String)($F{T$NAME});"

I use escape character but still have the problem.

I use iReport for creating a report.

My ERP vendor use $ sign for field name in all table.

What should I do to solve the problem?

Thanks and regards,

 

sis

[Teodor Danciu]

Hi,

 

You could use column aliases in the SELECT query to rename fields.

Or you could reference columns in the result set by their index by naming your fields COLUMN_1, COLUMN_2, COLUMN_X.

 

I hope this helps.

Teodor

[sisosuwar]

Hi,

You're right. It works when I use column alias.

Thanks a lot for your help.

Regards,

 

sis