>>
>>I didn't work yet with multiple detail bands, so I may be way off-track.
>>
>>However, I have seen that conditionally adding a value often helps:
>>
>>The expression in the report variable might be
iif(SomeCondition, 1, 0) if you want to count, or
iif(SomeCondition, SomeValue, 0) if you want to sum.
>
>I tried your suggestion but so far I could not find what to use in the SomeCondition of the expression.
>
>Here is what I tried:
>
>
>iif( fsize("PO_AMOUNT")>0,PO_AMOUNT,0)
>
>
>The problem with above is it is always True. That is, when VFP prints each line and even when it prints a line of Detail 2 which does not have field PO_AMOUNT, VFP returns fsize("PO_AMOUNT") > 0 as True.
How about type() or vartype()?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)