Re: Reports 2.5 Function Dysfunction

It could be that your formula field is under the null field, so that it is never shown.

A 'dirty' method I used, is to put boilerplate text "**Null**' in your layout and put a format trigger on it, with code like

begin

   return(:numeric_column is null);
end;

and on your numeric column something similar:

begin

   return(:numeric_column is not null);
end;

I've used this for displaying a horizontal line in a matrix report.

Richard Fairbairn wrote:

> I am attempting to show a numeric column in my report as **Null** when the
> value is null. In order to facilitiate this I thought I'd hide the original
> column and create a formula column which would have the formula:
>
> Function so_and_so return char is
> returnvar char;
> begin
> returnvar := decode(:numeric_column, null, '**Null**', :numeric_column);
> return returnvar;
> end;
>
> This raises an error. So, to test things I thought I'd create a formula
> column with the formula:
>
> Function so_and_so return char is
> returnvar char;
> begin
> returnvar := 'Hello';
> return returnvar;
> end;
>
> This stil does not work and I don't understand why. Can anyone help?
Received on Wed Oct 21 1998 - 20:40:46 CEST