wkuruc_1

I am using JasperReports 6.3.1 and trying to Preview report designed in version 5.5.0. In Preferences I've setup compatibility Source and Compiler to Version 5.5.0. What else am I missing in the setup? I'm getting the following error. net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: InventoryCountSheet. SELECT i.item_code, i.item_desc1, suom.uom_code, i.item_dimension_heigth, i.item_dimension_length, i.item_dimension_width, i.item_color, w.whse_desc, l.whseloc_bin_location, l.itemwhseloc_onhand_qty, iwci.count_quantity, iwci.batch_number FROM in_item_warehouse_count_items iwci INNER JOIN in_item i ON i.item_id = iwci.item_id $P!{pcountIDClause} INNER JOIN in_warehouse AS w ON w.whse_id = iwci.whse_id INNER JOIN in_item_warehouse AS iw ON i.item_id = iw.item_id AND iw.whse_id = w.whse_id LEFT OUTER JOIN sys_unit_of_measure suom ON suom.uom_id = i.item_standard_uom_id LEFT OUTER JOIN in_item_warehouse_location l ON l.itemwhseloc_id = iwci.itemwhseloc_id $P!{pOrgIDClause} ORDER BY iwci.batch_number $P!{pOrderBy} Error in last line : extraneous input '$P!{pOrderBy}' expecting EOF

That works, Thanks Walter

Thank You, that was very helpfull. Cheers, Walter

I can open the Report in Design, need to make modifications and compile it. Preview generates compiling errors. Compile button has only one option - Compatibility Configuration

I have lots of old reports designed in Jaspersoft iReport 5.5 and need to modify and use them in Jaspersoft Studio 6.6 Is there way to compile it ? Thanks, Walter