Hello again Power

The problem is that in your last column you have hidden fields and these are being summed, hiding them using print when will only hide them but VFP treats them as if they are still there.

To avoid this then wrap the expressions you are using in your last column as follows

yourexpr=the expression you are using to hide them in the print when dialog

lastcolumn=what ever you have in the column at present

IIF(yourexpr=.t.,lastcolumn,0)

hope this helps



>Oops I forgot to click Jorge and Mark's name so I now send again.
>Jorge, in fact I don't have a "year" total, the following will show more clearly about my case.
>Mark, I have tried to select all the "End of Report", "End of Page", "Month" band in the "Reset at" of the property window, all can't give my need.
>
>Sorry that I forgot to preview my message before sent so all the data in the report I wanted to show were messed up. Now let me try your suggestion to use < PRE > to make my report look tidy.
>

>$ received in   $ received in           Commision                  Commision
>last month      this month            in last month               in this month
>********************************* Nov ******************************************
>10000                 0
>    0                 4500
>10000             10000
> -----------------------------------------------------------------------------------------------------
>20000             14500                     4000                              2900 <------ Total of a month, Group by month
>
>******************************** Dec ******************************************
>20000             10000
>    0                    0
>10000             10000
> -----------------------------------------------------------------------------------------------------
>30000             20000                     6000                              4000 <------ Total of a month, Group by month
> ----------------------------------------------------------------------------------------------------
> Total of Commision in this month:                                       9800 <------ Total should be 2900 + 4000 = 6900 in this example.
>

>
>The formula to calculate the commision in this month is :
>Total $ reveived = total $ received in last month + total $ received in this month
> if the total $ received < 50000, the commision rate is 0.2
> if the total $ received > 50000 and < 100000, the first portion of commision is 50000 x 0.2 = 10000, the second portion of commision will be x 0.25.
> if the total $ received > 100000 and < 200000, .........., etc.
>So the commision of this month = total commision - commision already got in last month.
>For example, commision due to Nov = (20000 + 14500)*0.2 - 4000 = 2900
>commision due to Dec = (30000 + 20000)*0.2 - 60000 = 4000
>So the total commision in this month = 2900 + 4000 = 6900 which is the final result I want to have in my report.
>Hope it is much clearer. Thanks for help. I have been studying this problem for more than a week, my mind cannot run now.