Subreport duplicates in main report

[Guest]

I have created a simple main report that only consist of LastName, family
code. I then added a multiple column subreport which only shows FirstName.
There is a record for each student. Some of the students will have siblings
going to the same school. So that means that they to have a record. The
family code helps us sort them together. So one whole family may have upto 4
records if there are four family members going to the same school. I am
trying to print a report that show the following:
(Record 1) (Record 2) (Record 3) (Record 4)
LastName FirstName FirstName FirstName FirstName

Doe Bob Nancy Judy Frank

What my report is printing is the following. It duplicates the Firstname
according to how many records there are.

(Record 1) (Record 2) (Record 3) (Record 4)
LastName FirstName FirstName FirstName FirstName

Doe Bob Nancy Judy Frank
Bob Nancy Judy Frank
Bob Nancy Judy Frank
Bob Nancy Judy Frank

How can I hide the duplicates above. I have changed the properties in the
field to hide duplicates.

Thanks,

Robin

 

[Duane Hookom]

Remove all child details from the main report so that its finest level of
detail is the family.

 

[Guest]

I must be missing something. I still can not get rid of the duplicates. I
went back to the main report and left the field "Family" (Which you
indicated) Which every student has this field this is so that we can match
up family members. I then inserted the subreport. The subreport is linked
by the family field. The subreport is set up to only print First Name in
multiple columns.

Here is the data before anything is done.


LastName FirstName Family

Doe Bob D1
Doe Nancy D1
Doe Judy D1
Smith Nancy S1
Smith Terry S1


All fields are set not to print duplicates. even in the subreport. When
the report prints I get the following:


(Record 1) (Record 2) (Record 3) (Record 4)
LastName FirstName FirstName FirstName FirstName

Doe Bob Nancy Judy
Bob Nancy Judy
Bob Nancy Judy
Smith Nancy Terry
Nancy Terry

I hope this makes more sense.

Thanks,

Robin

 

[Duane Hookom]

Do you see records for Bob, Nancy, Judy,... in your main report Record
Source? Make sure your main report's Record Source groups by Family &
LastName and does not include any fields for FirstName.

If you can't figure this out, come back with the SQL view of your report's
record source.

 

[Guest]

Thank you very much. This helped tremedously.

Robin