0

In an SSRS report, instead of a page header, I've a table header that I've made to repeat at the top of every page. I can't use page header since it is a sub-report and headers/footers of a sub-reports get over-ridden by the main report.

The report prints labor hours for all employees, with each employees record appearing on a new page. The table header repeats correctly on top of every page. When I run the report, it prints out labor hour for all employees. What I want is to display respective employee's name in this table header, however, the report is repeating the first employee name on the top of every page. How can I fix this? enter image description here

enter image description here

SJaka
  • 712
  • 13
  • 40
  • Whats the Expression for that field? – Filburt May 05 '17 at 21:39
  • 1
    =ReportItems!Name.Value should give you correct result assuming the report is grouped correctly. – Alan Schofield May 05 '17 at 22:45
  • @Filburt the value of the expression is `="Name: " + Fields!Name.Value` – SJaka May 08 '17 at 12:32
  • @AlanSchofield I'm using the `Fields!Name.Value`, however, the issue is that the value doesn't get re-evaluated at the top of each page. My guess is that it gets evaluated only at the beginning of the first page, and on following pages, it just gets replicated. Any ideas? – SJaka May 08 '17 at 12:35
  • Try using the the reportitems value as suggested but only in your header expression, that should work – Alan Schofield May 08 '17 at 13:35
  • I'm getting a grouping error **Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope** – SJaka May 08 '17 at 14:30

0 Answers0