Issue with Frreezing columns in Reporting services 2005

I have tried to freeze the leftmost column of my report , by seetting the fixedheader proeprty to 'TRUE' For that column. The columns gets frozen. I also set the background color of that column to 'WHITE' Color. However, when I try to scroll left or right, the next columns seem to overlap to the first column...

ANy ideas how to fix this?

It looks like some of the problem lies with having multiple groups and multiple colors. I have been trying to resolve the same issue.|||

Would you please either attach or send me email me a screenshot so I can better see what is going on? We have some fixed header fixes for the HTML renderer in SP2 and one or two more in the latest Cumulative Update so make sure you are at least running SP2.

Thanks.

|||

I beleive we are runnning SP2 THis is the SP Version, we have, ie

Microsoft SQL Server Reporting Services Version 9.00.3042.00

Is this SP2?

Here is the snapshot- See how the columns are NOT aligned.

Microsoft SQL Server Reporting Services Version 9.00.3042.00 ...

I could not find an option, to attach the screenshot here in this post. Can you pl forward me ur email, so I can email u the screenshot.

Thanks.

|||

It's on my profile: donovans at microsoft dot com

Thanks.

|||

Tarana sent me the information via email which helped me confirm this is a known issue with SQL Server 2005 SP2. A fix has been created and will be available in the next cumulative update due later this month. When it is available, you can find it at http://support.microsoft.com/ph/2855. Note that the build 3161 is the previous update and does not contain this fix.

Thanks.

|||

This update is now available at http://support.microsoft.com/kb/936305. The title of the specific fix is ‘After you install SQL Server 2005 Service Pack 2, table rows in a SQL Server 2005 Reporting Services report are misaligned to the FixedHeader column if the UserSort feature is enabled in the report’.