Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grand total from repeating values in fields
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00507483
Message ID:
00507656
Views:
19
Claude,
I've had the same problem with the VFP Report Writer. When I want totals like this I do a separate report cursor with the account number and the totals I need, then link it to the first cursor by the account number. Don't forget you can index cursors just like tables so it's simple to set a relation.

HTH
Barbara

>I create a cursor which combines repeating information, i.e. an account no, requitsion number, total for account form
>a table and equivalent total as a calucation, total for requitions, and line item valuses for a requistion. Data is pulled
>together from several tables and is checking for inconsitancies in between various totals. so I could have
>
> acct # , req # , total from table , calculated total, etc
> a 1 11 10
> a 2 11 10
> a 3 11 10
> b 5 22 20
> b 5 22 20
>
>that is totals for acct # a are 11 and 10 and differences is 1, and for account b they are 22 and 20, and difference is 2.
>The grand total should be 33 and 30 and difference is 3. How can I do this (I would like results printed in table summary)?
>My attemps either give me valuses for last record or sum of all values, i..e. 22, 20, 2 or 77. 70, 7.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform