Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parent Child reporting query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01584190
Message ID:
01584328
Vues:
35
>>If I understand what you're saying, then each record in the cursor contains the total for its group. So, as long as you're looking at some record in the group when you print the total, you can just pull the right field from the cursor.
>>
>>If I'm not understanding, can you show some sample data.
>>
>>Tamar
>Yes, that is correct. The issue is (was) that I was wanting a final total for all records - but taking the group totals only once.
>
>Group..........Budg.....Detail
>GroupA_rec1.....5.....3
>GroupA_rec2.....5.....1
>GroupA_rec3.....5.....1
>
>GroupB_rec1.....3.....2
>GroupB_rec2.....3.....3
>GroupB_rec3.....3.....1
>
>Report Totals:
>.........................8.....11
>
>What I have done to get round this is create the cursor and then scan through each record and setting the budget field to zero for all but the first record which has given me the required result.
>
>Barry


You may find Report Variables useful - look in help for "defining report variables".
Also take a look at Cathey (Pountney) Knight's blog from 2008 for other examples of using report variables.
http://cathypountney.blogspot.com/2008_04_01_archive.html
Randy Bosma
VFP - Because life is too short to code in something else...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform