ReportItem aggregate

I have some data grouped with by a number, On the group footer I have the
sum(col1) and sum(col2) displayed in textbox1, textbox2 etc.
Additionally I need to include sum(col1) - sum(col2) in textbox3.
When I tried to use (ReportItems!textbox1.value) -
(ReportItems!textbox2.value)
It gived an error "Report item expressions can only refer to other report
items within the same grouping scope or a containing grouping scope."
Any advice is welcome.
Thanks.This is probably because textbox3 is in an outer scope (containing grouping
or the table). When the report is processed, you'd get multiple instances of
a group. In an outer scope, we can't determine which inner group instance we
should get the textbox value from. Is this the case in your report?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ni" <Ni@.discussions.microsoft.com> wrote in message
news:EEA615B0-5283-425D-AA32-81E20F460904@.microsoft.com...
>I have some data grouped with by a number, On the group footer I have the
> sum(col1) and sum(col2) displayed in textbox1, textbox2 etc.
> Additionally I need to include sum(col1) - sum(col2) in textbox3.
> When I tried to use (ReportItems!textbox1.value) -
> (ReportItems!textbox2.value)
> It gived an error "Report item expressions can only refer to other report
> items within the same grouping scope or a containing grouping scope."
> Any advice is welcome.
> Thanks.