Jump to content
We've recently updated our Privacy Statement, available here ×

iReport problem query fetch only one record


fala70

Recommended Posts

Hi,

I am beginner of iReport, but I think that is a bug. I've done a mysql connection with JDBC, the connection work. I done a simple report with a simple query "select * from table_name", and I placed few fields into details section. When I see the preview report I see only one record detail but table has many records. I see also that into window  Report Query, if I click on "Refresh Preview Data" Button with "All" option selected, in below list only one record is showed. Instead if I select "First 100 records" and then click on  "Refresh Preview Data" Button, an error is showed: "Error  net.sf.jasperreports.engine.JRException:"Erro executing SQL statment for:data"

 

Any idea

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

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