I usually name my vars vf_xxxx for forms, vr_xxxxxx for reports,
vg_xxxxx
for global and so on myself in new stuff I am creating, but I inherited
the majority of databases I have from my boss. I usually am able to
issue
a clear var vr_% or vf_%, but since these V variables are created in the
report, I don't know if RBase would choke or not if I tried to clear
them,
do you?
I am not using any counter in this report, but that's good to know
I should have mentioned that this is DOS 6.0a as well.
Thanks
Jim Limburg
Troy Sosamon wrote:
>
> 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
