I have written a formula column in a matrix report. I want to display a zero instead of a blank field where there are not recordd. When I run the report I get the error REP-2103: Column 'Zero_disp' PL/SQL formula returned invalid or no value. How do I trap this error. I have tried the no_data_found and SRW.DO_SQL_FAILURE and others. All these failed. Any Ideas.
u donn require to write a seperate code is the value is null...s check the properties and give the value as 0 IF null..that is the straight approach..
if u could ctrl-c and ctrl-v it in the forum i can check the existing formula column...
the only reason that could happen is when the formula is not returning any value..that could be due to exception or could be due to missing RETURN statement in the approriate place..