1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Avoid null or zero value data from xml report. if there is data display a row

Discussion in 'Oracle Forms and Reports' started by neeta, Sep 15, 2016.

  1. neeta

    neeta Newly Initiated

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    india
    How to write a code
    if there is data in any one of the field (CR_AMOUNT = 0 and DR_AMOUNT =13) the row should display.... if both are zero (CR_AMOUNT = 0 and DR_AMOUNT =0) the row should be eliminted...please help
     
  2. Roberto Spernega

    Roberto Spernega Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Location:
    São Paulo - Brasil
    Hi,

    try where (nvl(CR_AMOUNT,0) + nvl(DR_AMOUNT,0) > 0
     
    neeta likes this.
  3. neeta

    neeta Newly Initiated

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    india
    Thank you so much this worked.