By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,044 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,044 IT Pros & Developers. It's quick & easy.

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

P: 44
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!
Jul 18 '08 #1
Share this Question
Share on Google+
2 Replies

P: 167

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.

Jul 18 '08 #2

P: 44
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.
Aug 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.