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

Discussion in 'Oracle Forms and Reports' started by DEEPAK THAPAK, Sep 20, 2013.

  1. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Dear sir,
    how to avoid null or zero value data from xml report, here i attached all related document,plz find

    Thanks & Regards
    Deepak Thapak
    9915785787
     

    Attached Files:

    • DATA.rar
      File size:
      615.2 KB
      Views:
      15
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Requirement is not clear... Do you want to reject records holding null and zero values or needs to replace the zero and null with other values ???

    and on which column do you want to accomplish this task ???
     
  3. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    to reject records holding null and zero values.
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    mention column names.... there are no null records in the given sample data....
     
  5. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    We are not to want print record if cr amount or dr amount having null or zero value.
     
  6. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Dear sir,
    We are waiting for your reply....
     
  7. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Deepak,

    Condition can be inserted in sql query itself..

    ex: where (cr_amt is not null and dr_amt is not null and cr_amt > 0 and dr_amt >0)

    if you want to print any dynamic labels add it in rtf template..
    ex: <?if:FACTOR_DISCOUNT_AMOUNT!=''?>Bank Charges<?end if?>


    Please let me know the status.
     
  8. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Hi...
    we want to avoid in rtf only, where we insert this condition,i have already sent related data,plz do in rtf.
     
  9. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Try with the attached file.


    Regards
    Sambasiva Reddy.K
     

    Attached Files:

    kiran.marla likes this.
  10. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    It's working......thanx.....
    how you enter if1 condition?? plz clarify me.
     
  11. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    how we enter this condition (cr_amount!='' or cr_amount!='0' or dr_amount!='' or dr_amount!='0') in attached file.
     

    Attached Files:

  12. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    Iam waiting...........................
     
  13. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Deepak ,

    Sorry for late response. Try with the attached modified file.


    Regards
    Sambasiva Reddy.K
     

    Attached Files:

  14. DEEPAK THAPAK

    DEEPAK THAPAK Active Member

    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    No need to say sorry.....it's working......
     
  15. 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