• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Output Multiple Excel Sheet

Hi All,

I would like to print excel output with one group of data in one sheet.
Eg. I want to run finance report for multiple Business units. I want to print each business unit data in separate sheet.

Can anybody share some knowledge on this, if it can be achieved.

Thanks & Regards



VIP Member
Is it okay to call report with different data selection using ER. So you will get different excel sheets for different business units.
Hi Rauf,

Thanks Mr.Rauf for the replly. I would like to achieve this in BI Publisher and not in JDE output.


Abhishek Chhajer

Well Known Member
It can be achieved with ease. Actually, it is one of the main reasons behind using Excel template.
Just add below in your data constraint.

Data Constraints:
XDO_SHEET_? <?Split by XML tag?>
XDO_SHEET_NAME_? <?description of your xml tag?>