Discussion Locked

How to Convert Oracle Report 3 to Excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have Oracle 8i database and tools like Forms 5, Reports 3 and SQR. Our Business applications are based on these. I have a problem. We create reports using SQR or Reports 3. My Users have a regular request of converting reports output to excel work sheet. I am not able to find a way to do this . Reports 3 does not seem to support this even though another tool ( Crystal Report) does it so easily. Any help on how to convert Oracle Reports 3 output?.

4 replies

by d. brinson

I do not use Reports 3, but I do use SQR. What I have done is write out my reports as comma delimited (.CSV) files. Excel imports them easily. There isn't any automatic way to do this in SQR, but you can do it manually.

by vishy

Dear Brinson,
I already knew this and we already do a lot of things like that. However I was looking for reports 3 output to be converted to excel.

Anyway thanks for your input. It is good to know that there are people out there who still use SQR.

Thanks,

Vishy

by coolbarbarian

vishy

I have a client who produces oracle reports which are viewed in Microsoft Internet Explorer. I was asked to produce these in tabular form in excel, removing all surplus lines such as headers and blank lines. This was done by saving the viewed report in a text file (not csv or otherwise delimited) and then imported and stripped by macro. As I do not know reports 3 or SQR, if this seems like the sort of thing you require, please feel free to send me a text file of your report and a sample of the required excel format and I will have a look at it

Regards
Alan

This discussion is closed to new replies.