No event-based scripting in SSRS/Report Builder 3.0??
Hi All, I use Report Builder 3.0 to author reports that are run on a web server (accessed by on off-the-shelf web application). I design a form in the web app where parameters are selected and then passed on to an instance of the report file for display. Part of the report's design are text boxes that show the specified parameters passed in. The report body contains one tablix, with one major group level, and page breaks specified between each group instance (after printing, the report will be chunked out to the different grouped entities). Page numbers are reset at each page break. What I'm trying to accomplish is to have the parameter display text boxes show on the first page of each group, and then hide them (along with their page real estate) until after a page break for the next group. Right now these text boxes are in the Page Header - since =(Globals!PageNumber>1) is being used to show/hide them. The show/hide part works, but on the pages where the text boxes are hidden the vertical space is still taken up. How can I either control the page header height or somehow use variables to accomplish this? Any/all help is greatly appreciated :) Hal
November 7th, 2012 5:13pm

Hi Hal, Thanks for your post. Based on your requirement, please try to specify the CanShrink property of the textbox to True in the textbox properties dialog box. Then the vertical space will be removed when the textbox is hidden. (Note: make sure the other repot items on the page header are not aligns horizontal with the exact textbox). Regards, Fanny LiuFanny Liu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2012 4:09am

Hi Hal, Thanks for your post. Based on your requirement, please try to specify the CanShrink property of the textbox to True in the textbox properties dialog box. Then the vertical space will be removed when the textbox is hidden. (Note: make sure the other repot items on the page header are not aligns horizontal with the exact textbox). Regards, Fanny LiuFanny Liu TechNet Community Support
November 12th, 2012 4:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics