Out of the box SSRS reports cannot have data exposed in the page header. Is there a way to get this data to show?
views:
2247answers:
5
+3
A:
You have to do it through Parameters. Add a parameter for each piece of data you would like to display, then set the parameter to Hidden. Then set the default value to "From Query" and set the Dataset and Value field to the appropriate values.
Orion Adrian
2008-09-15 15:39:53
A:
Here are two possible workarounds:
You can place the databound field within the body of the report as a hidden textbox, and then in the header place another textbox with it's value pointed at the the one hidden within the body.
Try using report parameters to store the data, and use those parameters to access the data in the header.
ipstset
2008-09-15 15:44:46
+1
A:
This technique wouldn't work if your report spans over multiple pages, use queried parameters instead, and set the textbox value to =Parameters!Name.Value as per this article.
roman m
2008-09-24 06:05:37
It works very well, I do it in long reports spanning multiple pagesWhat you need to do, is to watch where you put your placeholder fields, I use an table to show tabular data, and creates extra columns which I hide. no problem at all.
neslekkiM
2008-10-06 07:42:49
This doesn't work if the table doesn't span all of the pages in the report.
AaronSieb
2008-11-04 17:48:50