I have a SQL Report in SQL RS 2008, I have tables setup to group on project number and display various information about the project. The report is setup to page break after each group.
I want to have a header that will display pertinant information in the header of each page. My understanding is page headers can only contain static data and not expressions but I can refer to text boxes within the report.
So if I have a text box in my report, for example, Job number, that changes on each page with the grouping how do I reference that in the page header? I'm sure it's a simple syntax but I am still pretty new to SQL.