Search This Blog

Loading...

Friday, August 2, 2013

Excel Template Report using BI Publisher

Excel Template Report:

Most of the people knows that XML Publisher Report can only be build using RTF File. However, latest version of BI Publisher 11.1.15 onward has flexibility to create XML Publisher Report in Excel too.

Advantages:
a) If one of your client ask you to develop a XML Publisher report in multi-tab excel format, we generally say that it is not possible using XML Publisher. But now, it is possible using Excel Template Report.

b) If one of your client ask you to prepare a XML Publisher report where formulas should be visible as like in Excel,  we generally say that it is not possible using XML Publisher. But now, it is possible using Excel Template Report.

c) Splitting of Data into multiple tabs based on conditions

d) Split hierarchical data across multiple sheets and dynamically name the sheets

e) Create sheets of data that have master-detail relationships

f)  Use native Excel functionality

Disadvantages:
a) RTF Report is easy to design in comparison with Excel Template Report.

b) RTF Report is easy to debug in comparison with Excel Template Report.

Please find the below link for Excel Template Report:

http://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm#exc_xslt_tr