Report with 2 detail bands and Servoy foundsets

Hi, is it possible to generate a report from Servoy foundsets if the jasper file report has 2 detail bands?

That should work fine, did you try it?

Hi

Yes its is possible. I have one report with 9 detail bands that i switch on or off depending on parameters i pass into it. Note that i think you are limited to only passing 1 foundset (and its related data) into the report.

What would be extremely useful is to be able to pass multiple foundsets into a jasper report for use in subreports and list controls and detail bands. I’m not sure this is possible?

Rodney,

If you want to use foundsets that are not related to the record of the main foundset you can use global related foundsets.
Or you can call a global method in the report which returns your other foundset.
A global variable will also work.

Rob