coltae Posted September 24, 2015 Share Posted September 24, 2015 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 OrderTypeFROM shipWHERE ship.id = ? Does anyone have any idea why? or how i could fix this? thank you -Colt Link to comment Share on other sites More sharing options...
RamaKrishna.B Posted September 25, 2015 Share Posted September 25, 2015 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 belowSELECT ship.id AS ShipID, ship.orderid AS OrderID, ship.ordertypeid AS OrderTypeFROM shipWHERE ship.id = $P{Parameter_name}ThanksB Rama Krishna Link to comment Share on other sites More sharing options...
zakuruchi Posted September 28, 2015 Share Posted September 28, 2015 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). 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