>In code, I want to open the FRX and suppress printing of all text and fields that are in the report footer.
>
>I don't know what the FOR clause should be below:
>

REPLACE supexpr WITH .F. for XXX

>
>I know the report footer is here:
>

OBJTYPE = 9 and objcode = 7

>
>But how do I find all the appropriate text and fields that are in the report footer?
>
Cyril

Just the quick answer (maybe somebody will add up the links)

XXX seems to be some boolean. Or an hint that you should use an expression <g>

The placement of a field is defined by its position. The footer is the lowest on a report, so anything with a VPOS larger or even then the grouping record ( OBJTYPE = 9 and objcode = 7) should be within the footer.
There are some little troubles if you place an item slightly above of the footer. I know there are some consts to calulate the distance, but you will figure this one out by try and error if you realy need it.

Try something like (untested)

UPDATE Cur1 SET;
 supexpr = ".F.";
 from somefrx AS Cur1;
 inner join (;
  select;
    Cur2_1.vpos;
    from somefrx AS Cur2_1;
    where Cur2_1.OBJTYPE=9;
     and Cur2_1.objcode=7) AS Cur2;
  on Cur1.vpos>=Cur2.vpos

HTH
Agnes