Reporting Services 2008 Header Issue
I have a report in which i display an employee name in the group header. The employee name is part of the dataset that is displayed in the tablix and the data is grouped on the employee name. I created a textbox in the group header. I have the employee name as a hidden field in the tablix rows. I reference the hidden field from the textbox in the header using the ReportItems method. A new page is created for each employee (group) and the header is displayed at the top of each page. The value in the textbox (in the header) changes as it should as you page through the report as it should. Where the issue arises is when I export the report. No matter what I try to export it to the value in the textbox doesn't change for any page after page 1. The page 1 value is always displayed in the textbox.
February 12th, 2011 3:16am

Hi, Generally, since we have a group by employee, we can refer to the data field of employee name in the group header directly. For example, we can specify the expression like =Fields!EmployeeName.Value in a textbox in the group header. However, if this cannot meet the requirement, please elaborate the purpose of referring to the hidden textbox of employee name in detail row. In addition, which format you export the report? I also tried the approach you posted. It works fine when I exported the report to PDF. If possible, please also post a screenshot to show the Tablix structure. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 10:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics