SSRS 2008 - Header in the report does not show dynamic data

Question

I have a personal report that is sorted by department name, but when I add a field for the department name to the header, it correctly prints the name of the first department. every other page has a title, but still has the starting department name in the title instead of the correct department name. In other words, the field link to the department name that is in the report header is not updated. I looked at the data that is used from the stored procedure and the department names are in the data and they are correct.

Answer 1

Well, this is the answer that the OP ended up using and was his whole idea , I just post it because op does not currently have enough reputation to do it himself:

“Okay, here is the solution: I had to add another column to tablix and add a text field to it that contains the name of the department. Then I hid the column from the report and set a link to this text field inside the heading The name of the text field in tablix was named DepartmentName , so in the header I added a text box with the expression =ReportItems!DepartmentName1.Value . It works like a charm !!! "

Answer 2

You need to make sure that after you add the field for the department name to your heading (which I assume is a text field), the expression for this text field is not first(Fields!DepartmentName.Value,"Your Dataset") or any other gropuing function. It should just be Fields!DepartmentName.Value , assuming the title is inside the list.