Output Multiple Excel Sheet

[gopucreddy]

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

Gopu

 

[Rauf]

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

 

[gopucreddy]

Hi Rauf,

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

Regards
Gopu

 

[Abhishek Chhajer]

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