Announcement

Collapse
No announcement yet.

Adding Header From Oracle Report To Excel Sheet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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
    Chris Plough
    twitter.com/chrisplough
    MavenWire

    Comment


    • #3
      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.

      Comment


      • #4
        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
        MavenWire

        www.MavenWire.com

        Comment


        • #5
          Re: Adding Header From Oracle Report To Excel Sheet

          Originally posted by prashant_prash View Post
          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
          Cheers,
          Murthy

          Comment


          • #6
            Re: Adding Header From Oracle Report To Excel Sheet

            Originally posted by prashant_prash View Post
            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"?
            Cheers,
            Murthy

            Comment


            • #7
              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

              Comment


              • #8
                Re: Adding Header From Oracle Report To Excel Sheet

                Originally posted by sprabhakar View Post
                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

                Comment


                • #9
                  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

                  Comment

                  Working...
                  X