wkuruc_1 Posted April 8, 2019 Share Posted April 8, 2019 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_numberFROM 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 Link to comment Share on other sites More sharing options...
hozawa Posted April 8, 2019 Share Posted April 8, 2019 You'll need to surround by double quotes. i.e. "$P!{pOrderBy}" Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now