Reports outtputed in excel

636453

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

637104

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

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