How make sections of report disappear?

I need my subreport to disppear i.e be invisible and take up no space in the report when a column in my query equals a certain value. How do I do this? I tried setting .visible -= false but I get a large blank area. I do have CanShrink = true in my subreport

Do you have the CanShrink property set to true for the
detail section of the main report?
-----Original Message-----
I need my subreport to disppear i.e be invisible and
take up no space in the report when a column in my query
equals a certain value. How do I do this? I tried
setting .visible -= false but I get a large blank area. I
do have CanShrink = true in my subreport
.

Yes it is. Any more ideas?

----- golde wrote: -----

Do you have the CanShrink property set to true for the
detail section of the main report?
-----Original Message-----
I need my subreport to disppear i.e be invisible and
take up no space in the report when a column in my query
equals a certain value. How do I do this? I tried
setting .visible -= false but I get a large blank area. I
do have CanShrink = true in my subreport
.

Not the most satisfying solution since if the visible property of the subreport is false and the subreport and the section of the main report it is on has a CanShrink property set to true, there should not be large blank area on your report. Until you get a better answer, you can set the CanGrow property of the report to true and the CanGrow property of the section of the report that your subreport is on to true and shrink the size of the subreport down to a single line or less so the blank space will be less obvious.