Group count with a twist

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top