Ireport parameter

I'm using iReport 5.5.0 to create a report. I'm using a parameter with parameter class set to 'java.lang.String' with a default value expression. I would like to integrate it to my SQL query.
 
Bellow my query:
 
SELECT * FROM table WHERE product."code" ILIKE '$P!{parameter}'
 
Preview does not work and i get a error.
 
Also I tried to use the parameter wihtout the exclamation sign (!) and without quote ' but it still doesn't work at all
 
Can you help me?
massi.b's picture
Joined: Dec 16 2013 - 2:33am
Last seen: 9 years 2 months ago

0 Answers:

No answers yet
Feedback
randomness