Two SQL query inside single JasperReport

Question

We are generating reports based on iReports and JasperReports for web application.

Using iReports I found I am struck with big problem.

I want to use two SQL query to fill up my main report... In query designer I can only write one query..

For another query I cannot use sub-reports...

How do I write second query which will return different fields and include them in my report..

Please guide...

I cannot use sub-reports...

Answer 1

As far as Ireports are concerned, the main report can comprise only one query. And if you wanna use multiple queries in your report, it is possible in the following ways.

• Sub Report
• Table Dataset.
• sub Dataset.

since you don wish to use a sub report, you can go for a Table Dataset. Anything you would do with a sub report is possible with table dataset too(Except for returning variables). You can use sub datasets with charts and graphs. Table set will be of use to you i hope.