I was asked to place group totals on the first page of report as well as in the body. In the past, this has not caused any problems (used subreport) because the data was stable. However, this time the data is not stable. if I run report, the subreport and the report body do not agree. What alternatives are available so that the subtotals in the report body can be correctly shown on the first page summary?
Basic report body layout
Group 1 count job total amt
group 2 count job total amt
group 3 count job total amt
detail job # amount
the Summary totals for Group 1 & 2 need to appear on first page.
I normally use a dummy group for the first page summary.
Any help would be appreciated.