Accessing Subreports Group Section Totals in Parent Report Header

[David]

Hi,

I know how to grab report totals from a subreport.

What I wonder is: Is there a way to grab group section totals and use in the
main report.

I know this is bad programming, but I have a report grouping/totalling on a
field which has 1 of 2 values (let's say A and B). I want to have in the
Parent Report's header, the value of the subtotal for Group A, and the value
of the subtotal for Group B.

Any ideas?
Thanks.

 

[Allen Browne]

If you want to repeat each of the subreport's section's subtotals on the
main report, you'll have to do that with another subreport or listbox on the
main report. There's no reliable way to pass them back individually (as
distinct from merely passing back a subreport total to the main report each
time it occurs on the main report.)

Even if you program an array using the Print event of the subreport header
to accumulate the values, you'll find that this is unreliable, e.g. it may
not work if the user doesn't print all pages of the report, and it doesn't
work at all in Report or Layout view (Access 2007.)