Victor - I've faced this situation before and each time I eventually found that my logic was faulty in the construction of the procedure in some way. If the problem is consistent however, why not total it and deduct one to get the right answer?
On Mon, Jan 11, 2010 at 4:58 AM, Victor Warner <[email protected]> wrote: > I am having a problem using report variables to produce a total count of > records (a subset of the total records in a panel) - consistently the > total count produced by the report is one more than the records meeting > the criteria chosen. For example, in P1F10 (a U18 field), if there are 4 > records which contains "NI308", the count produced by the report will be > 5 not 4. > > > The report is as follows: > > ????FIRST PAGE HEADER????????? > -----Store Value in Report Variable 10 ----- = 0 > -----User Chooses Next Record By LookUp---- > -----Store Value in Report Variable 1 ----- = P5P10 > > ????REPORT BODY??????????????? > -----Store Value in Report Variable 10 ------ = rv10+1 > -----Store Value in Report Variable 2 ------- = P1F10=rv1 > -----Stop [Sub]Report if 0 Is in Report Variable 2 ----- > > ????FINAL FOOTER??????????????? > Print RV10 = G999 > > Help with this would be greatly appreciated. > > Victor Warner > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
