Duplicate results from a report showing customer satisfaction survey results

[AbbasP]

Hello all,

I currently have a customer satisfaction report which points to a virtual table created in Database view. The report is working as expected, however, it shows duplicate results when running the report. The surveys which are completed by the end users is completed once, so I am not too sure why there are duplicate results...

Database view is as follows:

Report results is as follows:

How do I get the report to not show the duplicates?

[J Siva]

Hi @AbbasP 
Based on my understanding, you are trying to retrieve comments added by the user when they are dissatisfied with the service or resolution. Is that correct?
If that is the case, you will have two records—one capturing satisfaction and the other capturing comments. As a result, duplicate entries will appear in your report.
It's expected.
Please share the pic of your report filter conditions..
Regards,
Siva

[AbbasP]

Thanks @J Siva ,

Please see the attached image which shows the report filter conditions for both reports.