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>
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