I am trying to generate xml file using webfocus. Below is the source code shown: -* File daily_account_interface.fex APP FI ACCOUNTXML DISK BASEAPP/ACCOUNTXML.XML JOIN DA_PARTNER.DA_PARTNER.BUDGET_ID IN DA_PARTNER TO UNIQUE BUDGET.BUDGET.ID IN BUDGET TAG J1 AS J1 END JOIN DA_PARTNER.DA_PARTNER.EXTERNAL_ID IN DA_PARTNER TO UNIQUE DA_SIM_PARTNER.DA_SIM_PARTNER.ID IN DA_SIM_PARTNER TAG J2 AS J2 END DEFINE FILE DA_PARTNER AccType/A20= IF J2.DA_SIM_PARTNER.ACCOUNT_TYPE EQ 1 THEN 'Self service' ELSE IF J2.DA_SIM_PARTNER.ACCOUNT_TYPE EQ 2 THEN 'Full Service' ELSE IF J2.DA_SIM_PARTNER.ACCOUNT_TYPE EQ 3 THEN 'LongTail' ELSE 'NONE'; aa/A10=TRIM('L', EDIT(DA_PARTNER.DA_PARTNER.ID), 20, '0', 1, 'A10'); CRLF/A1 = HEXBYT(10,'A1'); XML_ROW/A200 = ''; END
TABLE FILE DA_PARTNER PRINT XML_ROW CRLF HEADING "header" FOOTING "footer" ON TABLE SAVE AS ACCOUNTXML
END
The source code file generates the report in this format(shown below).
My question is how can I append header part and trialing part( as shown below) to above generated report?
header part:
Trialer part:
The required format should look like as below shown:
Also how can I trim the leading 0's appended in the values? example:00009940 should be shown as 9940 I have tried with trim function but it does not display the other field values when I use trim. Instead it just dispaly as following