Record Total Expression in Page Footer

[Stephen]

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.

 

[Ofer Cohen]

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]

 

[fredg]

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.

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"

 

[Marshall Barton]

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.

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.

 

[Stephen]

Thank you for the tip.

Worked perfect.

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.

 

[Stephen]

Thank you for the tip.

Worked perfect.

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

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.