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

oracle bi-publisher
Superdooperhero picture Superdooperhero · Aug 20, 2013 · Viewed 35.3k times · Source

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 dissappear? 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.

Answer

foobarbaz picture foobarbaz · Aug 26, 2013

In BI Publisher properties for the field check Force LTR option

enter image description here

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

Related questions

Oracle BI Publisher auto width of excel columns

When creating a BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to specify that a table should use auto width for the columns in the Excel output. By default, when you …

Read More
How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy …

Read More
Login details to use Oracle BI publisher desktop

I have installed Oracle 10g database and Oracle 10g developer suite. I am beginner to use Oracle BI publisher for making reports. Today i have installed Oracle BI publisher desktop for making reports in ms-word 2007. when i try to log …

Read More