Hello,
this is an error in the way the SQL query is created by Backup Exec. The query provides the data for the report and is contained in the backup definition.
Try this:
1) Have a good text editor at hand. E.g., Notepad++.
2) Locate the file in which your report definition is saved. You can see the basename when you display the properties of the report in Backup Exec. It would typically be something like CustomerReport1__en.rdl. The folder will be <Program files folder>\Symantec\Backup Exec\Reports.
3) Open the report definition file in the text editor.
4) Locate the section where the SQL query is specified that provides the data for the report. This is located towards the end of the file and is preceded by the <CommandText> tag.
5) In the SQL query, insert the word "DISTINCT" (without quotes) after the word "SELECT". Make sure there is one space before and one after the word "DISTINCT".
6) If you are using Notepad++, from the menu select Format --> ANSI, to ensure that the file will be saved with the correct encoding.
7) Without making any further changes, save the changed file.
If you run the report now, the duplicates should be gone.
Note: Backup Exec is sensitive about changes to the report definition. If you make other changes, chances are you will render the report unusable. If you cannot successfully run a report after performing the above procedure, select Edit in Backup Exec, then save the report. Also, note that editing the report in Backup Exec will recreate the definition, including the query text. So if you make any changes to the report definition in Backup Exec, you will need to re-perform the above procedure.
Kurt Thomas
