Hello Friends,
Today I am going to show you how to create multi sheet Excel Report in BI Publisher.
1) First go to the below path:
C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\Excel templates. Here you will get an excel file named as "
BlankExcelTemplate" in which we have to create template.
2) Create a Data template file as below:
3) Now we will create all fields and tags in excel file as below:
4) It will show you tag as XDO_?EMP_NAME? for field name and for group it is XDO_GROUP_?EMPS?
These tags can be found under Formula-> Name Manager
5) Now go to the next sheet XDO_METADATA where we will write the logic to split the data for every department.
6) There should be mapping of column A and Column B.
XDO_SHEET_? <?.//DEPT?>
XDO_SHEET_NAME_? <?concat(.//DEPARTMENT_NAME,'-',count(.//EMP_NAME))?>
Save the file as .xls only. If you save it as .xlsx it won't work.
Today I am going to show you how to create multi sheet Excel Report in BI Publisher.
1) First go to the below path:
C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\Excel templates. Here you will get an excel file named as "
BlankExcelTemplate" in which we have to create template.
3) Now we will create all fields and tags in excel file as below:
These tags can be found under Formula-> Name Manager
XDO_SHEET_? <?.//DEPT?>
XDO_SHEET_NAME_? <?concat(.//DEPARTMENT_NAME,'-',count(.//EMP_NAME))?>
Save the file as .xls only. If you save it as .xlsx it won't work.
No comments:
Post a Comment