How to show data in the header of SSRS 2005 MULTIPAGE report?

Question

This question was very helpful, however I have a list control in my report, and when the report grows over 1 page - data in the header only shows up on the last page of the report.

Apparently, hidden textboxes have to be on every page of the report for header to function properly, how do i do that? The only control i have in the list is a textbox with bunch of text that grows way over 1 page.

Solution: All I needed to do is to use Report Parameters with queried values from my dataset; and then reference

=Parameters!Name.Value

in the textbox in the header of the report.

Answer 1

sExchange website to the rescue!!!

All I needed to do is to use Report Parameters with queried values from my dataset; and then reference =Parameters!Name.Value in the textbox in the header of the report.

Answer 2

the hidden text boxes can be placed within a rectangle that was a repeatwith property set to be your list item.

Answer 3

Also check out this .Net Playground entry. It talks about using the code tab in the report properties to create a static varible to store the data value.

Answer 4

Select Report Parameters,Add new parameter and check hidden,allow null and allow blank value. if u r retrieving the values from database

Under Available Values:

check "from query" radio button and provide dataset,value field and label fields.

Under Defaul Values:

check "from query" radio button and provide dataset,value fields.

Now provide the value for text box in the footer/header as "=Parameters!Footer.Value"(Footer is the parameter name)