how to freeze column header

Question

Hi All,

I refer to this thread to freeze column heading, then get the following error. Please give me some help. 

http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/D284D1F9-57F9-495C-94C1-56636057FDAF

 

Error 1 [rsInvalidFixedHeaderOnOppositeHierarchy] The tablix 'Tablix1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedColumnHeaders of tablix. D:\Code\Work\MS BI\Requirement & Work\NA_parter_Reports\FY2011\Business MGMT\Business MGMT\FY11_CanadaAndUS_UnknownActivities.rdl 0 0

BR,

Riquel

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 1

Hi Riquel,

This is because you have set this form Poperty Page and you have also kept Tablix.FixedColumnHeaders on. For more detail refer this link

http://msdn.microsoft.com/en-us/library/ee208955.aspx

But, to resolve this

1) Open tablix property box.

2) On general property page, un-check the "Keep Header Visible While Scrolling" in "Column Header" serction.

---

- Chintak (My Blog)

Answer 2

Here's the link:

http://hardik-bhavsar.blogspot.com/2011/03/keep-column-headers-visible-while.html

 

Thanks

_______

Plz mark as Answer if your problem is resolved.

Answer 3

Thanks guys for your kind  help. Let me try it.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.