Changes

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]]

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits