[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Freezing columns issue in SQL Server SSRS 2008

Posted on 2011-04-21
6
Medium Priority
?
848 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.
0
Comment
Question by:JLEmlet
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:sumerdai
ID: 35444418
Are you using the scroll bar on the side or the wheel on the mouse? Does it make a difference?
0
 

Accepted Solution

by:
JLEmlet earned 0 total points
ID: 35445669
The scroll bar in the window.
0
 
LVL 4

Expert Comment

by:sumerdai
ID: 35447614
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?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:JLEmlet
ID: 35447720
It happens on Chrome, IE 8 and IE 9.
0
 
LVL 4

Expert Comment

by:sumerdai
ID: 35506375
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?
0
 

Author Closing Comment

by:JLEmlet
ID: 35711419
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

834 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