How to Execute a SQL Query using iReport.

Click Data --> Report Query. The Following window will appear

Type the SQL Query you want. To pass Parameters user $P{PARAMENTER_NAME} (in iReport 2.0 or higher). You can click the “Automatically Retrieve Fields” check box to retrieve the fields.

Keep in mind if there’s an SQL error the fields will not be retrieved and the SQL error will be displayed.

You can also select the fields you want from a Database Model and generate the Query automatically. I DO NOT recommend this. Although you can set the conditions before hand I always find it reliable when I have a working Query in my hands. It’s always better to know that the query works. So create the query using SQL Navigator or a similar tool using sample data for “Parameters” and use that query.

Click OK after Fields are retrieved.

The iReport Golden Rules

When In doubt go to JasperForge Forum.

Google and blogs like these are a lot of help, But there the community is larger and more likely that you’ll get a response from some of the Admins if your problem is really complicated.

See the iReport Examples.

They are a must have when you are using iReport. Your simple questions can be answered by looking at the examples which would save you a lot of time

Talk to the community, Help Others.

Mainly at the JasperForge forum. The same problems are posted over and over because people has slightly different variations of the same problem

Experiment.

There’s a lot of things to learn about iReport. The chances are that you may find some things very interesting