I have a performance problem with the following scenario:
ParentTable (with up to 10000 rows),
ChildTable (with up to 20000 rows), for each parent there are 0 - 4 child-rows
The layout in the report for child-table-data is like the following:
Label Value1 Value2 Value3
Value4 Value5 Value6
The label is only in the first line and the following values are in columns. All this must only be displayed if the ChildTable has at least 1 row for the parent-row.
Currently implemented via:
MainReport based on ParentTable
-> ChildReport based on ChildTable
If at least one child row exists
Label ChildReportDetail based on ChildTable
ChildReportDetail with Column - Layout
-> Performance Problem, because of many "joins"
10000 x 20000 x 20000 ?
How can the above layout be implemented by only one Subreport based on ChildTable?
Hope all this was clear enough, you can also see the attached file.