Sunday, June 1, 2014

XMl syntaxes

To display number in words
xdofx:to_check_number(12345.67, 'USD') 
Good link - https://blogs.oracle.com/xmlpublisher/entry/numbers_to_words_update

format-number:PaymentAmount/Value;'999G999D99'
xdofx:lpad(PaymentAmount/Value,12,'*')

xdoxslt:lpad(format-number(number(PaymentAmount/Value),’###,##0.00’),13,’*’)
https://community.oracle.com/thread/634899?tstart=0

Exponential number fix
fo:bidi-override direction="ltr" unicode-bidi="bidi-override">

Ref issue
----------

In MS Word, under BI Publisher-> Options, set Form Field Size to Backward Compatible instead of removing tags

------------
Change decimal format in RTF template

Create a field on top of RTF file like below.  Create some dummy field.



In field use like below


----

No comments: