Re: HELP!!! Reports2.5

Andrew,

Put a format trigger on each field that may be null with syntax as follows:

function F_ADDRESS2FormatTrigger return boolean is begin
  if (:address2 is null)
    then return(FALSE);
    else return(TRUE);
  end if;
end;

This will suppress a null value entirely, and reports will bump up the fields below it to fill the gap.

HIH,
-Ian

Andrew M. Balshem wrote:

> 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. For example:
>
> Record 1
> -------------
> 1313 Mockingbird Lane
> MonStars Apts. - Apt 1C
> Hollywood, CA 98989
>
> Dear Herman:
>
> ********************************************
> Record 2
> -------------
> 1234 Fifth Street
> Anytown, PA 898989
>
> Dear John:
>
> ********************************************
> Both record 1 and 2 are in a demographics table but record 1 has a
> value in address2 while record 2 does not. I can easily make record
> 2's letter look like the following:
>
> Person 2
> --------
> 1234 Fifth Street
>
> Anytown, PA 898989
>
> Dear sir:
>
> ********************************************
> but this looks sloppy. I could also build 2 reports - one for records
>
> with and another for records without a value in address2. However, I
> believe that I can accomplish what I want with a trigger on address2
> whereby we could hide the null address2 line and print record 2 as I
> did in the first example of record 2.
>
> Would someone e-mail an example or, at least, the steps in doing the
> above?
Received on Wed Jul 02 1997 - 00:00:00 CEST