Multiple sheet excel report template generation in Oracle BI Publisher 10g

Objective:

To create template for generating multiple sheet excel in Oracle BI Publisher 10g.

Solution:

Template Creation - EXCEL

Step 1: Excel contains the below template with Sheet 1 and 2 as follows




Step 2: Go to Formulas => Name Manager – See the XDO call

Step 3: Go to Sheet2 (XDO_METADATA) – See the XSLT code

Step 4: Come to Sheet1 – See how the groupings were done

Note:  
Ø  Workout example screenshot shared below.  
Ø  Template has been attached separately with this component.

Output: Output will be multiple sheets.


Comments

Popular posts from this blog

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

Querying Data From Flat Files in Oracle

Number of Tables by The Number of Rows in Oracle Database

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Highlight Data That Meet Certain Criteria in Oracle APEX Report

Return a Validation Message using JavaScript if the Oracle Application Express Item is Empty

Remove X (Close Mark) from Oracle APEX Modal Dialog

Display User Rating Icons Dynamically in Oracle APEX Report

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Find Where Specific Table or View is Used in Oracle Database