[RBASE-L] - RE: Reports

[Kyle]

There isn't any detail on the reports. It is a summary of 
costs(labor,material,hours,overtime hours,  and total by month to date and 
year to date) by F2 ctrlno(work order number) then F1 acctno(account 
number) then the report footer is a total of all.
I am using RBwin 6.5.  This is so very different than the old reports.

Thanks, Kyle.

At 11:57 AM 10/24/2003, you wrote:
It looks like you need to change where these calculate to the detail section
instead of F2 and F1. Currently they only set to calculate the sum of one
detail item per breakpoint.
   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
Dan Goldberg

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kyle
Sent: Friday, October 24, 2003 8:31 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Reports
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