display subtoal from sub report 1

[Durango122]

Hi All
cr 9.0
ms sql
i have a report that has main and 2 subreport
my main report shows subtotal in report group footer territory and i have 2 sub report that displays ranks
ex:
heading
territory|branch|WEEKSSLS|MTD_SLS|YTDSLS|WEEKRNK|YTDRNK|YTD_SLS_PER_REP_RNK
gr1 is territory and gr2 branch
my surb report displays the rank for the 2 last one
this is fine in the branch level
my problem is my main report has a subtotal display at the territory level
my subreport these subtoal are suppress since i'm not showing them at the branch level only the amount and the rank
how can i get the subtotal of the 2 subreport to show in the main report at the territory level.
Must i create 2 new subreport and call them subtotal and have the sub total display and suppress the amount and rnk from them and simply place the subreport there?????????

Thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Madawc]

To pass data back from a subreport, use a shared variable. For a currency value, you'd do it as

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved:={#TotSaved};
SumSaved

And to access it in the main report, create another formula field with

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved

Note that the shared variable is only available in the section after the section which contains the subreport. From there you should be able to accumulate it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Durango122]

Hi Madawc
thanks for the replied so in other words i should insert the sub report into the other group and used the shared var
ex: here is how my reports look like:
sub report
header------------firmId-----count
gf1 firmsubtotal----15---------5
gr2 branchsubtotal--25---------1
footergrandtotal----40---------6

main report
gr1 firm--------15--------subreport(5)
gr2 branch------25--------subreport(1)
footer----------40---------????
so i should place the shared variable here in the main report footer and suppress it
and in my sub report place it in the footer and shared variable there and insert my sub report in the main group footer also?????????????????

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Madawc]

Values from the two subreports should be available in all sections after gr2. They could even be used in an additional gr2 section. I assume you use different shared variables for the two subreports.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10