Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Previewing problems - group totals wrong
Message
 
 
To
09/09/2002 17:13:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00698523
Message ID:
00699171
Views:
16
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform