You can run a couple of queries before report to accumulate those data into arrays. This way it wouldn't be affected by previewing/printing.
>I have several old reports not using the report designer that print sub-totals and grand totals that have been accumulated to arrays. I did some cutting/snipping etc. and have a "sort of" sample at the end of this post. If I use the VFP preview feature detail records seem to be processed every time I page forward/backward in the preview. If I advance to a sub-total group the amounts are one thing. If I then back up a few pages and forward again to the sub-totals are different. As part of the group footer band, the final field is actually a call to a UDF that zeroes out the accumulated amounts stored in the arrays. Everything works fine when I print to the printer. I've tried printing to an ASCII file then doing a MODI FILE
and that works OK but I have additional formatting problems to address and the report looks tacky -- though not quite as bad as the following cust&paste. Any suggestions out there regarding the previewing problems?
>TIA
>Scott
< snip >
--sb--