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!

Invoice Number Format In XMLP Report Output as Excel

Discussion in 'Other Development Tools' started by jagadekara, Jul 30, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Recently I come across one issue. I have a XMLP report which is giving excel output. So when I ran the report, In invoice_number column it is showing 2.01213E+12

    But actually Invoice number is 2012131000014.

    If it is 2012131000015 also it will show as 2.01213E+12.

    So I tried many times with different formats and finally find below answer.

    In rtf for invoice tag used like this.

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

    Now when I ran the report it is showing Invoice Numbers as it is.