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 
You need to revist your DB view configuration.
If possible, please share clear picture of your DB logic. I can't see anything in the existing snaps 😞
Regards,
Siva

[AbbasP]

Apologies, I have attached some clearer images...

[Ankur Bawiskar]

@AbbasP 

images are not clear, but are there duplicate surveys taken by someone on that assessment record?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AbbasP]

@Ankur Bawiskar @J Siva ,

Please let me know if the images are clearer now...