Skip detail when all fields are duplicate?

  • Thread starter Thread starter John Harrington
  • Start date Start date
J

John Harrington

How do you get a report to skip the detail when all the fields are
duplicates of the previous detail's fields?


Thanks,
John
 
I would probably change the report's record source to a GROUP BY query to
remove duplicates.
 
Set the 'Hide Duplicates' property to Yes of the fields in question.
Click to expand...

Sorry, I should have been clear. All the text boxes are set to Hide
Duplicates=Yes. The problem is that when they're all blank, I get a
blank line. It does not skip the detail. I would like it to skip the
detail.


Thanks,
John
 
Set the 'Can Grow' property to Yes.  Reduce the vertical size to a hairline.
Click to expand...

Thank you for the suggestion, Karl.

When I do precisely as you say (turn on Can Grow for all the text
boxes on the line, reduce their heights to hairlines and do the same
for the detail), all the lines disappear completely, the blank lines
and the data lines.

Amazed by this, I tried making the boxes just slightly taller. Then
some of the data disappeared, some remained!

Twip by twip I tried making the boxes slightly taller and changing to
report view. At some point, all lines reappear along with the blank
lines.

Thinking that maybe there was something wrong with the report, I made
a new, very simple report with just one of the text boxes. Same
thing.

Any other ideas?


John
 
Try making boxes regular height and set Can Shrink to Yes.
Click to expand...

Set text box and detail to can shrink. Just get the data lines and
blanks lines, like before.


Thanks,
John
 
I think your issue is your data. You could either change the record source to
a GROUP BY or create a new GROUP Section to display your duplicate
information in a header and then hide the detail section.
 
I think your issue is your data. You could either change the record source to
a GROUP BY or create a new GROUP Section to display your duplicate
information in a header and then hide the detail section.
Click to expand...

Thanks to everyone for their responses. I ended up doing something
similar to this. Thank you, Duane.


Thanks,
John
 
Back
Top