cannot place database field on report

[holgerg]

Hello there!

I am new to iReport. The first thing i want do is to use my database. I can connect to my Unify database via JDBC in the Service window. There i see all the tables with the data. I have done this by adding my JDBC driver and created a new database connection.

My problem is that i can not place this database fields to my report. I tried it via drag and drop and the mouse cursor said to me that it is not allowed to place the filed there.

I do not see the database fields in the report inspector windows at fields.

I also can not create a new connection to my datasource using Connections/Datasources. When i choose 'Database JDBC connection' my JDBC driver is not listed.

The classpath to my JDBC driver is added.

Thanks for your help in advance.

Holger

[sick35]

I'm having the same problem, the difference is that I'm using SQLite JDBC connection. Can't add fields to my report in iReport 3.7.1. I see them, but can't add them... Someone can help? thanks

[mdahlman]

Holger,

The fact that your driver is not listed in the dropdown list is not a problem. Just type in your driver and it should work (since you already added it to the classpath). That list is a convenience since lots of users don't know the correct classname. But the list is both too large (it shows classes that you don't really have) and too small (it fails to show other valid drivers in your classpath).

Before you can drag fields into your report you need to define a SQL query in the report. Right-click the root report element in the Report Inspector and choose Edit Query. After doing that you should be able to drag fields from the Report Inspector (not from the Services panel).

Regards,
Matt

[holgerg]

Hello Matt,

thanks a lot for your help. This is exact the right solution!

Greetings from Germany

Holger