Generate multiple Excel sheets based on parameter value

Sonia Choudhary

Hi All,

We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel output where the number of sheets depends on parameter value dynamically.

If parameter X is A, all three sheets (A, B, C) are generated in Excel, if parameter X is B, only sheet B is generated, if parameter X is C only sheet C is generated. How can I create this in rtf template or Excel? I tried using rtf and splitting on multiple pages, but each page has different columns.

Could you please recommend the steps to achieve sheets dynamically.

Subha_Tripathy-Oracle

Hi @Sonia Choudhary ,

Thank you for visiting and posting in Fusion Data Intelligence(FDI) Product Community Page.

This forum is for FDI product and looks like your question is for Fusion Applications.

Please note that this Question is for Fusion Apps and it is managed in our sister community, which can be found at the below links:

Oracle Cloud Customer Connect :

Welcome to Cloud Customer Connect
https://community.oracle.com/customerconnect
Oracle’s premier online cloud community
Please make a note of the above URL and visit those Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

Thanks
Subha