SSRS 2008 Report and Hidden Rows

Posted on 2011-10-04
Last Modified: 2012-05-12
I have created this SSRS 2008 report. I needed to have data fields appear in the header so I added two rows and tagged them as hidden in the body(the first two rows). When I print this report, it does not print any of the data but it is still preservering the space on the page. Plus on the screen the data appears to all be pushed around and not lined up, although the printed copy is aligned. Is there some other property of the row I need to set in addition to hidden to TRUE for it not to do this?
Question by:rwheeler23
    LVL 27

    Expert Comment

    need to place the data in textboxes in the same roll as your data that you want to see.
    only have the hidden textboxes under the visible textboxes and when you print you will only see the data that you want.

    Author Comment

    I do not quite understand. You cannot put data fields in the header so I use ReportFields! in the header to pull values out of the the body. How do I set the role of text boxes in the body to be the same role as text boxes in the header?
    LVL 27

    Accepted Solution


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (  This article explained how …
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now