To export report data as a spreadsheet:
-
Click the Export Report To Excel button in the report title. The Export To Excel dialog box is displayed.
-
Enter a file name for the exported file in the File Name field. By default, the title of the report is used as the file name.
Note:
Report titles may contain characters that are not allowed in file names. Illegal characters are replaced with an underbar ( _ ) in the exported file name.
- Select a file format from the Excel Format drop-down list.
-
If CSV is selected as the format, enter the separator character to use in the Separator field. The default character is a comma ( , ).
Note:
The Separator field is only enabled if CSV is the selected format.
- Select Filters to include the filters applied to the data item in the spreadsheet.
- Select Parameters to include the parameters applied to the data item in the spreadsheet.
-
If Filters or Parameters is selected, select where in the spreadsheet to put the information from the Position drop-down list.
Note:
The Position drop-down list is only enabled if Filter or Parameters is selected.
- Click Export. The file is saved to the Downloads folder of the user currently logged in to the workstation. For example, C:\Users\JohnDoe\Downloads.