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

dba123

Member
Joined
Jan 31, 2006
Messages
8
Programming Experience
5-10
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!!! for unique situations where I need to do so????

It's driving me nuts

My footer field's expression (the problem):

=SUM(Fields!GrossGoal1.Value, "CustomerNumber_Grp")

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

=((Fields!FeeGoal.Value) / Fields!FeeSchedule.Value) * 100



Errors when trying to preview my report in SSRS Report Designer 2005:

[rsFieldReference] 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
[rsInvalidAggregateScope] 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/archives.asp?l=sql-server-l&i=922461
and
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=256848&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!!!!
 
Back
Top