Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Xml report generation using Webfocus
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Xml report generation using Webfocus
 Login/Join
 
<Neelam B>
posted
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

Kerry,
 
Reply With QuoteReport This Post
Expert
posted Hide Post
There was an example of this posted here.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5601 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Xml report generation using Webfocus

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.