> Hi
> I have a report which contains 3 subreports.  The main report contains
> header information, and each of the three subreports contains financial
> info.  Each Sub-report contains a Running Total.  Is it possible to
display
> the combined total of all these 'Running Totals' from each of the
Subreports
> and display it in the main report, perhaps in the footer section.

> Any help would be much appreciated.

> Kind Regards

> Rikesh
> (Using Win2K/VB6/SQL2K/CR8.5Dev.Ed/CRAX.DRT)

> Hi Rikesh,
>     You can get pull this information into your main report by inserting a
> formula field into each of your subreports and, in the formula, equate the
> running total field to a "Shared" variable:
>     Shared numberVar total1 := {RunningTotalField}
> Then in your main report, in a section that is processed after the
> subreport, you can insert a formula that adds these totals:
>     Shared numberVar total1;
>     Shared numberVar total2;
>     Shared numberVar total3;
>     Shared numberVar grandtotal;
>     grandtotal := total1 + total2 + total3

> Bob Holmes

> > Hi
> > I have a report which contains 3 subreports.  The main report contains
> > header information, and each of the three subreports contains financial
> > info.  Each Sub-report contains a Running Total.  Is it possible to
> display
> > the combined total of all these 'Running Totals' from each of the
> Subreports
> > and display it in the main report, perhaps in the footer section.

> > Any help would be much appreciated.

> > Kind Regards

> > Rikesh
> > (Using Win2K/VB6/SQL2K/CR8.5Dev.Ed/CRAX.DRT)