Re: Excel-Output from Oracle Reports 6i

yeah, but it can get ugly. you have to set the mode=character, and the header(I forget the exact syntax for this) to no. then you can call the report using DDE. and run_report_object

there are few problems with this though.

1. Reports does a HORRIBLE job exporting header data. It can only get the data from the body. You will have to export any header data to a seperate file with the text_io package.
2. When you use character mode you will often get a really vague error telling you that some of your objects have no size. The way I found to fix this is to change from what ever size standard I was using(ie inches) to the smallest one possible. ITs a long story why this happens. There are a variety of other reasons why this happens.

search dejanews.com... alot of people have hit these problems in the past.

Keep in mind... that if your in web mode, the report will be exported to the application server. To get around this, I installed excel on the server, built templates for my excel reports and put macros in them that I called when I called the templates to import the data and used web.show_document to allow the users to view it in their browsers. Then they could save it locally.

[Quoted] Its far more annoying than it should. It would be easier just to buy a tool called SQL*XL or something like that. Its about $100. You will need to install the OO4O to get it to work.

"Rudi Ernst" <news3_at_edv-ernst.de> wrote in message news:m5fvfucoaj23urv28bhoon67bvhb4j2f8n_at_4ax.com...
> High all,
>
> is there any possibility to create an Excel xls-file as
> output from Oracle Reports 6i. I'm only able to create a
> csv-file that contains an additional report header for
> every row of the report and this is very annoying.
>
> Thanks
> Rudi
>
Received on Fri Jun 07 2002 - 04:58:16 CEST