You can send the output of a report to another type of file, such as ASCII, delimited, Excel, or dBASE III PLUS. These files can be used by spreadsheets, word processing, or other applications and include the printer driver information.
Reports in some modules can be exported to additonal files types, such as PDF or HTML, and can be saved to your hard drive or e-mailed. You can also select to export only the data portion of reports (header information is excluded) in these modules.
Use one of the following procedures to export or print a report to a file.
To export or print to a file in the Job Cost, Material Requirements Planning, Payroll, and Work Order modules
-
Access the report to print to a file and set the report options.
-
Click Printer Setup.
-
In the Printer Setup window, select the Print to File check box to send the output of the report to a different file type. For more information, see Printer Setup - Fields.
-
Select the Export File option and click OK.
-
In the Export File Options window, select the file type. The type of report selected determines the File Type options available. For more information, see Export File Options - Fields.
Note All reports can be sent to an ASCII file, but not all reports can be printed to other file types.
-
In the File Name field, accept the default path and file name or modify the path and file name.
Note If you modify the default path, the subdirectory specified must exist on the designated disk.
-
Click OK.
-
In the report window, click Print to print the report to a file.
The report is exported or printed to a file.
To export a report in all other modules
-
Access the report to export and select the report options.
-
In the Printer/Output field, select one of the following options:
-
Export: Select this option to export the entire report.
-
Data Only Export: Select this option to export only the data portion of the report (header information is excluded).
-
Click Print.
-
In the Export window, in the Format field, select the file type for exporting.
Note Do not select the Lotus 1-2-3 (WK3) format or the Lotus 1-2-3 (WKS) format; they are not supported by SAP Crystal Reports. Instead, use the Excel format.
-
In the Destination field, select the location you are exporting to. For example, you can export the report to your hard drive or to an application such as Excel. Click OK.
Note To e-mail the report, select Microsoft Mail (MAPI) in the Destination field.
The report is exported to a file.
Show/Hide All