Report Headers in Report Services

Is there a way to "freeze" the report headers in Report Services? I'd like to have it work like Excel does when you freeze panes. My users complain that when they scroll down the report page, they lose the column headers and lose track of which column is which.

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.