Doubled Totals Fields

[Malcolm_Bentote_(Guest)]

I am trying to produce a report from ^live^ and ^archived^ debts information on a Visual FoxPro database. Both sets of information contain a main debts table with linked separate charges and payments tables. At record level I will have a number of records for each debt equal to the number of charges and payments records for that debt. My problem is that the totals at group (debt)level from the archived information are doubled. For example I create a calculated field called ^newcosts^ which correctly contains 5.00 in the Results Set, but the corresponding totals field ^totnewcosts^ contains 10.00 when I am processing an archived debt.____Is this a bug or am I missing a trick?

[kfleming]

If this is more than a 3 file report, then you have encountered a bug that sometimes occurs in complex multiple scan reports.____Kathleen__R&R Support

[Malcolm_Bentote_(Guest)]

Thanks for your prompt response.____The report actually uses 7 tables. Client which scans debts then archived debts. Debts scans charges then payments and archived debts scans archived charges then archived payments.____Is the bug likely to be corrected?____Is there any way of getting round this probelm?____

[kfleming]

It is the kind of bug whose fixing engenders a high possibility that it will cause other things to break. So we have continued to leave it in place since it has a negative impact on only a minority of reports.____One workaround is to do two reports so that the first exports the base report as a single fixed table and then the second report can correctly do totals since it is evaluating a single file.____Kathleen__R&R Support