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.

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?>