Move the Description to H2. Kyle <[EMAIL PROTECTED]> wrote:
>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 > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
