>Hi all,
>
>I will like to do the below report:
>
> Staff# Earning Type Amount
>--------------------------------------------------------
>Cost Centre: 110
> 0001 01 100.00
> 02 50.00
> 03 30.00
>
> 0002 01 50.00
>
> 0003 01 20.00
> 04 30.00
>..................................................
>Total for Cost Centre
> 01 170.00
> 02 50.00
> 03 30.00
> 04 30.00
>
>Can someone advise me how/which method I can approach to get the total for cost centre since it is flexible? Can i use array variable to store and print in the group total?
>
>Regards

VFP9 supports multiple detail bands, and you could use another cursor that has sums in it through a relation. Check Cathy's samples.
Cetin