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
