Report when the value is zero

[Noobalicious]

Hello

We have 74 surveyors around the country and they use an in house application. When a survey is completed, the state of that job is "issued" and it is inserted into a specific table (Survey Report table). 

To work with us, surveyors do not have to use our app, they can manually create the survey report and submit it via email to us. In which case, the report is attached to the job and is not in the survey report table. 

We already have a report on surveyors who have issued reports within the Survey Reports table - that was easy. However we would like to be able to report on surveyors who are NOT using the app, i.e. are active surveyors but have no issued reports in the surveyor reports table. 

any ideas?

[bammar]

Possible using NEW Reporting UI

You report from the USER table, you expand the filter you see and then scroll down in blue text i think youll see something called Related List query  but you can then set the number = 0 and then aim towards the survey table.user field.

I know 100 percent this is possible but i am trying to remember verbatim from my memory so if yoou follow my steps youll see what i mean but the syntax may be different on the screen 

oh here it is

https://docs.servicenow.com/en-US/bundle/sandiego-platform-user-interface/page/use/using-lists-v3/task/create-related-list-query.html

[ServiceNow Tec2 · Accepted solution]

This has been resolved by ServiceNow Technical Support. Please refer to KB0976620 for more information.