I have 1 main report and 3 subreport (in 3 diff.detail row). I used a Shared Variable to get the total Amt of these 3 subreports. But whenever, I sum up the 3 amounts in the main report I could not get the right answer.

Ex.

Group-Name header: Name1

detail a:    subreport 1     total 300

detail b:    subreport 2     total 400

detail c:     subreport 3     total 100

Group-Name footer:         800

 

Group-Name Header: Name 2

detail a:   subreport 1     <no value>

detail b:   subreport 2     <no value>

detail c:    subreport 3     <no value>

Group-Name Footer:       800  -- this is my problem.  my formula for this is

                                                   (sub1+sub2+sub3) --refers to shared var

 

Please help!!!

thanks

 

 

 

WhilePrintingRecords;

Shared Numbervar ap_curvar:= 0;

 

and in the subreport

whilePrintingRecords;

Shared Numbervar ap_curvar:=ap_curvar + (sum({@apvar}))

 

@apvar --pertains to the data field

 

still.. the result is the same.. i even tried to use Total formula first in the subreport and point it to the main report.. same result :(.. and the last thing i did was I tried to put declare the "ap_curvar" in the group selection formula.. but i get the error that this variable will be evaluated later. this means that i cannot use this variable since i used it as shared var in a whileprintingrecords evaluation time of the crystal report.

 

Pls.. help :D

Thanks,

cathy

 

OR you can have the grand total variable and just increment it every time you increment the other variable, just don't reset it to 0

 

Hope this helps