adamodar
Active Member
What is the equivalent of the following RTF Template Code in Excel Template:
XML will be of the following structure:
The expected output will be, kind of, in the following format:
Basically printing the information of multiple address numbers but the information needs to be printed only when the person has a non zero amount. This is easily achieved in an RTF template by adding the criteria in square brackets in the for each. Not sure how to do this in an XLS template.
<?for-each@section:On_Address_Number_S230[./On_Notification_Date_S226/RTL_BF_Header_Summary_S223/RTL_Amount_L4_ID12 != 0]?>
XML will be of the following structure:
<R58TEST>
<On_Address_Number_S230>
<Address_Number>1</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>5</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
<On_Address_Number_S230>
<Address_Number>2</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>10</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
<On_Address_Number_S230>
<Address_Number>3</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>0</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
</R58TEST>
The expected output will be, kind of, in the following format:
Address 1 Line 1 Detail 1 Line 1 Detail 2 Line 1 Detail 3 Line 2 Detail 1 Line 2 Detail 2 Line 2 Detail 3 Address 2 Line 1 Detail 1 Line 1 Detail 2 Line 1 Detail 3 Line 2 Detail 1 Line 2 Detail 2 Line 2 Detail 3 Footer
Basically printing the information of multiple address numbers but the information needs to be printed only when the person has a non zero amount. This is easily achieved in an RTF template by adding the criteria in square brackets in the for each. Not sure how to do this in an XLS template.
Last edited: