>I am writing a complex report using several VFP data tables. Within this report, I also use a few variables to calculate a total. This report has three different amount fields. The first one is a calculated total, the second is directly from a data table and the third is calculated difference from either the total amount or from the data table amount.
>
>My first question is . . . Because I use several data tables; the calculated total amount shows several times. When this variable is repeated I need for the amount to be zero (other calculations are made from this amount). But I need to see all the other information from the other data tables. How can I zero this amount out?
>
>Also within this same report, I need to have the calculated difference from either the total amount or from the data table (depending if the calculated total amount is not 0). How do I do this?

I have found the fastest, easiest way is to get the data right before going to the report. Select into a cursor with the information you want to display and then just rip through it. Otherwise, it sounds like you need grouping and report vars that reset on group.