Are the F1 breakpoints correct?? They appear before the F2 so I was wondering if they displayed correctly.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kyle Sent: Friday, October 24, 2003 3:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Reports Okay. that worked. Thank you very much. I have one more problem (for right now anyway) I have a report with the following variables and layout Report: Budget 1: DOUBLE : D : mtd = ((nint(100*mtdtot))/100) 2: DOUBLE : D : ytd = ((nint(100*ytdtot))/100) 3: DOUBLE : D : crmtd = sum of mtd 4: DOUBLE : D : crytd = sum of ytd 5: REAL : D : crhrsum = sum of ytdhrs 6: REAL : D : crothr = sum of ytdothrs 7: DOUBLE : D : mtdsum = sum of mtd 8: DOUBLE : D : ytdsum = sum of ytd 9: REAL : D : hrsum = sum of ytdhrs 10: REAL : D : othrsum = sum of ytdothrs H1 description of breakpoint F2 Description of 2nd breakpoint crmtd crhrsum crothr crytd F1 Total by 1st breakpoint mtdsum hrsum othrsum ytdsum I reset crmtd,crhrsum,crothr,crytd variables at F2 and reset mtdsum,hrsum,othrsum,ytdsum at F1 Only the first line of F2 is correct. After that all calculated variables are wrong. Thanks, Kyle. At 03:42 PM 10/24/2003, you wrote: >Hey Kyle, > >You have separate you thinking on reports, just because you are not >showing any detail in the visualization of the report doesn't mean you >can't calculate on the detail level > >Ben Johansen - http://www.pcforge.com >Authorized Witango & MDaemon Reseller >Available for Witango Developement > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kyle >Sent: Friday, October 24, 2003 12:48 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - RE: Reports > >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
