Skip to Content
0
Sep 25, 2013 at 03:52 PM

Main report and subreport not displaying properly when grouped

130 Views

I've developed a report with a main report and a subreport embedded in the Group Footer section. I'm trying to generate a report that will give me the following:

CORRECT FORMAT:

Main report A

Subreport A

Main+Subreport Group total A

Main report B

Subreport B

Main+Subreport Group total B

Main report C

Subreport C

Main+Subreport Group total C

Report total A+B+C

I have no problem passing the group totals to the main report total. My problem is the order in which these groups are displaying. What I'm getting right now is:

WRONG FORMAT:

Main report A

Subreport A

Subreport Group total A

Subreport B

Subreport Group total B

Subreport C

Subreport Group total C

Main report B

Subreport A

Subreport Group total A

Subreport B

Subreport Group total B

Subreport C

Subreport Group total C

Main report C

Subreport A

Subreport Group total A

Subreport B

Subreport Group total B

Subreport C

Subreport Group total C

Report Total A+B+C

How do I avoid having subreports A and B from re-appearing in the other groupings? In other words, how do I make my report to display in the CORRECT FORMAT shown above? Please advice. I'd appreciate any help I can get out there. Thank you much.