For 'CSV', use DESFORMAT=DELIMITED. There
are issues, see another thread about
For 'Excel', the Oracle answer is again
DELIMITED. There are ways to do better, but
not directly within Reports. We build
PL/SQL programs to do that, since it gives
us control over column/row/field formats.
Could you please send me the pl/sql stuff and all the steps to get oracle reports output to be saved as .xls file.
I am using Reports 10g 1.2.0 ver. I use the desformat=spreadsheet destype=file desname=abc.xls
It is saving the output as abc.xls. But when i open the output it is giving the warning as "The file you are trying to open is in different format than specified by the extension. Verify the file is not corrupted ....... Do you want to open the file now?" Yes or no dialog
When I say yes it is opening.
1) How to create the excel xls output without the warning?
Is 10g 1.2.0 supports multible worksheets? Oracle site says single worksheet only.
2) I have requirement where the outputs to be designed for multiple worksheets. Is there any workarounds to create multiple worksheets in oracle reports 10g 1.2.0?
3) How to save the oracle reports output in another machine database.
Please give the detailed steps.
Could you please send me the pl/sql stuff and steps for oracle report to excel .xls file
multiple worksheets are not possible from Oracle Reports. You will have to generate a text file that can be read by excel. At Re: How to save a query result and export it to, say excell? you can find links to different solutions. At least the packages behind second and fourth link support more than one worksheet.
Regarding csv file format, i have no issues. The file is generating without any issues in using oracle reports without using any PL/SQL code.
My requirement is to design oracle reports to generate excel (.xls) file with multiple worksheets. Each sheets are having many data and graphs(chart).
Using oracle reports alone, how to achieve this.
In oracle reports 10g 1.2.0 version, I tried by creating .rdf file but, it is generating single worksheet only.
In oracle reports 10g 1.2.0 ver, I tried by creating .jsp file. For this first i am creating excel template about how my ouput column headings all that going to be with one sample hard coded data and save the excel file as web page.
Next open the html file in oracle reports builder and double click the websource now, you will see the jsp tags, html and xml tags. Now include the contentType="application/vnd.ms-excel " and charset also.
Next, include the <rw:foreach id="G_EMPNO_1" src="G_EMPNO">
here insert the fieldl for each column by removing the hard coded values.
close the tag
Save the file as .jsp and deploy it in oc4 enabled folder (say, devsuite_home/reports/j2ee/reports_ids/web
Start the oc4J server
Run it in the browser http://server:port/reports/emp.jsp?useride=uid/pwd@db
It is invoking the Microsoft excel with 3 sheets default and my emp table output in the first page.
We can save this output file as .xls file by clicking file -> save as.
1) The question is, it is working fine with Microsoft excel 97-2003 version. But for excel 2007, i am not able to create single html file like how 2003 save web page option.
2) I found this in oracle getting started demo
Which is more useful. This is what i am looking for.
I done that in excel 2003 as per demo. But excel 2007 with reports 10g issues.
Is there any demo for 10g with excel 2007
3) For most of excel issues working fine with excel 2003 and 10g. But excel 2007 with 10g reports are issues.
I want the excel output from oracle reports with multiple worksheet similar to the above demo.