I have developed a report in Reports 10g in RDF format, but as the output is required in excel thru EBS 12i while choosing XML at the time of linking the report, the same is not happening. I have also searched net and found DESFORMAT need to set as SPREADSHEET, but not able to find from where and how to set it.
Need urgent suggestion.
I have checked and followed the following steps
1) opened the report in object navigator mode
2) went to system parameter / desformat
3) pressed F4 & put spreadsheet in initial value
4) saved and compiled
5) copied the rdf file in ebs 12 customised report location
6) linked the report as output format as xml,style as A4
7) while executing report thru run request on viewing output new window is opening with "http://erptest.sahaj.co.in/OA_CGI/FNDWRR.exe?temp_id=1690448640"
in this format
<EMPNAME>CHATTERJEE, Mr. TAMAL</EMPNAME>
<NARRATION>Reimb. of exps./Lucknow/ 13.04.12 to 14.04.12/State Annual Conference/Fooding exps.</NARRATION>
but not in excel format, if the output is saved in XLS / XML format then the same can be opened in xls format.
Please advice how to open the output file in excel.