If the output type is Excel, use the =”” workaround and if it is PDF then display it normally since the values wont be modified anyway. The final solution to this problem then is to query the FND_CONC_PP_ACTIONS table at runtime to determine the output type of the report. This leads to a new problem – if an user chooses to display the report in PDF format, the values are surrounded by the = and “” symbols.

Well, a workaround is to write the form field in the RTF in this format =”” This is because of the special characters which are automatically added before and after the actual values. This, however, leads to the situation where Excel functions such as SUM, AVERAGE etc do not work on the values which are displayed using the fo:bidi-override option. One way of preventing this is to use fo:bidi-override. Click the Templates tab on the left sidebar. To apply the Chart Template to an existing chart: Right-click the existing chart and choose Change Chart Type. When displaying numerical data in BI Publisher report using the Excel format, leading zeros in the output values is removed automatically by MS Excel. A new chart will be inserted on the sheet and all of the Template's formatting options will be applied.

Bi publisher excel template pivot