I am having a lot of trouble getting a sub-report to shrink on a report if there is no data in the sub-report. Therefore, the sub-report takes up a lot of room on the report leaving big gaps. I have the text boxes set to Can Shrink = Yes. I have made sure nothing overlaps. I've made sure all objects are snapped to the grid. On and on and on.
So now my question is... Is there a way to make the height of the detail section be 0 if there is no data in the textbox and then bring it back to .1667 when the report is closed?
the sub report itself on the main report should be set can shrink = yes.
and the section on the main report where the sub report is located should be set can shrink = yes.