There is most likely a relationship problem. You don't reference how the tables are set up, the scripts that create your reports, etc.
Probably best if you can post a sample file.
Again I'm a novice so I'm not sure where to get the tables and scripts but I am uploading the FMP document to this link. Feel free to download it and see for yourself.