4 Replies Latest reply: Mar 6, 2013 2:10 AM by Satya RSS

    Can't export Report output to Excel

    Satya
      Hello,

      I have developed a report in Dev10G.
      I can run the report in browser (using the Report Builder). In the parameters i have used "desformat = delimiteddata". After the report is displayed I can export the content to excel as:
      1. Right Click
      2. Select 'Export to Microsoft Excel'.


      I want to open this report from a form and convert data to excel.

      Now if I try to call this report from a form , the report displays all the available fields from Data Model.

      Please guide me .

      Regards

      Satya
        • 1. Re: Can't export Report output to Excel
          a_cute_person
          Satya wrote:
          Hello,

          I have developed a report in Dev10G.
          I can run the report in browser (using the Report Builder). In the parameters i have used "desformat = delimiteddata". After the report is displayed I can export the content to excel as:
          1. Right Click
          2. Select 'Export to Microsoft Excel'.


          I want to open this report from a form and convert data to excel.

          Now if I try to call this report from a form , the report displays all the available fields from Data Model.

          Please guide me .

          Regards

          Satya
          what do you want ?
          • 2. Re: Can't export Report output to Excel
            Satya
            Hello ,

            I want to
            1. run a report in browser by calling it from a form and
            2. want to export the data of the same report to excel format*


            I can run a report from the form but unable to convert data of report to excel.
            If i run the report from report builder, only then i can convert the data to excel.


            Regards
            • 3. Re: Can't export Report output to Excel
              HamidHelal
              Satya wrote:
              Hello,

              I have developed a report in Dev10G.
              I can run the report in browser (using the Report Builder). In the parameters i have used "desformat = delimiteddata". After the report is displayed I can export the content to excel as:
              1. Right Click
              2. Select 'Export to Microsoft Excel'.


              I want to open this report from a form and convert data to excel.

              Now if I try to call this report from a form , the report displays all the available fields from Data Model.

              Please guide me .

              Regards
              Hi, Satya
              use desformat=spreadsheet
              check this link Building a Report for Spreadsheet Output

              Hope this helps..

              Hamid
              • 4. Re: Can't export Report output to Excel
                Satya
                Hi,

                I later found that the report version is actually 9i ( in the installation it is mentioned as 10g(9.0)).
                The report displays error for desformat=spreadsheet (may be because this works only in 10gR2).

                I tried DESFORMAT = 'DELIMITEDDATA', however the report displays all the fields from query whether i have displayed them on Paper layout or not.


                If a try DESFORMAT = 'HTML' the report displays as expected, but i cant export data to excel .

                Regards

                Satya