Smartstaff
1,385
edits
Changes
→Custom Export
'''IMPORTANT:''' In order to support '''special characters''' such as French accented letters, euro symbols etc [[SmartSimple]] uses UTF-8 encoding. When opening exported files Microsoft Excel always imports using ASCII, so special characters do not appear correctly. This is a flaw with Excel. In order to export data containing special characters to Excel use one of the procedures outlined on the [[Exporting Reports with Special Characters to Excel]] article.
'''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==
If you change the '''File extension''' to '''xml''', then the report will construct an XML document from the report results.
=Custom Export=
This window consists of the following settings:
** '''COUNT''' - count the total rows per report. '''''@COUNT('''''column_name''''')@'''''
** '''SUM''' - sum of a column in the report. '''''@SUM('''''column_name''''')@ '''''
** '''Current Date''' - add current date using standard format YYYY, YY, MM, DD, HH, mm** [[Sscalculation|sscalculation]] can also be used in the header or footer<!--Ticket# 56482 - Ability to Sum and Count in report custom export header--><!--Ticket# 122241 - To add current date in the header for custom export report-->
* Please refer to '''[[Exporting Reports with Total Group By]]''' when exporting reports when [[Using Total Group Options in Report Builder]]
==Using Custom Export to export in Excel==
1. Click the '''Reports''' tab.
