Record Total Expression in Page Footer

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

Guest

I know that I can't use record total expression in pager footer.

However, I have to use page footer to show sum amount (not report footer),
since the detail section for the report gets grow.

Is there anyway to get around this problem?

Please help.
 
Try this stages:

1. Create a text box in the detail section, and bound it to the field you
want to sum
2. Set the RunningSum property of that text box to OverAll
3. Set the Visible property of the text box to No
4. Create a text box in the Report PageFooter and in the control source write
=[TextBoxNameFromStage1]
 
I know that I can't use record total expression in pager footer.

However, I have to use page footer to show sum amount (not report footer),
since the detail section for the report gets grow.

Is there anyway to get around this problem?

Please help.
Click to expand...

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
 
Stephen said:
I know that I can't use record total expression in pager footer.

However, I have to use page footer to show sum amount (not report footer),
since the detail section for the report gets grow.
Click to expand...


If all you want is the report's grand total, then you can
calculate it in the a report header section text box. Then
just refer to that text box in your page header/footer text
box.
 
Thank you for the tip.

Worked perfect.

Marshall Barton said:
If all you want is the report's grand total, then you can
calculate it in the a report header section text box. Then
just refer to that text box in your page header/footer text
box.
Click to expand...
 
Thank you for the tip.

Worked perfect.

Ofer Cohen said:
Try this stages:

1. Create a text box in the detail section, and bound it to the field you
want to sum
2. Set the RunningSum property of that text box to OverAll
3. Set the Visible property of the text box to No
4. Create a text box in the Report PageFooter and in the control source write
=[TextBoxNameFromStage1]

--
Good Luck
BS"D


Stephen said:
I know that I can't use record total expression in pager footer.

However, I have to use page footer to show sum amount (not report footer),
since the detail section for the report gets grow.

Is there anyway to get around this problem?

Please help.
Click to expand...
Click to expand...
 
Back
Top