Thank you. Please explain how you got the excel sheet (XLS) with the XDO_METADATA tab. When you do the multi-sheet you add details but when you created the single-sheet file you did not update that tab. What is that tab for and where do you get the contents?
docs.oracle.com/html/E22254_03/create_excel_tmpl.htm The Template Builder creates the hidden XDO_METADATA sheet the first time you insert a field or repeating group.
Nice Video. I tried the same on Apps R12.1.1. But have issue in Template Registration. I am not Getting Default Output Type as "EXCEL" . Default Output Type listbox is blank. I execute Report without "Default Output Type" but it completes with warning and is it showing xmldata as output instead of excel data. Can you guide how do I resolve this issue in R12.1.1 ?
I have a report, where I have to show different group of data in sheet1 and split different groups of data into different sheets from sheet2. I mean to show summary data in sheet1, to split detailed data from sheet2. Is it possible to do that??
Requirement is Based on one columns' value I want to generate output in multiple sheet,e.g, if value='A' then Sheet1 and if value='B' then sheet2 how to achieve it. Please help. Thanks in advance!!
I have a requirement as Sheet 1 to display the Department wise total number of employees, the in the multiple sheet Employee details of department wise in each sheet. Please suggest
Hi Pavan, Data template we have to design it manually- Sources of these are : Check out any standard report of this type, Google it- you will get lot number of samples. I will paste the sample which i used in this.
Really well presented, thank you.
Thanks it help alot. One issue i faced is the excel file format. I dowloaded the sample from oracle and it worked.
Thank you. Please explain how you got the excel sheet (XLS) with the XDO_METADATA tab. When you do the multi-sheet you add details but when you created the single-sheet file you did not update that tab. What is that tab for and where do you get the contents?
docs.oracle.com/html/E22254_03/create_excel_tmpl.htm The Template Builder creates the hidden XDO_METADATA sheet the first time you insert a field or repeating group.
Nice Video. I tried the same on Apps R12.1.1. But have issue in Template Registration. I am not Getting Default Output Type as "EXCEL" . Default Output Type listbox is blank. I execute Report without "Default Output Type" but it completes with warning and is it showing xmldata as output instead of excel data.
Can you guide how do I resolve this issue in R12.1.1 ?
I have a report, where I have to show different group of data in sheet1 and split different groups of data into different sheets from sheet2.
I mean to show summary data in sheet1,
to split detailed data from sheet2.
Is it possible to do that??
I couldn't select Template Type as 'Excel' in 12.1.3 version. Is there a setup to enable Microsoft Excel in the Template?
Did you check the lookup : XDO_TEMPLATE_TYPE of : Application Object Library Lookups , is XLS (Code) Enabled ?
Hi, do you have any video where you explained about translation in XML Publisher Reports? Please let me know.
XDO_SHEET_? isn't splitting the output for me.. Its all coming in a single sheet. Can you please suggest
Hi sir how you created xxlt emp excel report can you please explain.?is it concurrent program..and what value needs to passed in output format...?
Requirement is Based on one columns' value I want to generate output in multiple sheet,e.g, if value='A' then Sheet1 and if value='B' then sheet2 how to achieve it. Please help.
Thanks in advance!!
I have a requirement as Sheet 1 to display the Department wise total number of employees, the in the multiple sheet Employee details of department wise in each sheet. Please suggest
i'm using XLS format with 12.1.3. the number of rows exceed 65546. what to do
Can I export a template from BI Publisher 11g to Oracle BI Publisher 12c? How to share a template on OBI?
Can you pls let me know where I can get the metadata tab values? I am not seeing them in my excel..
Can we display the parameters in excel which we are using in Data Model...if yes, please explain the procedure
is there any compatibility issue with excel template?
Hi sir in this video you have showed XML data template for multi sheet report can you pls tel me how to generate that data template
Hi Pavan, Data template we have to design it manually- Sources of these are : Check out any standard report of this type, Google it- you will get lot number of samples. I will paste the sample which i used in this.