I have spent most of the day on this and I feel I should be able to do this, this is my last resort.

 

Using Crystal XI I have a main report with some totals from a subreport using a shared variable. I have the shared variable displaying on my main report and all looks good. What I can't do is create the right formula or place the right formula on the report to get a total of these figures in the report footer.

 

Report looks like this

details a;

 

@sumtotal

whileprintingrecords;

numbervar sumtotal:=0;

 

details b;

subreport

 

details c;

@sum of shared

whileprintingrecords;

numbervar sumtotal;

shared numbervar lineamt;

sumtotal:=sumtotal+lineamt; (this calculates and displays fine)

 

RF;

whileprintingrecords;

numbervar sumtotal;  (this displays as 0)

 

What I need is a total of 'lineamt' in RF.

 

What have I done wrong??

 

Thanks very much

 

since you want a total of all lineamt, remove the formula that resets the total to 0.  Does this give you what you want?

 

If you want a total for a group and big total for the report, create another variable and increment that one as well, but never reset it, this way it will be the total for the report.

 

HTH