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:'''

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits