[rsAggregateReportItemInBody] The Value expression for the textbox 'textbox6' uses an aggr

I put this into a textbox, why isn't this possible?

=SUM(ReportItems!GrossGoal1.Value)

I need to do this!!!!

[rsAggregateReportItemInBody] The Value expression for the textbox 'textbox6' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers.

[rsMissingAggregateScope] The Value expression for the textbox ‘textbox6’ uses an aggregate expression without a scope. A scope is required for all aggregates used outside of a data region unless the report contains exactly one data set.

Build complete -- 2 errors, 0 warnings

I also need to be able to accomplish the same thing. Is there any way to get this done? I have been searching for an answer for a while now, and I can't seem to find anything.

Thanks

|||

Anyone find a solution to this problem?

thanks..

dd

|||There isn't one, Microsoft said they are working on a fix for it in future editions of SSRS, rather an enhancement. We'll see if they ever get to it.|||

Is there another way to get real time row totals in excel without ReportItems? So, if the user changed a value in an excel cell it updates to the total in the spreadsheet (not in the database of course). I got it working for column totals but it's not working for rows. Partly because of the aggregation issue; but, also due to the fact this would have to be more dynamic than the columns one. Anyways, here is an example of what I am talking about:

t < got this working

1 1 1 | 3

1 2 3 | 5

2 3 4 | 8

^^isnt working