I have several sub-reports within the detail section of my report. It currently returns each sub-report in order for each row in the report. I was hoping to consolidate the sub-reports rather than go through the entire detail for each row. Is this even possible? If so how do I go about it as I have already tired making separate detail sections for each sub-report and that didn't seem to work out.
Example:
Current:
Row1- subreport1
Row1 - subreport2
Row1-subreport3
Row2- subreport1
Row2 - subreport2
Row2-subreport3
Row3- subreport1
Row3 - subreport2
Row3-subreport3
Desired:
Row1- subreport1
Row2 - subreport1
Row3-subreport1
Row1- subreport2
Row2 - subreport2
Row3-subreport2
Row1- subreport3
Row2 - subreport3
Row3-subreport3
Example:
Current:
Row1- subreport1
Row1 - subreport2
Row1-subreport3
Row2- subreport1
Row2 - subreport2
Row2-subreport3
Row3- subreport1
Row3 - subreport2
Row3-subreport3
Desired:
Row1- subreport1
Row2 - subreport1
Row3-subreport1
Row1- subreport2
Row2 - subreport2
Row3-subreport2
Row1- subreport3
Row2 - subreport3
Row3-subreport3