Passing subreport variables to the main report.

[staceyn]

Hello,
I am using v10 of crystal. I have a main report with several subreports. The subreports have the details suppressed and are showing the group totals only. There are grand totals calculated but the fields are suppressed.
I am trying to pass the grand total values from each of the subreports into the main report. The subreports are placed in the group footer section of the main report.
The shared variable for the grand totals is placed in the report footer section of the main report.
This is my subreport formula for the variable:

whileprintingrecords;
shared numbervar d1ly:=Sum ({@day1_price_ly})

This is my formula in the main report:

whileprintingrecords;
shared numbervar d1ly;
d1ly:=d1ly

The problem is I am only getting value of the last value in the group instead of the value from the whole subreport.

Can anyone assist as to what I am doing wrong?

Thanks,
Stacey

 

[lbass]

How have you linked the subreport to the main report? Make sure you are linking only by the group in which the subreport is located and any higher level groups.

-LB

 

[kskid]

Your shared variable is getting reset with each group footer.

In the report header place this

WhilePrintingRecords;
shared numbervar totd1ly := 0;

Insert another group footer section under the subreport and move your formula from the report footer to the new group footer section with the following changes

WhilePrintingRecords
Shared numbervar D1ly;
shared numbervar totD1ly;

totD1ly := totD1ly + d1ly;

In the report footer, create the following formula

WhilePrintingRecords;
Shared numbervar totd1ly;

totD1ly

Cheers,
-LW

 

[staceyn]

Thanks LW that seemed to do the trick. I appreciate all of the help.