Page 1 of 1

Genearate Report in Excel

Posted: Wed May 09, 2007 6:16 am
by musman
Can we generate report directly in excel form report builder.


Please make a solution

Posted: Wed May 09, 2007 6:33 am
by ahmadbilal
From Oracle Reports 6i to MS Excel export package with demo built on user_objects view

Method:
OLE automation

Restrictions:
- only for client deployment
- report must include &TotalPages variable to ensure fetch all records
- user must have access to SYS.DBMS_SESSION package

Download free
Demo executable 55K: rpt2xls_demo.rep.zip
Demo source code 60K: rpt2xls_demo.rdf.zip
Library source code 11K: rpt2xls.pll.zip

http://www.geocities.com/oranails/reports/rpt2xls.htm


[quote]Can we generate report directly in excel form report builder.


Please make a solution

<i><div align="right">Originally posted by musman

Posted: Thu May 10, 2007 2:56 am
by musman
Sorry I think I can't ask my question right.
I need when i run a report from Reports 6i the output should be generated in MS Excel directly.

Like others when i run report i can generate output directly in pdf or dflt.
In the same way i need output in text Format or MS Excel Format.

Posted: Sat May 12, 2007 6:54 am
by iftikhar
Dear Cheer,
I am also in this trouble but the solution of legal report is best is convert your report to PDF than acrobat reader automatically set report out put to legal.

Re: Genearate Report in Excel

Posted: Sat Jun 18, 2022 1:06 am
by ramsisali
welecome
thanks