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!

Problem while generating Excel Output with XML Publisher Report

Discussion in 'Oracle Forms and Reports' started by sambuduk, Feb 17, 2012.

  1. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    I have to display my XML output in Excel format. I want the output of INVOICE NUMBER column to be displayed as is it is from the data base.

    But the problem is if invoice number having zero with prefix then the zero’s are not displaying…



    i.e 002345 is displaying as 2345 only (EXCEL)


    But this will works fine in PDF output, but its not working for Excel output.

    Help me...

    Regards
    Samba
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
  3. nep84

    nep84 Active Member

    Messages:
    4
    Likes Received:
    3
    Trophy Points:
    85
    Location:
    NJ
    did you try concatenating the invoice number in double quotes? I assume you have reports generating the xml? make a placeholder in the report and set it to '"' || invoicenumber || '"'. see if that works.
     
    Ecor likes this.
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Sambudu,

    Use below Syntax.

    <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?INVOICE_NUMBER?></fo:bidi-override>

    Hope this will help you...
     
    Ecor likes this.
  5. Ecor

    Ecor Active Member

    Messages:
    20
    Likes Received:
    3
    Trophy Points:
    90
    It is useful discussion