New (tax) year, new help!
Fixed Assets and UltraTax CS 2023 help is now on Help and Support. We're still moving articles, but you can find most content for the 2023 tax year there. Continue using the Help & How-To Center for tax years 2022 and older.
You can use this dialog either to export custom reports that contain data from the current or most recent search to a file for use with other applications. Search data can be exported either in DIF or Excel format for use with spreadsheet applications or in ASCII format for use with word processing application.
Before you search: To export a report for the current search, click the Export report option in the Print selection group box on the Print Selection and Client Search dialog, complete a search, and then click Continue on the Export Report dialog.
After you search: To export a report for the most recent search, choose Tools > Export Report from the Data Mining menu, and then click Continue on the Export Report dialog.
Fields & buttons
Displays the number of clients who passed the most recent search, as well as the name of the search.
Note: You cannot change the name of the search in this dialog. To export data for clients who passed a different search, close this dialog and perform a different search.
Displays the standard and custom reports available as layouts for the exported data. From this field, select the report layout in which to display the exported data.
Displays the column headings included in the selected report.
Mark this checkbox to include column heading information in the export file.
DIF: Click this option to create an export file in DIF format. DIF files can be imported directly into many spreadsheet applications without any further data conversion.
ASCII: Click this option to create an export file in ASCII format. ASCII files are compatible with most word processing application.
Excel: Click this option to create an export file in Excel format.
Note: The file extension in the Name of file to be created field is automatically updated if you change the format option.
Displays the location in which the export file will be created. Click the Change Location button to select a different file location.
This field is available for any report (except a summary report) for the selected database and only if one or more clients passed the most recent search.
Click this button to open the Modify Location dialog, where you can specify a different file location in which to export the file.
Note: This button is available only if you have created a custom report for the selected database, and only if one or more clients passed the most recent search.
Enter the filename for the exported data.
Notes
- The file name defaults to EXPORT, followed by a .DIF, .ASC, or .XLS file extension, depending on the option selected in the Format group box.
- This field is available only if you have created a custom report for the selected database, and only if one or more clients passed the most recent search.
Related topic: Client documents overview