Thanks for the help. I'll just select to a table with a random filename, clear the values that I don't want, and run the report on that.
Thanks,
Chris
>I cheat! I run my query to a read/write cursor with a field for the subtotal you want, then update that field using a SELECT DISTINCT.... or other means. Since you're working only with the report cursor this step is usually very fast.
>
>When the report prints, it prints the subtotal like it prints every other field with the header information - just once. If I need final totals, I will sometimes make a separate 'totals' cursor, index it and relate it to the original.
>
>HTH
>Barbara
>
>>First a little explanation, then the problem:
>>
>>Lets say you have a report that prints invoices (some header information, followed by one or more detail lines).
>>
...
>>
>>VFP 6.0, using the VFP report writer.
>>
>>Thanks,
>>Chris Vesper
>>
softdev@yahoo.com