"Jason McInnes" <jmcinnes@mighty.co.za> wrote in message
news:65603486.0502030335.627d0d12@posting.google.com...
> Hi there
>
> I'm pulling out my hair with what I suspect is actually something
> silly.
>
> I have a report with the following structure.
>
> --[TABLE]----
> --[table1_group1]----
> --[table1_group2]----
> --[detail]----
>
> My data source has a field, "minutes", which is displayed in
> table1_group2. This field is repeated for each time in the detail, but
> is not displayed there.
>
> I wish to display a sum of "minutes" which is displayed in
> [table1_group2] in [table1_group1], and not a sum of "minutes" which
> is in repeated for each detail record. If I place a textbox in
> [table1_group1] and specify a value of "=sum(fields!minutes.value)",
> the result is not what I'm looking for. If I specify a value for the
> textbox of "=sum(fields!minutes.value,"table1_group2"), I get an
> error:
> ---
> "c:\work\reports\session detail\Session Detail.rdl The value
> expression for the textbox 'textbox22' 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."
> ---
> It also won't let me do a sum of a textbox from the inner group - is
> there a way to do this?
>
> Am I on the right track here? Any help would be greatly appreciated.
>
> Jason