Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Total Value on a 2-band report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178103
Message ID:
01178435
Views:
14
>Cathy,
>I realized that I did use the wrong terminology in my title of the thread. I should have said report with 2 detail bands. Sorry for confusing you and probably others.

Ok ... The issue is that you have to understand how VFP does calculations when multiple detail bands are used or you get really confused. If you create a variable and tell it to COUNT and have the RESET AT value at End of report, it will get processed once for each parent record, once for each Detail1 band record, and once for each Detail2 band record. Usually this isn't what you want and you end up with off the wall values.

If you only want to count the records in detail1 band, this is what you have to do. Mark the variable as COUNT, and change the RESET AT value to Detail1 Band. This tells VFP to ONLY process this variable for the records in Detail1 band. It won't process it for the parent or for the 2nd detail band.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform