SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Saintmount.Sql
Saintmount.Sql
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 507
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.
geoff5
geoff5
Say Hey Kid
Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)

Group: General Forum Members
Points: 666 Visits: 543
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
Saintmount.Sql
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 507
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
geoff5
Say Hey Kid
Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)

Group: General Forum Members
Points: 666 Visits: 543
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
Saintmount.Sql
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 507
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
Attachments
Empty space in header area.docx (15 views, 49.00 KB)
geoff5
geoff5
Say Hey Kid
Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)Say Hey Kid (666 reputation)

Group: General Forum Members
Points: 666 Visits: 543
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search