Making a calculation in report footer of every record

  • Thread starter Thread starter Fred's
  • Start date Start date
F

Fred's

Hi All,

I'm trying to to make a total in my report footer. I'm explaining;

In Page Header: (I have the following labels)
ID Hour Door TransportOrContainer Footwear ALDO Feet-First Transit
Globo
Handbags Aldop NonALDOp Accessories ALDOQ NonAldoQ

In TransportOContainer Header: (I have the following text box which
make my
the records group by TransportOrContainer)
TransportOrContainer Header

In the Detail section: (I have the following text boxes)
ID Hour Door TransportOrContainer Footwear ALDO Feet-First Transit
Globo
Handbags Aldop NonALDOp Accessories ALDOQ NonAldoQ

And in the following text boxes, which are in the detail section, I
have the
following formulas

In the Footwear Text box, the formula is: =Sum([Footwear])+([ALDO])+
([Feet-
First])+([Transit])+([Globo])
In the Handbags Text box, the formula is: =Sum([Handbags])+([ALDOP])+(
[NonALDOP])
In the Accessories Text box, the formula is: =Sum([Accessories])+
([ALDOQ])+(
[NonALDOQ])

Now for each of these text boxes (Footwear, Handbag and Accessories)
which
has the above formulas, I want to create a grand total in the Report
footer.
How can I do that?

Thanking you all in advance for your help!
 
If your formula is working, just copy it to the Report Footer band. The band
determines how the sum is processed.
 
Back
Top