Jump to content
Changes to the Jaspersoft community edition download ×

Error previewing older version reports


Recommended Posts

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.

    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
    iwci.batch_number  $P!{pOrderBy}

Error in last line :  extraneous input '$P!{pOrderBy}' expecting EOF

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...