Jasper Reports: Multiple subreports passed the same foundset

Classic Servoy
1

I"m working on a main report that has 2 detail bands. In each detail band I have a subreport. Each subreport is passed the same servoy foundset relation as its datasource. However, both subreports don’t seem to work together when on the same main report.

When one subreport is present on the main report: it works
When both supreports are present, only the first sub shows data.
When I change the order of the subreports, so the second report moves to detail band 1 and vise versa, I can then see the second sub, but the first sub becomes blank.

Can I not pass a related foundset to more than one subreport in a main form? Why does whichever subreport is second in order not show data?

Thanks for your help–I am a bit new to jasper and servoy.

2

mikerich.netapp,

Which version of the plugin do yo uuse?

What happens if you duplicate the relation and use the duplicate relation name in the second subreport?

Rob

3

I’m using the latest 4.0.0b1.

It does work if I create multiple duplicate relations “customers_to_orders”…“customers_to_orders_r1”…etc.

It seems like for some reason the first subreport burns the first relation and doesn’t allow it to be used for other subs. I can move forward with this workaround, although it does seem a bit heavy-handed.

Thanks for the idea!

4

The workaround shows that it is not some issue with the report.

Please create a very small sample report and solution (with sample data included) that shows this and file an issue in the Servoy support system.

Rob