I'm creating a report that will summarize the outstanding items each person has. There are two areas that I have to add to the report - a borrower and their guarantors. There is one borrower and many guarantors. There are also many outstanding items per borrower.
However, when I create my report the outstanding items are duplicated, one set of outstanding items for each guarantor. EX
name oustanding item
George Jetson...............tax returns
Jane Jetson..................financial statement
Scooby Doo..................collateral evaluation
George Jetson...............financial statement
Jane Jetson..................collateral evaluation
Scooby Doo..................tax returns
etc....
The tables are set up so that each annual review has a number that is the key. The guarantors have their own table with the annual review number as well as the outstanding items table has an annual review number too. I have set the relationship to enforce integrity.
I just want the report to list the outstanding item once and the guarantors once. I have tried hiding duplicates and that doesn't seem to work either. Any suggestions?? I'd greatly appreciate it! THANKS!!