Totals in Footer using unbound text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read several posts regarding using unbound text boxes to sum totals but
still can't get this to work properly.

In a report, I have, for example, a column that is named TotalGallonsHome,
which contains the following as it's control source: =IIf([FuelExpenses
subreport].Report.HasData,[FuelExpenses subreport].Report!FuelCostHome,0)

This statement works correctly in the Detail section.

I want to provide a SUM of this column in the footer. I can't use
=Sum([TotalGallonsHome]) as when the report is run it asks to enter parameter
value for TotalGallonsHome.

What is the best way to solve this problem?
 
I figured out that I could create another unbound textbox on the
[TotalGallonsHome] value with Running Sum set to Over Group.

Then, in the footer I referenced the unbound text box there to the
RunningSumTotal contained in the detail section. That worked.

Perhaps there is a better way to do this???
 
Back
Top