Freezing columns issue in SQL Server SSRS 2008

Posted on 2011-04-21
Last Modified: 2012-08-14
Hi all -
I have a report created in VS2008 for Sharepoint 2010. My SSRS server is integrated with sharepoint properly and reports are rendering fine. However, I have one report that is a simple Tablix with three row groups.

When I view it in VS2008, everything looks fine.  However when looking at the report within the Sharepoint site the scrolling is screwed up.  As you scroll down, the actual report doesn't move down very much until you get to the bottom and then it jumps from the top to the bottom.

I also can't seem to get the correct code for freezing the rows for my outer most group.  

Any help is appreciated.
Question by:JLEmlet
    LVL 4

    Expert Comment

    Are you using the scroll bar on the side or the wheel on the mouse? Does it make a difference?

    Accepted Solution

    The scroll bar in the window.
    LVL 4

    Expert Comment

    Does it matter which browser you use? This is often a browser issue, can you test a few and see if it behaves better in some than in others?

    Author Comment

    It happens on Chrome, IE 8 and IE 9.
    LVL 4

    Expert Comment

    Does the scrolling issue remain if you remove the code for freezing the rows of the outermost group?

    Can you provide the code you are using for the freezing so that we can help you?

    Author Closing Comment

    I figured out that I had deleted some of the column static groups by mistake.  It resulted in very poor performance of the report.  I recreated the report from scratch and all is well.  Thanks.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SSRS parameters, tablix filter question 17 37
    SharePoint 2013 - Web tier pages 5 34
    Instant VM Recovery 4 61
    Sharepoint to FTP? 3 38
    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…
    The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 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

    19 Experts available now in Live!

    Get 1:1 Help Now