Error previewing older version reports

0

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

wkuruc_1's picture
Joined: Mar 15 2019 - 12:49pm
Last seen: 1 month 2 weeks ago

1 Answer:

0

You'll need to surround by double quotes. i.e. "$P!{pOrderBy}"

hozawa's picture
42197
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 days 7 hours ago
Feedback
randomness