Skip to main content

Posts

Showing posts from July, 2014

Oracle BI Publisher - Leading zeros truncated for excel reports - format numbers as text

When you want to display some data which has leading zeros in EXCEL output you will not get the desired output. But in PDF it will come as what you are expecting. This is not with the issue of your data. This is due to the unique nature of EXCEL cell format. When you are trying to put a text data in a cell without making any change to cell format it will treat as number and it will truncate all leading zeros and all trailing zeros after ' . ' . So what you have to do is to convert that data into a format which EXCEL can treat as text.   1. In the rtf template, add two spaces before the column. 2. Use the following xml tag <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?>”.  Excel treat value as character and doesn’t trim the leading zeors of value....

Multilanguage Report in Oracle BI Publisher Using XLIFF Method

There are two options for adding translated templates to your report definition: ·          Create a separate RTF template that is translated (a localized template) ·          Generate an XLIFF file from the original template (at runtime the original template is applied for the layout and the XLIFF file is applied for the translation) Use the first option if the translated template requires a different layout from the original template. XLIFF (XML Localisation Interchange File Format) is an XML - based format created to standardize the way localizable data are passed between tools during a localization process. Generate an XLIFF file from the original template (at runtime the original template is applied for the layout and the XLIFF file is applied for the translation) Each <source> element contains a translatable string from the template in the source language of the...

Dynamic Number Format in BI Publisher

Requirement: Display different locale number format in same report. For Example I need to display a Price column in different number format. For English it should display 1,234.00, for German 1.234,56 and for Italian it should display 1'234.56 Solution: English: <?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'EN-us')?> German: <?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'DE-de')?> Italian: <?xdoxslt:xdo_format_number_l(PRICE,’999G999D99’,'IT-ch')?> Output: