Question:

Why does a Report with related Records not filter Main Records or is missing Related Record data? It is using a filter such as Main Record equals/in Record Number?

Answer:

Related Record reports use a Left Join so all Main Records are returned. There should be a Related Record filter condition with a value of has at least one included in the report.

Related Documentation:

Vault Report Documentation: Using Report Filters