Posts

Showing posts with the label BIP pre-formatted numbers in XML

Apply number locale dynamically

Image
Number format in Bi Publisher. If i have a requirement to display different locale number format in same report, how am i supposed to do it. Probably, the locale will be available in the xml itself, How do i use that display the number format for that locale correctly as needed. Oracle has provided with number formatting function, i already have discussed few of them before. There was a question about this in the forum. Here is the real example of how to do it.

decimal separator

Image
How to change the grouping to decimal separator. Here are few examples, how to do it. There are more functions available, but these would be help to people who would love to start from simple. Note : add the first two lines inside the form-field.

BIP: Pre-formatted numbers in XML

Bascialy , the numbers should be in raw format in xml, so that BIP engine applies or calculates what ever we needed, and for display purpose in RTF template , we can add the formatting. But, Even if the xml contains p re-formatted tags like this. SAL>10,000,000.00 Use translate to remove all the comma's if you use this translate and pass translate(SAL,',','') , the output is 10000000.00, which looks as raw. now you can generate the xls from this. cant we ? ?format-number: translate('10,000,00.00',',','');'PT999G999D99;( PT999G999D99)'?