In your Layout section for table settings properties. Set the FixedHeader setting to True to keep the headers visible as you scroll down
|||So-called fixed headers are available starting with Reporting Services 2005.
They are supported for matrix (see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167377&SiteID=1) and table.
Matrix: you can either have it on the row groups or column groups.
Table:
a) you can have a fixed table header (select it in the table properties dialog)
b) or you can have left-most or right-most fixed table columns (select an entire table column, and look for the "FixedHeader" property in the VS properties window of report designer).
-- Robert
|||HI Robert,
I want to create a report with SQL Server Reporting Service 2000 where I need to have a fixed header and one fixed coloumn containg names of row items. I tried to find "Fixed Header" property in table region of toolbox but could not locate it anywhere.Can you please kindly tell me where should i look for it?
Thank you in advance.
Bharat Gadhia.
|||In the Grouping and Sorting Properties pop-up window that you get to when you click on Edit Group, that is where you will find (under the General tab) the following check box:"Group header should remain visible while scrolling."
Note that one of the entries said it is a property of the GROUP.|||HOWEVER, that is in Reporting Services 2005. Also, in a matrix I froze a header on a column group, and in the Preview it was of frozen (although it did not function very elegantly), but when it got over to EXCEL it was not frozen at all. So, does anyone know: can you freeze a column header or row header in a matrix in Reporting Services and have it still be frozen after you EXPORT the report to EXCEL?
No comments:
Post a Comment