Data source for subreport

[mackensen]

Hello,

I have a web application with a main report that is ok. All the data comes from the servlet (including datasource) so there' s no SQL query or database connection in the main report.

In the main report there is one subreport (or even two). How can I connect this subreport to a datasource (the same db connection as for the main report) and use some SQL query the same way as for the main report, I mean without SQL code inside the subreport ? The subreport should receive the id field from the main report as a parameter (for every record of the main report there are some records for the subreport).

Thanx,

mackensen