gervase

When you run the SQL directly against the DB (not in iReport) does that return the values you expect the report to? SELECT checkboxstate from checkboxtable WHERE checkboxname=='" + checkboxname + "' It looks like there may be something wrong with the single quotes ans SQL: checkboxname=='" + checkboxname + "'" Does it work with a single =

You can do this in your SQL: SELECT NVL(table.field, 'N/A') AS FIELDNAME, This will return the string 'N/A' when the field table.field is null. The check box blank when null will pretty much be useless because it will be handled in the SQL. If you wanted the field to be blank you can do that in the SQL by replacing 'N/A' with ' '

You might be able to do this in your SQL as a CASE statement: (CASE WHEN table.productcode is null THEN 'product name' ELSE table.productcode END) as PRODUCTCODE Does that sound feasible?

What is the exact error message jasper sends?

Can you add an image and link the image to a file in the Image Expression in the properties?

Can you check the size of your report? Does the data returned potentially go out of bounds from the band it is in? Try making the main report a lot larger to see if the sub report will fit inside it no matter what.

the problem was with the name of the parameter did not match the actual parameter

I'm having trouble using a parameter in a LIKE operator in my SQL. Basically I want to take what is entered in as the parameter and see if the value in the database is LIKE it. These do not seem to work: and o.SUPPLIERSHIPMENTID LIKE '%$P!{supplierShipmentId}%' and o.SUPPLIERSHIPMENTID LIKE '%' | $P{supplierShipmentId} | '%' and o.SUPPLIERSHIPMENTID LIKE '%$P{supplierShipmentId}%' This works with a hard coded value: and o.SUPPLIERSHIPMENTID LIKE '%2%'