Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

How hide duplicate values in a group header on a report

Is there a way to hide duplicate values in a text box on a report group header?  I've tried hide duplicates = yes in the field properties but the value keeps repeating and displaying.
Avatar of PatHartman
PatHartman
Flag of United States of America image

If they truly are duplicates, it is best to get rid of them in the query by doing a group by.  If what you are trying to do is to make a report more readable by highlighting what records go together, setting the hide duplicates property will hide values that are identical to their predecessor.  

If that isn't working, try posting a picture of how that section of the report looks and how the control properties are set.
<Is there a way to hide duplicate values in a text box on a report group header?>
Then you will have to explain what you are displaying in your group header.
Typically the Group Header contains header information
So if you Group by Employee, the Employee name only prints once,
...Group by Country, and the Country will only appear once.

Not sure what field you have there that will repeat...?

This is why it is always helpful if you include an example of the issue.

JeffCoachman
Avatar of SteveL13

ASKER

See file attached.
Example.jpg
It's hard to tell from this view but you might not have enough groups.  Looks like Employee and date are part of the same group header and you should have two.  One for the name and the second for the date.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Nice!  Thanks.
great
;-)