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

RunningSum over first group in report

P: n/a
Hello all

I have a report where I have two nested groups.
I know there are only three standard options for running sum: None,
Over Group and Over All.
I have a MyTextBox in detail section where the data is summed over
group.
But the data is summed over the second group. When a new group begins
MyTextBox value is resetting to zero. I need a running sum over the
first group so when another second group begins MyTextBox value will
not reset to zero.
Can anyone tell me how one can make a running sum over only the first
group.
Is there some option RunningSum over first group, or can someone
suggest some VBA code to do that?
I'm using A2k2 SP3.

Thank you

Sebastian C.

Oct 28 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Sebastian" <gr********@artel.rowrote in
news:11*********************@b28g2000cwb.googlegro ups.com:
Hello all

I have a report where I have two nested groups.
I know there are only three standard options for running sum:
None, Over Group and Over All.
I have a MyTextBox in detail section where the data is summed
over group.
But the data is summed over the second group. When a new group
begins MyTextBox value is resetting to zero. I need a running
sum over the first group so when another second group begins
MyTextBox value will not reset to zero.
Can anyone tell me how one can make a running sum over only
the first group.
Is there some option RunningSum over first group, or can
someone suggest some VBA code to do that?
I'm using A2k2 SP3.

Thank you

Sebastian C.
I can't imagine why you would want a running sum total of a
first group in a second group.

However there are several techniques to try. One is to replace
the second group with a subreport, and filter it out of the main
report.

Another is to put code into the first group's footer_OnFormat
Event to capture the value of the running sum to a variable
(Dim'ed in the module's declarations before the subs) and use
code to put the variable into an unbound textbox.,
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 28 '06 #2

P: n/a

Bob Quintal a scris:
"Sebastian" <gr********@artel.rowrote in
news:11*********************@b28g2000cwb.googlegro ups.com:
Hello all

I have a report where I have two nested groups.
I know there are only three standard options for running sum:
None, Over Group and Over All.
I have a MyTextBox in detail section where the data is summed
over group.
But the data is summed over the second group. When a new group
begins MyTextBox value is resetting to zero. I need a running
sum over the first group so when another second group begins
MyTextBox value will not reset to zero.
Can anyone tell me how one can make a running sum over only
the first group.
Is there some option RunningSum over first group, or can
someone suggest some VBA code to do that?
I'm using A2k2 SP3.

Thank you

Sebastian C.
I can't imagine why you would want a running sum total of a
first group in a second group.

However there are several techniques to try. One is to replace
the second group with a subreport, and filter it out of the main
report.

Another is to put code into the first group's footer_OnFormat
Event to capture the value of the running sum to a variable
(Dim'ed in the module's declarations before the subs) and use
code to put the variable into an unbound textbox.,
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
It is about a account transactions.
The first group is the account number ( there are many accounts) and
the second group is the month.
I need to calculate the debit balance or credit balance so I need to
sum the debit and the credit only to first group.
At a given time I need to know the debit or credit balance for the
whole account form the beginning of the year not just for the
operations in one month.
That`s why I need running sum over by first group only.

Thank you for your time.

Sebastian C.

Oct 28 '06 #3

P: n/a
"Sebastian" <gr********@artel.rowrote in
news:11**********************@i3g2000cwc.googlegro ups.com:
>
Bob Quintal a scris:
>"Sebastian" <gr********@artel.rowrote in
news:11*********************@b28g2000cwb.googlegr oups.com:
Hello all

I have a report where I have two nested groups.
I know there are only three standard options for running
sum: None, Over Group and Over All.
I have a MyTextBox in detail section where the data is
summed over group.
But the data is summed over the second group. When a new
group begins MyTextBox value is resetting to zero. I need
a running sum over the first group so when another second
group begins MyTextBox value will not reset to zero.
Can anyone tell me how one can make a running sum over only
the first group.
Is there some option RunningSum over first group, or can
someone suggest some VBA code to do that?
I'm using A2k2 SP3.

Thank you

Sebastian C.
I can't imagine why you would want a running sum total of a
first group in a second group.

However there are several techniques to try. One is to
replace the second group with a subreport, and filter it out
of the main report.

Another is to put code into the first group's footer_OnFormat
Event to capture the value of the running sum to a variable
(Dim'ed in the module's declarations before the subs) and use
code to put the variable into an unbound textbox.,
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

It is about a account transactions.
The first group is the account number ( there are many
accounts) and the second group is the month.
I need to calculate the debit balance or credit balance so I
need to sum the debit and the credit only to first group.
At a given time I need to know the debit or credit balance for
the whole account form the beginning of the year not just for
the operations in one month.
That`s why I need running sum over by first group only.

Thank you for your time.

Sebastian C.
so you want
report header
-Account1 Group header (previous balance)
-Account 1 details
--month1 subgroup header
--month1 subgroup details
--month1 subgroup footer (running sum over month)
--month subgroup
....
--month subgroup
....
-account1 footer (running sum over account)
-Account2 header
etc...

redo the report using a summation query for the month.
remove the month group. replace with month subform.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.