Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Wednesday, April 16, 2014

Excel output display problem in XML Publisher Report

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?


Answer:
----------

Try with the below XML tag.

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

No comments:

Post a Comment