why is iReport throwing me this error?
Posted on September 24, 2015 at 10:59am
My report seems to compile just fine but after i enter the shipID: it prints me out this error on the iReport console:
Error filling print... Error preparing statement for executing the report query :
SELECT ship.id AS ShipID, ship.orderid AS OrderID, ship.ordertypeid AS OrderType
FROM ship
WHERE ship.id = ?
Does anyone have any idea why? or how i could fix this?
thank you
-Colt
Joined: Sep 15 2015 - 9:53am
Last seen: 7 years 5 months ago
Posted on September 27, 2015 at 8:20pm
The error is usually due to parameters not set up correctly or of the wrong type. You can check the parametres in your query for Ship.id and ensure it's in the correct format (should be something like 'where ship.id = $P{param name}' without quotes).
Joined: Sep 2 2015 - 3:09am
Last seen: 3 years 10 months ago
In your query designer thier is some error .
First directly pass the parameter value in the query and check the report.
if it works then pass the parmeter to the query as below
SELECT ship.id AS ShipID, ship.orderid AS OrderID, ship.ordertypeid AS OrderType
FROM ship
WHERE ship.id = $P{Parameter_name}
Thanks
B Rama Krishna