CSV and TTX export formula error - work round or fix required

[CrystalMartinC]

Hi all,

I have got trapped by two bugs in Enterprise. We regularly export very large reports which are extracts of data for user analysis. The users prefer to analysis the data in MS Access. The CSV and TTX exports corrupt the data if a formula is placed in the total line and exported. If the formula retrieves data from a variable and that variable is used in a previous formula (on a detail line that is hidden) with WhilePrintingRecords and the total line formula uses WhilePrintingRecords the formula only exports the last value processed in the detail line formula read.

Example
Rec a val 100 (hidden selected)
Rec b val 200
Total line printed 300 but if exported with CSV or TTX 200 (300 if not hidden)

Detail Formula
WhilePrintingRecords;
numbervar wrktotal;
if datafieldx=10 then
wrktotal := wrktotal +val
else
wrktotal:= wrktotal;
wrktotal

Print Formula
WhilePrintingRecords;
numberVar wrktotal;
wrktotal

If you export to Excel or plain text it works fine.
Unfortunately the export to Excel times out even though we have applied all correct fixes and has got Crystal support beaten. The export to CSV or TTX is preferred as we do not have to reformat all the reports and does export large reports.

I have sent the report to Crystal support but they are total unhelpful in fixing the bug in their system.

Thanks in advance for any help