Re: HELP---Report 2.5

Andrew M. Balshem <am_balshem_at_fccc.edu> wrote in article <33b91213.21464744_at_news.services.fccc.edu>...
> I would like to produce form letters such that if a person has a value
> for an "address2" field then the field would be displayed - otherwise
> it would not and we would not be left with a gap (a null line) in our
> report.

You can do this by using a format trigger for this field. Look the 'General Layout' tab of the properties, there is a button 'Edit ..' for this trigger.

If this trigger returns true, the field is displayed, else it is left out. In your case it should look something like this :

function F_address2FormatTrigger return boolean is begin
  IF address2 is null THEN
    return (FALSE);
  ELSE
    return (TRUE);
  END IF;
end;

Adapt it for your own fieldname, and it should work.

Hope this helps,

Bram Schiltmans

• The world is like a playground for grown-ups, so enjoy your visit. **