6 Replies Latest reply: Nov 16, 2012 2:26 PM by Kofi RSS

    eText simple List with column header

    stefanhess
      Hi,

      is there somewhere in the www how to create a header for each column?


      Col1 col2
      valcol1 valcol2

      Couldn't be difficould, for me it is.?
        • 1. Re: eText simple List with column header
          Kofi
          In eText, you would have to create a section with the columns and then create the other section with your detailed data.
          Kofi
          • 2. Re: eText simple List with column header
            stefanhess
            Hi Kofi,

            this sounds very good, but I have no idea how to create such a section with the columns.
            Can you give me an example?

            Regards,

            Stefan

            P.S. I'm happy, to hear, that it is possible.
            • 3. Re: eText simple List with column header
              Avinash_Varma
              it may not be the right method but we have done in this way.


              say the data you need you have in G_1 . so we created one more group like below

              select 'IND','DEPT#','SEX','AGE' FROM dual; so it will come in G_2

              so when u design the template

              we need to get use the G_2 loop to get the column name and then the G_1 loop then we will get the data as below

              IND,DEPT#,SEX,AGE
              1,23DE,M,23
              2,EDST,F,23

              but i heard that other doing in my way there is right method i mean only design column name in template without getting them as xml as i did.

              but i didn't find any example like that so we did in that way so that it will at least meet the requirement.
              • 4. Re: eText simple List with column header
                Kofi
                Essentially when you are defining your levels, create one such that it will run only once, so typically at some root tag level.
                Then in this new level, define the Headings.
                Below is a snippet of what a tab delimited eText file could be done.
                Obviously since it won't appear in a proper table, you have to think in terms of a MS Word table with the appropriate headings.
                Hint: Define Data Layout
                <LEVEL>MY_HEADER_LEVEL
                <MAXIMUM LENGTH>     <FORMAT>     <DATA>     <COMMENTS>
                <NEW RECORD>     Tab Delimited Test
                18     Alpha     ‘Transaction Source’
                1     Alpha     chr(9)     
                10     Alpha     ‘Batch Name’     
                1     Alpha     chr(9)     
                .
                ....
                <END LEVEL>     MY_HEADER_LEVEL
                
                <LEVEL>     MY_DETAIL
                <MAXIMUM LENGTH>     <FORMAT>     <DATA>     <COMMENTS>
                <NEW RECORD>     Tab Delimited AR Revenue- DetailRecord
                18     Alpha     G_TRX_SOURCE     
                1     Alpha     chr(9)
                10     Alpha      G_BATCH_NAME     
                1     Alpha     chr(9)          
                ...
                <END LEVEL>     MY_DETAIL
                • 5. Re: eText simple List with column header
                  Avinash_Varma
                  can you please share sample xml and template. my email : datlaavinash@gmail.com
                  • 6. Re: eText simple List with column header
                    Kofi
                    Hi Avinash,
                    I have sent you a sample based on
                    select empno, ename, job, sal
                    from emp
                    Kofi