Monday 9 May 2011

SSRS - Display Body Data In The Report Header

Need to put data into a textbox in the header, eg System Currency so that, [Market Value (USD)]. The solution was to place a textbox on the body of the report and make it hidden. In the textbox add in the data needed (i.e. =Fields or =Countrows). Then set that textbox to RepeatWith the table in the body.

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