Footer subtotal parameter prompt error

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Good Morning - I am writing a report that has many different groupings. I am
not trying to build subtotals in the footers.

So for instance, say there are 4 grouping levels A-D. The lowest grouping D
has a subtotal from two subreports contained in the detail of grouping D.
The field name for the grouping D subtotal command is called TotalGroupD. I
am now trying to create a subtotal in grouping C of all of the grouping D
subtotals.

Right now I have the control source in a text box that reads
=SUM([TotalGroupD]). When I run the report it is asking me for the parameter
TotalGroupD.

What am I doing wrong that it just won't run automatically? For what I need
there should not be a parameter to enter.

Thank you in advance for any help you would be able to offer with this. -
Kelly
 
As soon as I posted this I changed my tactic and used the Group and Sort
button in the Ribbon at the top during the Design View. That was the
correction.
 
Back
Top