Skip detail when all fields are duplicate?

[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

 

[KARL DEWEY]

Set the 'Hide Duplicates' property to Yes of the fields in question.

 

[Duane Hookom]

I would probably change the report's record source to a GROUP BY query to
remove duplicates.

 

[John Harrington]

Set the 'Hide Duplicates' property to Yes of the fields in question.

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

 

[KARL DEWEY]

Set the 'Can Grow' property to Yes. Reduce the vertical size to a hairline.

 

[John Harrington]

Set the 'Can Grow' property to Yes.  Reduce the vertical size to a hairline.

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

 

[KARL DEWEY]

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

 

[John Harrington]

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

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


Thanks,
John

 

[Duane Hookom]

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.

 

[John Harrington]

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.

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


Thanks,
John