Reports 2.5 Function Dysfunction

From: Richard Fairbairn <zenith_at_technologist.com>
Date: Wed, 21 Oct 1998 14:49:59 +0100
Message-ID: <70konr$7s8$1_at_roch.zetnet.co.uk>

[Quoted] 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 - 15:49:59 CEST