This discussion is archived
6 Replies Latest reply: Nov 16, 2012 12:26 PM by Kofi RSS

eText simple List with column header

stefanhess Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    can you please share sample xml and template. my email : datlaavinash@gmail.com
  • 6. Re: eText simple List with column header
    Kofi Journeyer
    Currently Being Moderated
    Hi Avinash,
    I have sent you a sample based on
    select empno, ename, job, sal
    from emp
    Kofi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points