Export the Data
Once you have sorted and filtered your criteria, you may Export the data in exactly the same sequence as displayed in the TCDrillDown screen.
-
Once you have sorted or filtered your data, click on the File → Export menu.
-
The Save as screen will be displayed.
-
Select a Directory in which you wish to export the selected data.
-
Enter a file name.
-
Select one of the following file formats:
-
XML - Extensible Mark-up Language
-
HTML - HyperText Mark-up Language
-
Excel - Microsoft Excel Spreadsheet
-
Text - Text file
-
Click on the Save button. Once you have exported the data, you may locate the file and open it in your systems default program for the saved file type. For example, you may use it to build graphs in OpenOffice Calc or Microsoft Excel spreadsheets, and make powerful presentations of your data in OpenOffice Impress or Microsoft PowerPoint.
Spreadsheets
The following is examples of exported data in spreadsheets with charts for expenses exported using the DrillDown.
OpenOffice Calc
Microsoft Excel
XML
HTML – Customer → Invoice
HTML – Invoice → Stock Item