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

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

P: 1
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!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:

[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...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!!!!
Feb 9 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.