Adding Header From Oracle Report To Excel Sheet

[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

[chrisplough]

Re: Adding Header From Oracle Report To Excel Sheet

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]

Re: Adding Header From Oracle Report To Excel Sheet

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]

Re: Adding Header From Oracle Report To Excel Sheet

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]

Re: Adding Header From Oracle Report To Excel Sheet

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]

Re: Adding Header From Oracle Report To Excel Sheet

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]

Re: Adding Header From Oracle Report To Excel Sheet

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

[acarpenter]

Re: Adding Header From Oracle Report To Excel Sheet

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

Prabhakar,

I have forwarded your Excel header export solution to our Oracle consultants, but they stated the instructions were incomplete and could not get it to work as you describe. Do you have more explicit, detailed instructions on how you accomplished this task?

We are on OTM 5.5 CU3 if that helps.

Thanks in advance for the help.

Adam Carpenter
Atlanta, GA

[ldostis]

Re: Adding Header From Oracle Report To Excel Sheet

we have the same requirement - we are on otm 5.5 ru6 and need to have custom reports export to excel. how did you do this? please help! thanks