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
 Need Field In Header With Page Number

Author  Topic 

cjpsx
Starting Member

34 Posts

Posted - 2006-05-26 : 13:52:15
I need a page number in a header. BUT, I also need a field. When I try to do this I get the error that

"The value expression for the textbox ‘textbox15’ refers to a field. Fields cannot be used in page headers or footers."

Is there a way around this?

Thanks,
cj

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-06-02 : 13:56:05
That's a short coming of RS (not being able to use fields in headers or footers). You can get around this...

Add a textbox to the header. Set the value of the textbox =reportItems!textbox id that you're referencing.Value

The restriction is the textbox (containing the field) must be on every page you want the header to show on.
Go to Top of Page
   

- Advertisement -