Report that shows duplicate survey's

Robert Campbell
Tera Guru

How can I create a report that will show me when a single incident has multiple surveys.

 

RobertCampbell_0-1704496364784.png

This was my only option as a related list but this isn't what I need because it shows no records and there are at least two incidents that have received multiple surveys.

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Robert Campbell ,

 

You need to turn the report around. So make the report based on the incident table, and the related list condition should be 2 or greater than 2 - See below screenshot:

AndersBGS_0-1704541519449.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

10 REPLIES 10

Hi @Robert Campbell ,

 

no, unfortunately not - the only thing that I can think of is to create a database view to combine the two tables and have both incident numbers and surveys numbers on the same list view.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/