You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Generate multiple Excel sheets based on parameter value

in BI Publisher Learning Center

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!