Changes

Jump to: navigation, search

Exporting Reports

476 bytes removed, 19:17, 18 February 2020
no edit summary
__TOC__
 
=File Export=
[[Image:ReportExport.PNG]]
 
==File Extension==
A report can be exported into a flat file with the following file extension:
<pre>
<!--?xml version="1.0" encoding="ISO-8859-1"?-->{BREAK}
<details>{BREAK}
</pre>
 
 
<details>{BREAK} </details>
 
 
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> <firstnamedetails>Peter</firstname> <lastname>Jahl</lastname> <salary>25000</salary> <startdate>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</startdatedetails> </employee></details></pre>
==Exporting with Subreports==
* The following would export a report and subreport in Comma Separated Values format (CSV):
 <pre>@Companies/Accounts - Company name@,
@Companies/Accounts - Address 1@,
@Companies/Accounts - City@,
  
=See Also=
 
:* [[Exporting List View Results to Microsoft Excel]]
:* [[Report Variables]]
Smartstaff
1,385
edits

Navigation menu