Sum fields outside of their group?

New to SQL RS so go easy on me ;)

My report looks like this...

Group 1 - Client_ID, Product, State
Group 2 - Name

Details return Insurance Policy #'s, Premiums, Balance

Group 2 Footer - Count on Policy#'s by Group 2
Group 1 Footer - Count on Policy#'s by Group 1, Sum Premium, Sum
Balance

I need to create something like a report footer to total the Sum of
Premium and Sum of Balance in the Group 1 Footers. I'm running into
problems when trying to sum fields outside of their group (like using
the Table Footer).

I can't put it in the Page Footer (which worked) b/c I actually have a
page footer that must display on every page.

Orne
Thu Nov 15 07:48:18 PST 2007

On Nov 14, 2:32 pm, lora_adc...@cox.net wrote:
> New to SQL RS so go easy on me ;)
>
> My report looks like this...
>
> Group 1 - Client_ID, Product, State
> Group 2 - Name
>
> Details return Insurance Policy #'s, Premiums, Balance
>
> Group 2 Footer - Count on Policy#'s by Group 2
> Group 1 Footer - Count on Policy#'s by Group 1, Sum Premium, Sum
> Balance
>
> I need to create something like a report footer to total the Sum of
> Premium and Sum of Balance in the Group 1 Footers. I'm running into
> problems when trying to sum fields outside of their group (like using
> the Table Footer).
>
> I can't put it in the Page Footer (which worked) b/c I actually have a
> page footer that must display on every page.

Change the Scope parameter of the Sum in the Table Footer to the name
of the Dataset. If you are copying a formula from the group footer to
the table footer, you run the risk of having Aggregates reference the
wrong scope.

-- Scott