2 Replies Latest reply: Nov 16, 2012 3:58 AM by 974432 RSS

    Report Development Problem in EBS 12i using Reports 10g

    974432
      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.
        • 2. Re: Report Development Problem in EBS 12i using Reports 10g
          974432
          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

          <EMPCODE>EM00282</EMPCODE>
          <EMPNAME>CHATTERJEE, Mr. TAMAL</EMPNAME>
          <GRADE>CS4</GRADE>
          <BRANCH>HO00A</BRANCH>
          <DIVISION>1900</DIVISION>
          <LOB>1900</LOB>
          <CC>856</CC>
          <LOCATION>Lucknow</LOCATION>
          <FROMDATE>04/13/2012</FROMDATE>
          <TODATE>04/15/2012</TODATE>
          <DAYS>3</DAYS>
          <TRAVELMODE>Train</TRAVELMODE>
          <REASON>Training</REASON>
          <GLCODE>424134</GLCODE>
          <AMOUNT>200</AMOUNT>
          <GLDATE>20-APR-12</GLDATE>
          <BILLDATE>2012/04/20</BILLDATE>
          <VOUCHERNO>211301218</VOUCHERNO>
          <NARRATION>Reimb. of exps./Lucknow/ 13.04.12 to 14.04.12/State Annual Conference/Fooding exps.</NARRATION>
          <CS_SRL_1>1</CS_SRL_1>


          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.

          Thanx