Found it, but it was already set to on..
Curious though one of the variable in the report does stay around
vname...
It's only in the report so RBase(6.0a) is not cleaning up so well...
hmmm
I'm going to set code after the report to clear all these variables -
couldn't hurt I guess.
Jim Limburg
Albert Berry wrote:
>
> Jim, set Clear Var after printing on. It's in the Layout menu somewhere.
>
> [EMAIL PROTECTED] wrote:
> >
> > G-Day all
> >
> > Before I make this change I wanted to bounce this question off of the
> > list.
> > I am seeing a cute little quirk that I am sure someone has seen before.
> >
> > What is happening is the user entered about 100 rows of data, runs the
> > report and found the totals off.. She then found that she had left out
> > one row of data. She re-entered the row of data. Then preceded to run
> > the report again.
> > As the report is run again it shows the ClaimTypes for Employees
> > first, then the break point changes to dependants. The totaling for the
> > first section (employees) is showing the total as if it had added up the
> > employees and the dependants, but the second breakpoint is showing the
> > correct totals for the dependants alone as it should...
> >
> > For some reason after the report is run once RBase is not clearing the
> > totaling var before it get's the first breakpoint. What can be done
> > about this?
> >
> > I think I found the answer -- Is it that the VTYPE is in the Detail
> > section
> > and should be in the PH section where it is located on the report?
> >
> > The report (CLAIMCK) is based off of a view defined as:
> >
> > View: clmcomb
> > SELECT T_1.*,T_2.LASTN,T_2.FIRSTN,T_2.MI FROM CLAIMS T_1,HEADER T_2
> > WHERE (
> > T_1.SSNUM = T_2.SSNUM )
> >
> > Expression listing for the report CLAIMCK
> > 1: NOTE : D : VNAME = (FIRSTN & MI & LASTN) FROM
> > HEADER WHERE SSNUM = SSNUM
> > 2: CURRENCY : D : VCOV = SUM OF COVERED
> > 3: CURRENCY : D : VDED = SUM OF DEDUCT
> > 4: CURRENCY : D : VBENE = SUM OF BENEFIT
> > 5: CURRENCY : D : VCOB = SUM OF COBOTHER
> > 6: CURRENCY : D : VPAID = SUM OF PAIDAMT
> > 7: TEXT : D : VCOMP = FULLNAME IN PLANTS WHERE
> > COMPNUM = COMPANY
> > 8: TEXT : D : VTYPE = TYPEDESC IN CLAIMTYPE WHERE
> > CLAIMTYPE = CLAIMTYPE
> >
> > Break Points are Company and ClaimType with variables vcov, vded, vbene,
> > vcob, vpaid being cleared on ClaimType.
> >
> > The Where conditions for the report are:
> > PRINT claimck WHERE month = .whval1 +
> > ORDER BY company ASC, claimtype DESC, lastn ASC
> >
> > Jim Limburg
> >
> __________________________________________________________________
> Get your own FREE, personal Netscape Webmail account today at
>http://webmail.netscape.com/
