duplicate pages

[Guest]

I have a report from a query that has two tables with a one to many
relationship because one field has many records relating to the other table.
When I make a report from this query I get a page for every record in my
second table. How can I limit the report to only show the employee name only
once, yet show all the groups he belows to?

TIA!

 

[Guest]

There are three ways I knew of to hide the employee name after it printed once
1. create a group header for the employee and put his name there instead of
in the details section
2. use code
3. if you want to leave the employee name in the detail section then in the
field property there is HideDuplicates Property, change it to true.

I hope that what you looking for.