I have a Main/Sub report with 2 items that are variable, so that under specific conditions, they should not print on the report and I would like the white space (blank lines) to shrink.
The first is a label in the Detail section of the report. If the report textbox named TradeIn = 0, the label named TradeInParagraph should not print (this part works fine) and the Detail section should shrink to remove white space.
The second is contained within a subreport in the main report’s Detail section. It is located in the subreport’s Report Footer. If the subreport’s textbox, named TradeIn = 0, the label and textbox, named CustomerTradeInLabel and CustomerTradeIn should not print (this part works fine) and the subreport’s Report Footer should shrink to remove the white space.
Although, the items do not print and there are no other controls on these lines, I cannot get the shrinking part correct. Despite setting the Can Shrink Properties for the main report’s Detail section, subreport’s Report Footer section and associated controls (except for labels) to Yes, big blank spaces persist.
Reading about this hasn’t helped … I’m confused about what I can Shrink and what I cannot Shrink. Are there CanShrink Properties for labels? I need help in getting this right. Thank you.
