Eliminate (not make invisible) a subreport with No Data

[TZyk2003]

Good morning all!

Here's my question, hopefully it's easy:

I have a Report with 6 subreports. They are all located in the Details section and are placed 1 at the very top of the details section then the remaining 5 beneath one other.

Now, some reports will have data and some won't. If one the reports has NO DATA then it should not be printed. This works fine but it still leaves a blank space. (i.e. the subreport is invisible but a blank space is there) Since there are 6 subreports the blank spaces make the report ugly and too long.

How can I get the subreport to NOT SHOW UP and NOT LEAVE BLANK SPACES when there is NO DATA????

Any code you could throw at me would be great. THANKS!!

-Tim

 

[CosmoKramer]

Try setting the subreports to be as thin as possible vertically with their Can Grow property set to Yes.



A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams