Bob
I appreciate the advice.. I am using the DOS6.0 version right now
getting
ready to bring it to our newly purchased DOS6.5 and then Win6.5
versions.
We have found that a DISC and CONN does the trick as well, but we wanted
a
cleaner answer. Going to have to wait until next week to see if it
works,
I have been on a few other little skirmishes<sp> since all this..
Lovin every minute of it..
Later
Jim Limburg
Bob Powell wrote:
>
> 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]
