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!

Excel output display problem in XML Publisher Report

Discussion in 'Oracle Apps Technical' started by jagadekara, Apr 15, 2014.

  1. jagadekara

    jagadekara Forum Guru

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

    I have one xml publisher report which is giving excel output.

    Query:

    select period_name from gl_periods where period_year=2014 and period_num<13

    It is giving output as 14-Apr, 14-May, 14-Jan

    but I need to display it as Apr-14, May-14, Jan-14

    In toad also I am getting correct manner but problem in excel.

    So how can I achieve this problem?
     
  2. sambuduk

    sambuduk Forum Advisor

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

    Try with the below XML tag.

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

    Regards
    Sambasiva Reddy.K
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thank A lot Sambasiva... It's working fine.