The first things to review when a report does not work are:
the selection criteria
the relationship(s) between the tables. For additional information on relationships, please go to lookup codes > association > relationships.
Another thing to review when a report does not work are:
Make sure Verify on every Print is turned on (has check mark). This is an option under Database menu.
Under the Database menu, choose Verify Database.