Ok. I'm still have problems with my reports. I've listed my variables below.
I am resetting mlabac,mmatac,mactot,ylabac,ymatac,yactot at the F1 breakpoint
I am resetting mlabct,mmatct,mtot,ylabct,ymatct,ytot at the F2 breakpoint
My total at the F1 breakpoint is always the same as the last F1.
I have tried resetting the other variables used to compute the above. I have tried using separate variables to compute both areas. This worked fine in my RB 4.5++ and before. Please tell me what I am doing wrong. Thanks in advance. Kyle.


1: TEXT : PH : FISCOF = FISOFF IN ACCOUNT WHERE ACCTNO = ACCTNO
2: TEXT : PH : fiscbox = boxno in account where acctno = acctno
3: TEXT : PH : ACTNAM = ACCTNA IN ACCOUNT WHERE ACCTNO = ACCTNO
4: TEXT : F2 : rodes = wdescrp2 in worder where ctrlno = ctrlno
5: TEXT : F2 : descrp = actdesc in activity where actcode=wactcode
6: TEXT : D : cord = COORD from worder where ctrlno=ctrlno
7: TEXT : F2 : ccord = COORDNAM from coord where .cord = coord
8: DOUBLE : D : mlab = (ifeq(major,210,mtdlab+mtdadj,(ifeq(major,220,mtdlab+mtdadj,mtdlab))))
9: DOUBLE : D : mmat = (ifeq(major,210,mtdmat,(ifeq(major,220,mtdmat,mtdmat+mtdadj))))
10: DOUBLE : D : cmlabint = ((nint(100*mlab))/100)
11: DOUBLE : D : cmmatint = ((nint(100*mmat))/100)
12: CURRENCY : D : mlabint = cmlabint
13: CURRENCY : D : mmatint = cmmatint
14: CURRENCY : F2 : mlabct = sum of mlabint
15: CURRENCY : F2 : mmatct = sum of mmatint
16: CURRENCY : F2 : mtot = mlabct+mmatct
17: CURRENCY : F1 : mlabac = sum of mlabint
18: CURRENCY : F1 : mmatac = sum of mmatint
19: CURRENCY : F1 : mactot = mlabac+mmatac
20: CURRENCY : RF : mlabtot = sum of mlabint
21: CURRENCY : RF : mmattot = sum of mmatint
22: CURRENCY : RF : gmtot = mlabtot+mmattot
23: CURRENCY : D : ylab = (ifeq(major,210,ytdlab+ytdadj,(ifeq(major,220,ytdlab+ytdadj,ytdlab))))
24: CURRENCY : D : ymat = (ifeq(major,210,ytdmat,(ifeq(major,220,ytdmat,ytdmat+ytdadj))))
25: DOUBLE : D : cylabint = ((nint(100*ylab))/100)
26: DOUBLE : D : cymatint = ((nint(100*ymat))/100)
27: CURRENCY : D : ylabint = cylabint
28: CURRENCY : D : ymatint = cymatint
29: CURRENCY : F2 : ylabct = sum of ylabint
30: CURRENCY : F2 : ymatct = sum of ymatint
31: CURRENCY : F2 : ytot = ylabct+ymatct
32: CURRENCY : F1 : ylabac = sum of ylabint
33: CURRENCY : F1 : ymatac = sum of ymatint
34: CURRENCY : F1 : yactot = ylabac+ymatac
35: CURRENCY : RF : ylabtot = sum of ylabint
36: CURRENCY : RF : ymattot = sum of ymatint
37: CURRENCY : RF : gytot = ylabtot+ymattot


Reply via email to