Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Problem displaying dataset value in page header

Author  Topic 

eguthrie
Starting Member

2 Posts

Posted - 2007-10-23 : 17:16:43
I want to display a value from a dataset within the page header of a report. I placed the value in a hidden textbox named "txtFacilityName" which contains this expression:
=First(Fields!FacilityName.Value, "dsFacility")

In a textbox of the page header, the expression I use is:
=ReportItems!txtFacilityName.Value

The problem is that the page header text only correctly appears on the first page of the report. On all subsequent pages, the page headers are blank.

Can anyone tell me what I'm doing wrong? How can I get the value to appear on all the pages?

Thanks in advance for any help.

tm
Posting Yak Master

160 Posts

Posted - 2007-11-02 : 16:19:43
Try adding a List Report Item and put the your other Items into the List.

You will need to do some setup for the list and table item if you have them.
Go to Top of Page
   

- Advertisement -