Group sum outside group?

I'm trying to get a sum of values from a group with the following expression.
=SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to run it I
get the following error.
[rsInvalidAggregateScope] The Value expression for the textbox â'textbox7â'
has a scope parameter that is not valid for an aggregate function. The scope
parameter must be set to a string constant that is equal to either the name
of a containing group, the name of a containing data region, or the name of a
data set.
Build complete -- 1 errors, 0 warnings
Why can't I sum group values?Eric,
Try this:
=RunningValue(Fields!BF_Child.Value,Sum,"table1_Details_Group")
Michael C
"eric" wrote:
> I'm trying to get a sum of values from a group with the following expression.
> =SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to run it I
> get the following error.
> [rsInvalidAggregateScope] The Value expression for the textbox â'textbox7â'
> has a scope parameter that is not valid for an aggregate function. The scope
> parameter must be set to a string constant that is equal to either the name
> of a containing group, the name of a containing data region, or the name of a
> data set.
> Build complete -- 1 errors, 0 warnings
>
> Why can't I sum group values?|||Hi Michael,
Thank you for the response. Unfortunately I get the same error. I have 2
groups, one to group by parent and the second group to reduce duplicate
records. The Sum I would like to total the second group values, but only
the visible records in the group. Any other ideas? Thanks
Eric
"Michael C" wrote:
> Eric,
> Try this:
> =RunningValue(Fields!BF_Child.Value,Sum,"table1_Details_Group")
> Michael C
> "eric" wrote:
> > I'm trying to get a sum of values from a group with the following expression.
> > =SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to run it I
> > get the following error.
> >
> > [rsInvalidAggregateScope] The Value expression for the textbox â'textbox7â'
> > has a scope parameter that is not valid for an aggregate function. The scope
> > parameter must be set to a string constant that is equal to either the name
> > of a containing group, the name of a containing data region, or the name of a
> > data set.
> > Build complete -- 1 errors, 0 warnings
> >
> >
> > Why can't I sum group values?|||Hi Eric,
Did you find the solution for this?
I have the same problem and I would like to know if there´s anyway of doing
it.
Thanks,
Mónica
"eric" <eric@.discussions.microsoft.com> escribió en el mensaje
news:2DD05D4D-4B91-4088-B1A9-EA5BF35592B4@.microsoft.com...
> Hi Michael,
> Thank you for the response. Unfortunately I get the same error. I have 2
> groups, one to group by parent and the second group to reduce duplicate
> records. The Sum I would like to total the second group values, but only
> the visible records in the group. Any other ideas? Thanks
> Eric
> "Michael C" wrote:
>> Eric,
>> Try this:
>> =RunningValue(Fields!BF_Child.Value,Sum,"table1_Details_Group")
>> Michael C
>> "eric" wrote:
>> > I'm trying to get a sum of values from a group with the following
>> > expression.
>> > =SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to
>> > run it I
>> > get the following error.
>> >
>> > [rsInvalidAggregateScope] The Value expression for the textbox
>> > 'textbox7'
>> > has a scope parameter that is not valid for an aggregate function. The
>> > scope
>> > parameter must be set to a string constant that is equal to either the
>> > name
>> > of a containing group, the name of a containing data region, or the
>> > name of a
>> > data set.
>> > Build complete -- 1 errors, 0 warnings
>> >
>> >
>> > Why can't I sum group values?sql