WEBVTT 00:00:00.900 --> 00:00:04.200 Welcome to this ACE Reports video, 00:00:04.200 --> 00:00:06.766 Saving and Exporting Reports. 00:00:07.266 --> 00:00:09.166 This video will demonstrate 00:00:09.166 --> 00:00:12.099 how to Save and Export Reports. 00:00:12.266 --> 00:00:14.599 You can save a copy of a report for 00:00:14.600 --> 00:00:17.666 personal use or to a public folder. 00:00:18.233 --> 00:00:20.866 There are two locations to save reports: 00:00:21.566 --> 00:00:24.666 Personal Folders: Reports saved in the 00:00:24.666 --> 00:00:27.332 Personal Folders are private and cannot 00:00:27.333 --> 00:00:29.699 be viewed or run by another user. 00:00:30.433 --> 00:00:33.366 Public Folders: other users can view 00:00:33.366 --> 00:00:36.299 and run reports stored in these folders. 00:00:36.733 --> 00:00:38.966 Other users cannot edit your public 00:00:38.966 --> 00:00:42.166 reports unless they save their own copy. 00:00:42.800 --> 00:00:46.166 IMPORTANT: Selecting a Public Folder as 00:00:46.166 --> 00:00:48.899 the destination allows anyone with 00:00:48.900 --> 00:00:51.800 access to the folder to see that report. 00:00:52.466 --> 00:00:55.066 You can also export a report to various 00:00:55.066 --> 00:00:58.532 formats such as Excel spreadsheet, 00:00:58.533 --> 00:01:01.366 PDF, and CSV. 00:01:02.066 --> 00:01:04.766 If exporting to PDF, remember to make 00:01:04.766 --> 00:01:07.699 any format changes prior to export. 00:01:07.933 --> 00:01:11.933 In the File drop-down, select Save As. 00:01:12.500 --> 00:01:14.733 The Save Document pane displays. 00:01:15.400 --> 00:01:17.100 In the Save Document pane: 00:01:17.966 --> 00:01:20.599 Select the Options tab to provide a 00:01:20.600 --> 00:01:23.466 Description and associate any keywords, 00:01:23.466 --> 00:01:24.432 if desired. 00:01:25.300 --> 00:01:27.466 If you want to see the data from the 00:01:27.466 --> 00:01:29.966 report’s last instance each time the 00:01:29.966 --> 00:01:32.899 report is open, de-select the Refresh 00:01:32.900 --> 00:01:34.300 on open option. 00:01:34.866 --> 00:01:36.832 If you want a new instance of the report 00:01:36.833 --> 00:01:38.666 to run each time you open it, 00:01:38.666 --> 00:01:41.632 keep Refresh on open selected. 00:01:42.333 --> 00:01:44.733 Navigate back to the Folders tab and 00:01:44.733 --> 00:01:47.399 select a folder to save the report in. 00:01:48.066 --> 00:01:49.866 You can save the report in your 00:01:49.866 --> 00:01:52.999 Personal Folders or in Public Folders. 00:01:53.633 --> 00:01:55.799 Note, you may have to expand and open 00:01:55.800 --> 00:01:57.566 folders or subfolders 00:01:57.966 --> 00:01:59.966 to find the correct location. 00:02:01.766 --> 00:02:04.866 In the File Name field, type a file name. 00:02:09.800 --> 00:02:12.266 Select the Save button. 00:02:14.833 --> 00:02:18.233 The report displays with the new file name. 00:02:18.766 --> 00:02:21.399 To export the report, in the toolbar, 00:02:21.400 --> 00:02:23.066 select the Export icon. 00:02:23.666 --> 00:02:27.032 In the Export to dialog box, select your 00:02:27.033 --> 00:02:29.299 desired export file format 00:02:29.300 --> 00:02:31.300 from the following options: 00:02:31.800 --> 00:02:36.966 Excel exports as an .xlsx file that you 00:02:36.966 --> 00:02:39.399 can open in a spreadsheet application. 00:02:39.933 --> 00:02:43.099 In a PDF, the data within the report 00:02:43.100 --> 00:02:44.466 will not be editable. 00:02:44.933 --> 00:02:47.033 Ensure you make any edits to the 00:02:47.033 --> 00:02:49.233 report layout before exporting. 00:02:49.866 --> 00:02:53.266 HTML can be read by a web browser. 00:02:53.866 --> 00:02:57.166 TXT is a plain text file 00:02:57.166 --> 00:02:58.566 with no formatting. 00:02:59.266 --> 00:03:02.966 CSV is a report with plain text, 00:03:02.966 --> 00:03:06.232 comma-separated values that are suitable 00:03:06.233 --> 00:03:08.633 or import into many applications. 00:03:09.433 --> 00:03:12.799 After you choose a format, review options 00:03:12.800 --> 00:03:15.566 specific to that format in the pane. 00:03:16.066 --> 00:03:18.966 In this example, we will export to a PDF, 00:03:20.066 --> 00:03:20.099 In this example, we will export to a PDF, 00:03:20.100 --> 00:03:23.233 and select the box to show all reports. 00:03:23.933 --> 00:03:26.766 When complete, select the Export button. 00:03:27.800 --> 00:03:29.166 The file downloads to your 00:03:29.166 --> 00:03:31.032 browser download location. 00:03:31.766 --> 00:03:34.132 This concludes our demonstration of 00:03:34.133 --> 00:03:36.566 how to Save and Export Reports. 00:03:36.733 --> 00:03:38.466 If you have any questions, 00:03:38.466 --> 00:03:44.499 email ACETraining@cbp.dhs.gov.