Adding Header From Oracle Report To Excel Sheet

prashant_prash · #1 (**permalink**) November 12th, 2007, 11:58

HELLO ALL,

I HAVE PROVIEDED 'EXPORT TO EXCEL' OPTION IN ONE OF MY ORACLE REPORT. THE DATA FROM REPORT IS GETTING INTO THE EXCEL BUT THE HEADINGS OF THE REPORT i.e. COLUMN NAMES ARE NOT GETTING COPIED OR TRANSFERRED IN THE EXCEL SHEET. ALSO THE COLUMNS ARE TRANSFERRED IN IRREGULAR PATTERN.

THANKS IN ADVANCE.

REGARDS,

PRASHANT

chrisplough · #2 (**permalink**) November 12th, 2007, 15:09

Prashant,

I'm sure someone here will be able to help you -- if I remember correctly, it has to do with a report parameter.

Just as a note, though, writing in all caps is generally considered rude online and usually indicates yelling. I know you didn't intend it this way, but take it into consideration in the future.

--Chris

Shells · #3 (**permalink**) November 28th, 2007, 20:46

I'm not sure what version of Oracle Reports you are on, but on GC3/OTM 4.5 and below, this was a limitation with oracle without repeating a set of headers for every row returned (we entered many tickets in the past hoping to find someone who could give us a fix). As a workaround, we created an excel macro for the users and added it to the Gc3/OTM menu for them to download and install on their system. This allowed them to open the report, click <Ctrl-S> (for example) and have all the headers show up. I'm not sure if this changed with the newer version of Oracle Reports used in version 5.5.

sprabhakar · #4 (**permalink**) November 29th, 2007, 09:37

Hi,

We have this fuctionality working on OTM versions 4/5.0 &5.5 on more than 50 reports. Please do the following to achieve this.

1. Copy the report headers into HEADER section of the report
2. Delete them from the MAIN section of the report
3. When invoking the the report, pass the parameter "desformat=DELIMITED"

You should see the report open in MS Excel with proper headers.

If you are seeing data being repeated, there are other ways to resolve it. One of them is
to
1. Keep just one repeating frame in the MAIN section of the report
2. Pickup all possible data required to display in the main query
3. Generate data for all others fields through formula columns inside the main query.

This is just one of the ways. Please revert & we will advice you of other options if this is difficult for you to achive.

Thanks
Prabhakar

MURTHYKO · #5 (**permalink**) July 7th, 2008, 09:08

Quote:

Originally Posted by prashant_prash

HELLO ALL,

I HAVE PROVIEDED 'EXPORT TO EXCEL' OPTION IN ONE OF MY ORACLE REPORT. THE DATA FROM REPORT IS GETTING INTO THE EXCEL BUT THE HEADINGS OF THE REPORT i.e. COLUMN NAMES ARE NOT GETTING COPIED OR TRANSFERRED IN THE EXCEL SHEET. ALSO THE COLUMNS ARE TRANSFERRED IN IRREGULAR PATTERN.

THANKS IN ADVANCE.

REGARDS,

PRASHANT

Prashant,

Could you pls tell me how to extract th data in xls format from RDF?

Thanks in advance,
Lakshman

MURTHYKO · #6 (**permalink**) July 8th, 2008, 04:37

Quote:

Originally Posted by prashant_prash

HELLO ALL,

I HAVE PROVIEDED 'EXPORT TO EXCEL' OPTION IN ONE OF MY ORACLE REPORT. THE DATA FROM REPORT IS GETTING INTO THE EXCEL BUT THE HEADINGS OF THE REPORT i.e. COLUMN NAMES ARE NOT GETTING COPIED OR TRANSFERRED IN THE EXCEL SHEET. ALSO THE COLUMNS ARE TRANSFERRED IN IRREGULAR PATTERN.

THANKS IN ADVANCE.

REGARDS,

PRASHANT

Dear Prashant,

Could you pls tell me how to get the data in to Excel from a RDF file? I mean how to provide that option of "Export to Excel"?

vidyas10 · #7 (**permalink**) August 27th, 2008, 09:54

Thanks All for the help,
Even i am facing the same kind of problem. Can i call the same report to expot to excel where in the excel output i require of 50% of the data available in the report layout. While exporting in AfterPForm will specify the same calling report name

_report_physical_name.

Help me out..

Thanks,
VidyaS