Wednesday 18 March 2015

Automatic content re-sizing in BI publisher reports

Oracle developer sometime facing the issue content re-sizing not done automatically in RTF templet. we have  provide the solution for this problem. 

Step 1: select whole rtf layout and open table properties 

  



















Step 2: Uncheck  row size and repeat headers options.

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