Oracle BI Publisher - Leading zeros truncated for excel reports - format numbers as text
The Problem is that building groups has
a fixed length of four characters, only digits from "0000" to
"9999". Excel suppresses all leading zeros, therefore the first
building groups are to short, e.g. instead of "0010" only
"10" is displayed
Method 4 Here is another way to set format style ‘Force LTR’ in a
programmatic way to prevent Excel from suppressing leading zeros:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?XML_ELEMENT?>
</fo:bidi-override>
<fo:bidi-override
direction=”ltr” unicode-bidi=”bidi-override”>
<?format-number:INVOICE_NUMBER;’09999999′?> </fo:bidi-override>”
3.
Instead of the using the tag < ? INVOICE_NUMBER? >
use =”<?INVOICE_NUMBER?>”.
use =”<?INVOICE_NUMBER?>”.
Open the RTF Template in MS Word. Go to Data -> Load XML Data. Once the data is loaded successfully, double click on that field. Under field properties window set the field formatting type as “Regular Text” and set the check box “Force LTR”.
Method 3 This is the best method I have found, In this method we need to
use an equal-to symbol before the field and enclose the field in double quotes
for example:- =”ENUM” This works only in excel however it will allow you to cut
and paste (ie to use the value to search in Oracle) and also to do vlookups.
Enum with equalto and quotes


Method:
No comments:
Post a Comment