Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Listing all your SQL Server databases ordered by sizeGetting the biggest tables in your SQL Server database »
    comments

    This blog is part of my series Making Data Tell a Story With SSRS Properties.

    Property: FixedColumnHeaders

    The purpose of this property is to keep column headers visible as you scroll down a page to view data.

    To access the property, select the tablix and select FixedColumnHeaders.

    The options are True or False.

    Example: I have a matrix that display order counts and totals by year, grouped by sales region. The Year header appears when I am at the top of the rendered report.

    I go to the tablix properties and set FixedColumnHeaders to True (and the Background Color to white). When I view the report again, and scroll down, I see the header at the top at all times.

    Further Reading:

    Controlling Row and Column Headings (Report Builder 3.0 and SSRS)

    About the Author

    User bio imageJes Schultz Borland is a Consultant with Brent Ozar Unlimited, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, is a Microsoft Certified Professional in SQL Server 2012, and has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and SSRS. She is an active member of PASS, President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
    Social SitingsTwitterLinkedInLTD RSS Feed
    InstapaperVote on HN

    No feedback yet

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)