Sample Template for eText BIP Report
You can see step by step video to develop eText BIP Report using this Link
Please find the attached templates:
1) eText Template -
You can see step by step video to develop eText BIP Report using this Link
<TEMPLATE
TYPE> |
DELIMITER_BASED |
<OUTPUT CHARACTER SET> |
iso-8859-1 |
<CASE CONVERSION> |
UPPER |
<NEW RECORD CHARACTER> |
Carriage Return |
<LEVEL> |
DATA_DS |
||
<MAXIMUMLENGTH> |
<FORMAT> |
<DATA> |
<COMMENTS> |
<NEW RECORD> |
TableHeader |
||
20 |
Alpha |
'Person Id' |
|
1 |
Alpha |
'|' |
|
20 |
Alpha |
'Title' |
|
1 |
Alpha |
'|' |
|
20 |
Alpha |
'First Name' |
|
1 |
Alpha |
'|' |
|
20 |
Alpha |
'Last Name' |
|
<LEVEL> |
G_1 |
||
<MAXIMUMLENGTH> |
<FORMAT> |
<DATA> |
<COMMENTS> |
<NEW RECORD> |
CLRDAta |
||
20 |
Alpha |
PERSON_ID |
|
1 |
Alpha |
'|' |
|
20 |
Alpha |
TITLE |
|
1 |
Alpha |
'|' |
|
20 |
Alpha |
FIRST_NAME |
|
1 |
|
'|' |
|
20 |
Alpha |
LAST_NAME |
|
<END LEVEL> |
G_1 |
<END LEVEL> |
DATA_DS |
2) Fixed Position eText Template -
You can see step by step video to develop Fixed Position eText BIP Report using this Link
<TEMPLATE
TYPE> |
FIXED_POSITION_BASED |
<OUTPUT CHARACTER SET> |
iso-8859-1 |
<CASE CONVERSION> |
UPPER |
<NEW RECORD CHARACTER> |
Carriage Return |
<LEVEL> |
DATA_DS |
||||||||||
<POSITION> |
<LENGTH> |
<FORMAT> |
<PAD> |
<DATA> |
<COMMENTS> |
||||||
<NEW RECORD> |
TABLE_HEADER |
||||||||||
1 |
15 |
Alpha |
R, ' ' |
'Person Id' |
|
||||||
16 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
19 |
15 |
Alpha |
R, ' ' |
'Title' |
|
||||||
35 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
39 |
50 |
Alpha |
R, ' ' |
'First Name' |
|
||||||
90 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
94 |
20 |
Alpha |
R, ' ' |
'Last Name' |
|
||||||
<LEVEL> |
G_1 |
||||||||||
<POSITION> |
<LENGTH> |
<FORMAT> |
<PAD> |
<DATA> |
<COMMENTS> |
||||||
<NEW RECORD> |
TABLE_HEADER |
||||||||||
1 |
15 |
Alpha |
R, ' ' |
PERSON_ID |
|
||||||
16 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
19 |
15 |
Alpha |
R, ' ' |
TITLE |
|
||||||
35 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
39 |
50 |
Alpha |
R, ' ' |
FIRST_NAME |
|
||||||
90 |
3 |
Alpha |
R, ' ' |
'|' |
|
||||||
94 |
20 |
Alpha |
R, ' ' |
LAST_NAME |
|
||||||
<END LEVEL> |
G_1 |
||||||||||
<END LEVEL> |
DATA_DS |
||||||||||
Hi I am using exactly the same template as you have mentioned, the output is returning only 1 row of data. It is returning 1 Header and then 1 row of data ..
ReplyDeleteCan you help what could be the issue.
Also, I am using HCM Extract for xml creation and creating this integration
It means issue is with loop if XML is generating more than one records.
DeletePlease check the data group loops in your template.
Try to import the xml in rtf template and view output in word only if output is as expected then upload rtf to fusion
It is so nice blog. I was really satisfied by seeing this blog.
ReplyDeleteworkday studio training
workday studio online training
Is it possible to have multiple data headers and data sections to use it for returning two sections on the output file?
ReplyDeleteExcellent example. I saw your YouTube video tutorial but my Report output is showing blank result
ReplyDeleteSample Templates - Best Templates - Sample Template - Excel Template - Best Template - Free Sample Templates - Download Templates - Mustervorlagen
ReplyDelete