This content has been marked as final. Show 6 replies
In eText, you would have to create a section with the columns and then create the other section with your detailed data.
this sounds very good, but I have no idea how to create such a section with the columns.
Can you give me an example?
P.S. I'm happy, to hear, that it is possible.
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
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.
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
can you please share sample xml and template. my email : email@example.com
I have sent you a sample based on
select empno, ename, job, sal from emp