Can BIRT use the output of one query as the input for another query

I have a report that needs to be generated from two different queries.

• The first query retrieves a list of information from one data source
• The second query must then be called once for each of the records returned by the first query?
• Each result set from the second query will t开发者_如何学编程hen be displayed in separate report tables.

Any pointers are welcome.

It is not possible to perform a SQL join on the first and second query.

Yes this is possible lets assume you have bind your first query results to data table. you can create another table inside the parent table cell and assign your 2 data set to that table with filter of dataset 1

http://publib.boulder.ibm.com/infocenter/rmc/v7r5m0/index.jsp?topic=/org.eclipse.birt.doc/birt/birt-13-1.html

http://publib.boulder.ibm.com/infocenter/rmc/v7r5m0/index.jsp?topic=/org.eclipse.birt.doc/birt/birt-13-2.html

The functionality I require is provided by SubReports

http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/subreport/index.php