In the header place a textbox and have it set to =ReportItems!hidden_textbox.Value.
Just doing that would give me the data in the header but only on the last page of the report (note if your report is only one page you might not experience this frustration). To get the data to show in the header for each page, need to move the textbox so it was positioned on top of the table. The easiest way to do this was to change the Left and Top Location properties of the textbox. It makes it a little hard to see parts of the table since the textbox covers up parts of it but it gets the data in the header.
Eg = "Market Value (" + ReportItems!textboxHiddenSystemCcy.Value + ")"
Displays as "Market Value (USD)"
No comments:
Post a Comment