How to hide/suppress Report header based on Report Parameter values

Question

How to hide/suppress Report header based on Report Parameter values

Saintmount.Sql

Ten Centuries

Points: 1023
More actions
July 1, 2013 at 12:35 pm

#279373

Hi,
I'm displaying Report parameter values in Report header, it’s around 25 parameter values in each page.
I don’t have any issues in this...
Issue will be when I have single parameter how do suppress text item size in report header area.
Currently I'm getting more empty space.
I need to display more no of report parameter(around 25) value , and when we pass single parameter we need to display that parameter(1) value alone. Issue is How do hide/suppress empty space in header area.
Please let me know if any suggestions. Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

geoff5 Hall of Fame Points: 3560 More actions · Answer 1

Make sure the Report property of "ConsumeContainerWhiteSpace" is set to "True." Then use the Visibility property of each of the text boxes and define an expression that will return "true" whenever the value of the corresponding parameter is null or the default value that does not need to display. Make sure that the most commonly selected parameters are higher than the less commonly selected parameters. I believe the rendering method is to consume white space below the last printed item to the bottom of the container (such as the page header section), but it does not consume white space above the first printed item.

Edit: On second thought, why not just have one text box with an expression that concatenates all the selected values together? If you want multiple lines, you can use vbCRLF to add line breaks between the strings. With only one text box, you can always be sure it will take up the minimum space needed for the included parameter options.

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 2

Hi, I tried with 2 option.

Thing is Report body section start with some empty space while passing single parameter value.

i.e. there will be space between the header and body section. Any idea how to reduce the space.

Thanks,

geoff5 Hall of Fame Points: 3560 More actions · Answer 3

I cannot visualize your design clearly enough with the information I have to make a further recommendation. If you can attach a screenshot of the design layout, I might be able to suggest a way to eliminate the white space.

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 4

Attached sample screen for empty space (in report header) while passing single parameter value.

Note: we have multiple (6) level of groups in the table.

we need to display Report parameter value in each page.

Thanks

geoff5 Hall of Fame Points: 3560 More actions · Answer 5

In the design, make the text box only big enough to hold the <Exp> placeholder text. Text boxes have a "can grow" property turned on (true) by default, so if more room is needed to add lines of text, it will expand vertically to hold the text. Unless you specifically turn "can grow" off (false), it will do this. On the other hand, even setting "CanShrink" to "True" does not always have the desired effect.

So start with the box at the minimum size in the design, and let it grow dynamically to hold the text, rather than make the box big in the design and then try to make it shrink in the output.