Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to hide/suppress Report header based on Report Parameter values Expand / Collapse
Author
Message
Posted Monday, July 1, 2013 12:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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.
Post #1469191
Posted Monday, July 1, 2013 12:55 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 159, Visits: 465
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.
Post #1469198
Posted Monday, July 1, 2013 3:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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,
Post #1469223
Posted Monday, July 1, 2013 3:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 159, Visits: 465
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.
Post #1469232
Posted Monday, July 1, 2013 8:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506

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


  Post Attachments 
Empty space in header area.docx (8 views, 49.03 KB)
Post #1469277
Posted Monday, July 1, 2013 10:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 159, Visits: 465
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.
Post #1469284
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse