Jim,
I make it a habbit of starting all var names in reports with "R" instead of
"V" and this eliminates problems of vars left over in apps and forms from
conflicting. I start vars in form with "F".
I also remember an old bug in the report writer, and I am not sure if it has
ever been fixed, when you are counting rows of break points the last one is
off by 1 on occassion.
ie you have a counter that is not in the detail section, but in one of the
break sections.
Troy
===== Original Message from [EMAIL PROTECTED] at 7/12/01 9:34 am
>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
