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/
