massi.b

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?

I'm using iReport 5.5.0. I would like to display images store as byte array in Postgres on my report. How can i do that?