Jump to content
Changes to the Jaspersoft community edition download ×

Error previewing older version reports


wkuruc_1

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.

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

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...