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