SSRS: Can I make a rectangle that truly hides

Posted on 2010-01-05
Last Modified: 2012-05-08
I have a report at the bottom of which has an optional section.  This optional section is entirely contained in a rectangle.  My problem is, when I set this rectangle's hidden property to true, it is hidden but there is still whitespace added to the end of the report (where the rectangle would be).  I don't want to create a sub report if avoidable, is there anything I can do to get it all the way hidden?

I'm attaching a screenshot of the designer with the rectangle selected as well as a sample output of the report with data.

Question by:jdroger2
    LVL 26

    Accepted Solution

    I am afraid you may have to go with a sub report unless you can shrink what is in the rectangle because the rectangle must be large enough to hold what is in it.  For instance, I can put two tables inside a rectangle and then colapse the hight of the tables to almost nothing and then colapse the rectangle to that size, then if I do not hide the rectangle, the tables and rectangle will grow to show what is in them, beyond what the tables or rectangle were sized at, but if I hide the rectangle, it only takes up that miniscule size.  Your example looks complex so I am not sure what you have in that rectangle and if you can work with this idea but I think that is the only way to get it to work.
    LVL 13

    Expert Comment

    please give me the report properties: Paper Size, Margins and the Body Size as well.

    LVL 1

    Author Closing Comment

    shrinking the heights did the trick thanks!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now