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
