By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Need help with subreport/running sum

P: n/a
Using A2K. I've got a report/subreport that looks like the following:

<main report>
Account AAA Beginning Fund Balance: $10,000

<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
....and so on...

"Balance" is computed by subtracting "Total" from the previous
"Balance".

I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Thanks for any help or advice.

Jun 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
EManning wrote:
>Using A2K. I've got a report/subreport that looks like the following:

<main report>
Account AAA Beginning Fund Balance: $10,000

<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
...and so on...

"Balance" is computed by subtracting "Total" from the previous
"Balance".

I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Add a hidden text box (named txtRunExp) with control source
set to the total field and set its Running Sum property to
Over Group.

Then add a visible text box (named txtBalance) with a
control source expression like:
=Parent.txtBeginningBalance - txtRunExp

--
Marsh
Jun 11 '07 #2

P: n/a
On Jun 11, 4:01 pm, Marshall Barton <marshbar...@wowway.comwrote:
EManning wrote:
Using A2K. I've got a report/subreport that looks like the following:
<main report>
Account AAA Beginning Fund Balance: $10,000
<subreport>
"Expense" "Total" "Balance"
Expense #1 $4,000 $6,000
Expense #2 $50 $5,950
Expense #3 $100 $5,850
...and so on...
"Balance" is computed by subtracting "Total" from the previous
"Balance".
I'm not sure how to set "Balance" up in the subreport. Do I use a
running sum? If so, how?

Add a hidden text box (named txtRunExp) with control source
set to the total field and set its Running Sum property to
Over Group.

Then add a visible text box (named txtBalance) with a
control source expression like:
=Parent.txtBeginningBalance - txtRunExp

--
Marsh- Hide quoted text -

- Show quoted text -


Thank you so much. For some reason, I could not figure that out.
Jun 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.