Group count with a twist

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a report with a subreport.

In my subreport I have one level of grouping and I have
setup a way to count the number of groups and I display
the final count in the report footer using the following
method.
=======================================================
Assuming you have a group header and want to count the
number of groups, add
a text box to the group header
Name: txtGroupCount
Control Source: =1
Running Sum: Over All

Add a text box to your report footer
Control Source: =txtGroupCount
=======================================================
Everything I described so far works, my problem is that on
my main report I have a text box that references the final
value of the group count in my subreport and it is failing.

My subreport displays a final group count of 29 and this
is correct. My text box displays a value of 1.

Any ideas appreciated.

Thanks
 
The text box on your main report should reference the text box in your
subreport's report footer.
 
Back
Top