12.2 Data Export (MS-Excel / PDF / HTML)
Data Export feature provides User the facility to export reports in xls, pdf, html or txt format. You can export reports in these formats and e-mail it to your clients in the required format. You can export report by using the Export button provided in the Report window itself while viewing report through Display menu. Given here is a screenshot of a Report window, displaying Export button.
Image on next Page
Unit 12 – Utilities 269
Figure 12.2 Report Window
Figure 12.3 Export Data
270
In the Export Data window, following data fields appear:
Data Format
Select the format in which you want to export the report.
File Name
Specify file name and path at which the exported file is to be created.
Delimiter
This data field gets active only if you have selected the Text File – Delimited option in the Data Format data field. Specify the delimiter sign to separate value of each column of the report.
Set Column Width
This button gets active only if you have selected Text File – Fixed Width option in the Data Format data field. Click this button to specify the width of each column of the report. On clicking this button, a Set Columns Width window appears in which you can specify width for each column of the report.
After entering appropriate data in the data fields, click the Ok button to export the report in required format.