developers

    Forum Stats

  • 3,873,876 Users
  • 2,266,626 Discussions
  • 7,911,649 Comments

Discussions

Reports outtputed in excel

636453
636453 Member Posts: 114
edited Sep 10, 2008 1:19AM in Reports
I would like to outtputa report in excel,

i have read some previous posts, and alot of them mention:

DESFORMAT=DELIMITED/SPREADSHEETS

but i cant find this option in my oracle reports 6.

Any ideas???

Edited by: user633450 on 09-Sep-2008 02:51
Tagged:

Answers

  • 637104
    637104 Member Posts: 290
    Hi there,

    Search for DELIMITED in the reports help.
    If you set the DESFORMAT to delimited and the DESTYPE to file then you can create a file with an XLS extension that when opened in Excel will display with each column of data in a separate column in Excel.

    One thing to note here is that the headings from your report will output on every line as the first few columns e.g.

    If your report, when run in the Previewer looks like this

    DEPT_ID DEPT_NAME
    1 Sales
    2 Accounting
    3 Purchasing

    then the excel delimited output will look like this

    Row1 : DEPT_ID DEPT_NAME 1 Sales
    Row2 : DEPT_ID DEPT_NAME 2 Accounting
    Row3: DEPT_ID DEPT_NAME 1 Purchasing

    To avoid this you can delete the column headings and add another query to the data layout that selects your columns headings from dual i.e.

    SELECT 'DEPT_ID', 'DEPT_NAME' from dual

    If you then add this to the layout above your data items then you will get the desired effect in Excell i.e.

    Row1 : DEPT_ID DEPT_NAME
    Row2 : 1 Sales
    Row3 : 2 Accounting
    Row4 : 3 Purchasing

    Hope this helps

    Mark
  • Marwim
    Marwim Member Posts: 3,654 Gold Trophy
    Hello 633450,
    since reports 6i does not support spreadsheets and DELIMITED needs a workaround you might create your files without reports.
    There are many public PL/SQL packages available, some of them supporting multiple worksheets or different ways to receive the created file.
    2516584

    Regards
    Marcus
This discussion has been closed.
developers