Reporting Services - Group Name in Page Header

Question

I have a report with one group (Office Name) which page breaks between each group - so the data for only one Office can appear on a given page. How do I get that Office Name to appear in the page header?

I tried creating a hidden textbox in the details section of the report which has the Office Name value and then referencing that in the Page Header, but I get the last Office Name value on page 1 and then it is blank on every other page.

Answer 1

I got it to work and I'll post the answer in case someone else runs across this issue.

For some reason referencing the text box did not work, but when I put a hidden column in the table with the same value, I could then reference that in the Page Header.

Answer 2

We have the same requirement. Can you give Details?