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

Thread: REP-2103 Error

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

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.