Changes

Exporting Reports

518 bytes added, 18:17, 2 August 2018
no edit summary
: See [[:Category:Plug-Ins for Microsoft Office|Plug-Ins for Microsoft Office]] for details
 
This article explains how to use the 2nd method, which is exporting.
 ==Custom ExportConfiguration==
* Click the '''Custom Export''' tab (formerly Advanced Export Settings).
Each field will be delimited by a Other settings: * '''Delimiter''' - tab character ('''''{TAB}'''''), and comma, semi-colon, colon* '''Line breaks''' - use either a UNIX <LF> line break ('''''{LINEFEED}''''')  or a Windows <CRLF> line break ('''''{BREAK}''''') will be added to <!--56598 - Create custom export with UNIX breaks-->* '''Aggregate Functions in Header or Footer'''** '''COUNT''' - count the end total rows per report. '''''@SUM('''''column_name''''')'''''** '''SUM''' - sum of each exported recorda column in the report.'''''@SUM('''''column_name''''') '''''<!--56482 - Ability to Sum and Count in report custom export header-->
==File Extension==
<pre><!--?xml version="1.0" encoding="ISO-8859-1"?-->{BREAK}
</pre>
 
<details>{BREAK} </details>
 
 
4. The Export XML document opened in Notepad:
 
 
<details> Peter Jahl 25000 11/05/2003 Herry Lee 55000 27/02/2005 Peter Manlee 75000 12/05/2001 </details>
 
 
 
==Exporting with Subreports==
In order to export a report that contains subreports or merged reports you must define the Advanced Export Settings for the subreports, as well as the main report.
<!--54913 - Ability to store report export to specified SmartFolder--><!--67965 - Extend schedule report export to custom template-->
'''Example:'''
Smartstaff
1,385
edits