Groups | Blog | Home
all groups > sql server reporting services > august 2007 >

sql server reporting services : Group sum outside group?



eric
8/20/2007 4:10:02 PM
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


Michael C
8/21/2007 8:06:00 AM

Eric,
Try this:
=RunningValue(Fields!BF_Child.Value,Sum,"table1_Details_Group")

Michael C

[quoted text, click to view]
eric
8/21/2007 8:48:01 AM
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

[quoted text, click to view]
Mónica
10/26/2007 12:00:00 AM
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...
[quoted text, click to view]

AddThis Social Bookmark Button