Update!
Sorry, I did not notice the different question immidiately.

My recommendation is always to do most of the data handling/computations in VFP. Create cursors, and use them as input for your reports.

>The request says that they would like the last six months usage (total if 6 months not possible) This is a foxpro database, with a field called dtuse and usage out of about fifty fields
>
>I think, I can either write a query in either foxpro or crystal.
>
>What are your suggestions?
>
>
>Thanks
>Jim