Changes

Exporting Reports

521 bytes added, 19:51, 31 March 2011

no edit summary

By setting the file extension, you define which program on your computer should be used to process the exported report data. Some common extensions that are useful for exporting date are:

* '''TXTtxt''' – Window Notepad.* '''XLSxls''' – Microsoft Excel.* '''IIFiif''' – QuickBooks.* '''csv''' - Comma Separated Values

1. Set the '''Extension''' to '''TXTtxt'''.

[[Image:Reps199.png]]

The extension '''TXTtxt''' is generally associated with '''Notepad'''.

2. Click the '''Save''' button.

==Export to Excel==

If you change the extension to '''XLSxls''', then the file will be displayed using opened with MS-Excel.

1. Click the '''Reports''' tab.

7. Close '''ExcelNote:'''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.

==See Also==

* [[Report Variables]]

* [[Exporting Reports with Special Characters to Excel]]

[[Category:Reports]][[Category:Integration]]

• ← Older edit
• Newer edit →

0

edits