Smartstaff
1,385
edits
Changes
→Export to XML
'''Note:''' If the report has sub reports attached then you must set up the Custom Export settings for each of the sub report attached.
==Export to XML==
==Export to XML==
If you change the '''File extension''' to '''xml''', then the report will construct an XML document from the report results.
1. In the '''Header''' section enter the XML declaration and open the root element, ''details'':
<pre><!--?xml version="1.0" encoding="ISO-8859-1"?-->{BREAK}<details>{BREAK}
</pre>
The {TAB}s and {BREAK}s will give the XML document proper indentation:
<pre>{TAB}<employee>{BREAK}{TAB}{TAB}<firstname>@Users - First name@</firstname>{BREAK}{TAB}{TAB}<lastname>@Users - Last name@</lastname>{BREAK}{TAB}{TAB}<salary>@Users - Salary@</salary>{BREAK}{TAB}{TAB}<startdate>@Users - Start Date@</startdate>{BREAK}{TAB}</employee>{BREAK}
</pre>
3. In the '''Footer''' section, close the root element:
<pre> </details> </pre>
4. The Export XML document opened in Notepad:
<pre>
<?xml version="1.0" encoding="ISO-8859-1"?>
<details> <employee> <firstname>Peter</firstname> <lastname>Jahl</lastname> <salary>25000</salary> <detailsstartdate> Peter Jahl 25000 11/05/2003 </startdate> </employee> <employee> <firstname>Herry </firstname> <lastname>Lee </lastname> <salary>55000 </salary> <startdate>27/02/2005 </startdate> </employee> <employee> <firstname>Peter </firstname> <lastname>Manlee </lastname> <salary>75000 </salary> <startdate>12/05/2001 </detailsstartdate> </employee></details> </pre>
==Exporting with Subreports==