I have a main report that is sorted and grouped by LastName, FirstName, MiddleInitial, and SSN. The SSN is the primary key on the table. I also have a subreport printing in the detail section of the main report, linked by SSN. The problem I am having is that each person's set of data is printed 3 times. How do I structure my report/subreport to print only one set of data for each person?
Also, if the subreport spans multiple pages, how do I print the person's name and SSN on all pages?
I don't have to worry about the name on the first page because the main report data is printing it.