HI,

I have an Oracle report, which is given an SQl query to retreive certain records.

The report has a layout where the data should appear, and it also has calculating fields which computes Maximum,count , avg and certain other totalling functions.

I want the same way how data is represented in Oracle reports to be put into an Excel file, with atleast the same formatting...

Please this is urgent, EVEN if u have any idea how this could be done like in any programming language or using some import or export function, or if there are any 3rd party tools........please let me know........

J

hi,
there is a report properties called 'distribution' in the oracle reports developer. u can set for example rtf format text. if report is not much complicated u can open it in excel and it's working quite well.

This message was edited by lobojason at 2004-9-23 10:26:27

---

Hi shrek,
thank you for the reply......

I have tried it out.

By doing it the way u suggested, the format of the report is not maintained in excel....well the format is very important...

Do u have any more suggestions, Please advise....

J LO
n.b.: by the way I liked Shrek 2...

: hi,
: there is a report properties called 'distribution' in the oracle reports developer. u can set for example rtf format text. if report is not much complicated u can open it in excel and it's working quite well.
:
:

At www.more4apps.com you can download a PL/SQL package called Excel-Out that installs a concurrent request with output that opens directly to Excel. The query is listed in one of the fields on the form and you can change it to create your own report with Excel output.

Rep2excel * An Oracle Report to Excel Converter ... Generate a report file in html or htmlcss format by oracle report server.










_________________
http://www.microsoftoffice-2010.com/

I largest issue resides in the style sheets. No pun intended!

-Grahm
Excel Reports