Can't reference a Group Field in Footer SUM expression!!!!! !!!!!!!!!!!!!!! !!!!!!!!!!

[dba123]

THERE HAS TO BE A SOLUTION FOR THIS!!!! How can I get around the limitation in SSRS 2005 of being able to SUM a Group referenced field in my FOOTER!!!
It's driving me nuts

My footer field's expression (where the problem lies):

=SUM(Fields!Gro ssGoal1.Value, "CustomerNumber _Grp")

The GrossGoal1 group field that I'm trying to reference right above it in the same table column has:

=((Fields!FeeGo al.Value) / Fields!FeeSched ule.Value) * 100

Errors:

[rsFieldReferenc e] The Value expression for the textbox ‘GrossGoal_gt’ refers to the field ‘GrossGoal1’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

and

[rsInvalidAggreg ateScope] The Value expression for the textbox ‘GrossGoal_gt’ 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.

I did that! I set it to my Group name of my table!!!! Am I doing this wrong???????

http://groups.ittoolbox.com/archives...ver-l&i=922461

and

http://www.sqlservercentral.com/foru...6848&post=true

I am having to produce a stupid work around which is create a new dataset, tie it to a stored proc which then sums up my column's total using SQL in the stored proc instead of Reporting Services being able to reference my stupid Group field in the footer in order to sum for a grand total in the footer for that group column.

Why am I putting this in big letters? Because I'm about to pull my hair out!!!!