Wednesday 18 March 2015

Oracle BI Publisher - How to format numbers as text so that leading zeroes don't dissappear

When creating an Oracle BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to format numbers as text so that leading zeroes don't disappear? I would like to print out telephone numbers and they have values such as 0215551234; where I want the leading zero to show. In BI Publisher this shows as 215551234.

You can put the following in form field help text

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

                                                                         OR
Check --Force LTR option








No comments:

Post a Comment