apps output in excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vamsioracle
    New Member
    • Jun 2007
    • 151

    apps output in excel

    hi

    I have a report that displays the stock details. It is PDF format report. Now when i click on view output i want it to be in excel sheet. Is it possible

    Is there any other way to get the output in excel from apps


    vamsi
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Originally posted by vamsioracle
    hi

    I have a report that displays the stock details. It is PDF format report. Now when i click on view output i want it to be in excel sheet. Is it possible

    Is there any other way to get the output in excel from apps


    vamsi
    Is your data comma delimited or some layout designed?

    Comment

    • vamsioracle
      New Member
      • Jun 2007
      • 151

      #3
      It is not comma delimited

      vamsi

      Comment

      • amitpatel66
        Recognized Expert Top Contributor
        • Mar 2007
        • 2358

        #4
        Originally posted by vamsioracle
        It is not comma delimited

        vamsi
        Ok. Then the excel import might not be that perfect.
        1. Anyways, you need to set a profile something like %REPORT%OUTPUT% to the required format.

        2. Also check for concurrent program setup where you select the output type.

        Comment

        • vamsioracle
          New Member
          • Jun 2007
          • 151

          #5
          The problem with my report is, the output size is not constant

          for example, the report data length is varying and moves to next line sometimes, when i convert this to excel the next line comes as a new row, which should be part of the first row.

          i cant go on increasing the length of frame of the report.


          what can be the solution for this

          vamsi

          Comment

          • vamsioracle
            New Member
            • Jun 2007
            • 151

            #6
            The concurrent program shows output format as XML type

            Comment

            • amitpatel66
              Recognized Expert Top Contributor
              • Mar 2007
              • 2358

              #7
              Now firstly,

              1. change the layout type of the concurrent program to LANDWIDE (up to 1800 characters in a single line) in order to avoid the line feed for single line.

              2. change the vertical and horizontal elasticity property for main frame and all the repeating frames to VARIABLE in the rdf file

              Comment

              Working...