Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to summarize child records.
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01051255
Message ID:
01051283
Views:
9
>I have a one-2-many report. There are 17 different child records(Species) in the child table. How can I total the volume from each of the child(Species) possibilities at the end of the report?
>
>Thanks for Your Time.

If you don't have any data groups on the report, one option is to create a cursor that contains the totals. create a multi-detail band report using the main table as the first detail band and the temp total cursor as the second 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
Reply
Map
View

Click here to load this message in the networking platform