Filtering results based upon data values

Hi anyone.   I've been tasked with creating a solution to the data integrity constraints within our application and I'm looking for suggestions and/or how-to's.   Our goal is to limit the garbage in therefore to limit the garbage out.

For our salary planning, application, some fields are mandatory in one use-case but are optional in others.  Or sometimes a start date is set to a value after an end date.  

The users are looking for a method to identify the problem records so that they can correct it.  

My initial thoughts are

a) a report that can be filtered, but I don't know how to filter data in financial reports other than the skip missing/blank/error and the advanced