This discussion is archived
4 Replies Latest reply: Mar 6, 2013 12:10 AM by Satya RSS

Can't export Report output to Excel

Satya Newbie
Currently Being Moderated
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
    :) Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points