Jump to content
Changes to the Jaspersoft community edition download ×

why is iReport throwing me this error?


coltae

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
Share on other sites

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