We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Freezing columns issue in SQL Server SSRS 2008

JLEmlet
JLEmlet asked
on
Medium Priority
861 Views
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.
Comment
Watch Question

Commented:
Are you using the scroll bar on the side or the wheel on the mouse? Does it make a difference?
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
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

Commented:
It happens on Chrome, IE 8 and IE 9.

Commented:
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

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.