>>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.
>
>BarryYou 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...