Hiding Duplicates results in Blank Lines in Report

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?
 
Do you want to remove duplicate records from a report? Have you tried
setting the controls to Can Shrink: Yes?
 
Becky said:
How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?
Click to expand...

Hide duplicates is not intended for that kind of thing. You
should probably either remove those records from the report
record source query, possibly using the Distinct keyword.

If you need the records but don't want to see them, you
could create a group on the field(s?) and place the controls
in the group header.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Duplicates 9
hiding duplicates AND spaces 2
Eliminate Duplicate records in reports 1
Extra blank line on report 1
Remove extra space in a Report 1
hide duplicate record line 6
dont show duplicates 3
hide duplicates 5

Back
Top