Thread: Adding Header From Oracle Report To Excel Sheet
View Single Post
  #3 (permalink)  
Old November 28th, 2007, 21:46
Shells Shells is offline
Junior Member
  
Join Date: Jun 2006
Posts: 24
Thanks: 0
Thanked 3 Times in 3 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Shells will become famous soon enough
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.
Reply With Quote