Agnes

I see. That is interesting. I wondered how the FRX worked it out. Didn't guess that it was based on the position.

Naomi suggested I use flags, which might be easier.

Thanks for your idea.

Cyril





>Cyril,
>
>it was just out of the hip.
>
>A closer look the table reveals that the bands are piled by height.
>
>The OBJTYPE=9 records are ordered by there position so the topmost in the file is the topmost in the report.
>
>So you need something like
>

>lntop = 0
>scan for OBJTYPE=9 and objcode#7
> lnTop = lntop+height
>endscan
>
>locate for OBJTYPE=9 and objcode=7
>lnbottom = lntop+height
>
>Note the real boundaries are a bit larger
>
>UPDATE Cur1 SET;
> supexpr = ".F.";
> from somefrx AS Cur1;
> WHERE Cur1.vpos between lntop and lnbottom
>

>
>Agnes
>>You are saying that the VPOS field can be used to determine which band the report field is in.
>>
>>I don't see how to do this. The VPOS for the report bands records are empty.
>>E.g: if I browse the FRX, and go to the record:
>>

OBJTYPE=9 and Cur2_1.objcode=7

>>the VPOS is empty. So that cannot be used to determine the report footer fields.