Cheers - now I see how it can be done. It is still a bit of a kludge I think but I guess you get used to them in the VFP report writer :)


>---
>I would love it if the report writer in VFP9 let you sum report variables once per group instead of by detail.
>---
>
>It does let you do that. This is just an IIF() problem, requiring two reportvars.
>
>Dragan's already given you one way to solve it (with a cGroupExpr reportvar).
>
>You can also make the second var a boolean instead of a char type. For example: lNewGroup, which initializes to .T., is reset on group, and has the value-to-store of .F..
>
>Now your value-to-store for the other var is can be something like IIF(lNewGroup, yourVal,0) and you can set this var to sum; there are lots of other variations.
>
>Whether you use a group evaluation as Dragan showed you or this logical method (which I find a little easier to adapt to multiple circumstances), as he told you, the order of the two vars is critical. The vars are going to be evaluated in the same order as you define them in the Report Variables dialog.
>
>>L<