Re: Disabling lines in Reports 2.5
Date: 1996/11/26
Message-ID: <01bbdb37$49d683a0$8408bacc_at_mctaylor>#1/1
Try using a concatenated field in your SQL statement such as
SELECT street1 ||
DECODE (street2, NULL, NULL, CHR(10) || street2) street2 ||
DECODE (street3, NULL, NULL, CHR(10) || street3) address_lines
etc.
The single field (aliased as address_lines should have carriage returns (CHR(10)) embedded in it. If you put the single field i nto and expandable field on your report layout, it will format properly as a multi-line field. The DECODES simply test the field for null and concatenate either NULL or a carriage return along with the variable.
Good Luck!
Mike
Gary G <ggorbon1_at_swarthmore.edu> wrote in article
<01bbdb1c$54375420$0e433a82_at_gorbonosov.swarthmore.edu>...
> I am trying to print labels using Reports. The table has columns like
> street1, street2, and street3. How can I prevent a line printing for
> :street3, for example, if its null.
> I have tried putting a line into the trigger to set the return to FALSE
if
> field is null, but
> the line still comes out as a blank space. Any suggestions would be
> greatly appreciated.
>
>
Received on Tue Nov 26 1996 - 00:00:00 CET