For Classic Reports that are generated using Non English CommCells, the text output with tab delimiters opens with corrupt characters. To avoid this problem, generate the report with comma delimiters.
If you received the report in an email, or you want to open a report that was already saved with tab delimiters, you must first save the report as a text file, and then import it into Microsoft Excel.
To open a report so that characters display properly:
-
In the CommCell, click the Reports tab, and then click one of the reports buttons.
-
On the Output tab, select Output Format: Text, and then click Run.
A message appears that asks if want to Open or Save the report.
-
Click Save.
-
From the Save as type list, select All Files.
-
In the File name box, enter a name for the report with the .txt file extension, and then click Save.
For example:
BackupReport1.txt
-
Open Microsoft Excel.
-
Click the Data tab, and then click From Text.
The Import Text File dialog box appears.
-
Select the saved report, and then click Import.
The Text Import Wizard appears.
-
Click Next.
-
Click Next.
-
Click Finish.
A message appears that asks where you want to put the data.
-
Click OK.
The report data appears in the worksheet.