Jim,
It sounds like you may have found a solution but I
thought some of my past experience may help.
I've noticed when working with variables in reports
or forms that after a while of adding and changing them
during the course of development they sometimes appear to
be working incorrectly. Nine times out of 10 a reboot of
the windows OS solves the problem for me. Seems windows
losses track or something. Of course I'm assumming you are
using R:BASE windows versions.
On Thu, 12
Jul 2001 11:34:18 -0400 Jim Limburg <[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
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
