DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: REP-2103 Error

  1. #1
    Join Date
    Sep 2000
    Posts
    33
    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.

  2. #2
    Join Date
    Jan 2001
    Posts
    153
    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..
    Vijay.s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width