Hi,

What would be the best way to achieve this? The Requirement is to have excel output with multiple sheets. so there would be total 47 sheets in 1 excel. Can anyone please share thoughts as to how the design should be achieve this requirement?

This requirement can achieve by using Template builder for Excel.

1.Create a Data Model as business requires (I would have assumed it's flat XML data)

2.Design the Layout in the excel for the first sheet (ensure that if any images are existed that would be visible only in the first sheet as oracle is not supported)

3.Set the parameters as required in the XDO_METADATA Sheet and hide it in the sheet to not to see by the report consumers

NOTE: As the requirement having multiple sheets, Need to group the data by the parent-child relationship in the XML along with this reason to have multiple sheets enablement we should create pre-processed XSLT file.This file Create Intermediate data from XML flat data into hierarchy enabled data(Parent-child relation).so that it would be enabled in the excel for the multiple sheets to represent the data from the source XML file.

4. In order to get the sheet name as required and what would be the field name we are grouping.To do this need to pass the parameter values in Data Constraints section in the XDO_METADATA Sheet as below:

XDO_SHEET_?             <?Tag name from the XML which is using as parent?>

XDO_SHEET_NAME_?  <?attribute name from the above?>

5.Next need to upload the XSLT file and .xls template files in the appropriate report definition.

Regards

Pavan kumar