Report Section - Not "Shrinking" when lowest objects are not visible

[NJonge01]

Hi, I have a report that should conditionally show some objects on the Report Header. These are the lowest objects in that section and they're not always necessary depending on where I'm opening the report from.

My code to conditionally set some objects to .Visible = False is working well.

However, the Report Header is not "shrinking", it is just leaving the large empty space. Even if I try to conditionally change the height using Section(1).Height = x * 1440, in the Report Open or even the Section Onformat property isn't reducing the size of the section.

I wonder what I'm missing? Thanks!

[hjozinovic]

Hi,

You can't just hide the controls for the header to shrink.
The controles are still there taking up space even when Visible property is false.

Probably the best solution would be to copy the report, delete the controles you don't need and run different versions from different locations.

Also, you could try to shrink the controles before setting their visible property to false.
Set Header's Can grow property to true
And if you need to see the controls you can set their Height property to higher value. you can do this by setting their Height equal to height of some other control that is allways visible for example.

regards,
h.

[NJonge01]

Sorry I've been away. Thanks for clarifying that situation and offering the suggestions!

Its not real pretty in design view, but I actually hide the objects and move them "up" in the detail section so that the page can shrink.