Is it possible to reference the value of a textbox in a report page header
or footer? I've tried to create a textbox in my report page footer, and make
it show the PageNumber. My textbox is called txtPageNum.
In my report body, I've created another textbox. I've tried to set this
textbox's value to =ReportItems!txtPageNum.value, but that didn't work out.
This is the error message:
"The value expression for the textbox 'textbox2' refers to the report item
'txtPageNum'. Report item expressions can only refer to other report items
within the same grouping scope or a containing grouping scope."
So, is it even possible to reference it, or should I just give up on the
whole idea?
Kaisa M. LindahlSorry, meant that to be a post. Yes, in theory you can reference a
textbox field from a Header or Footer. However, for page numbers, I'd
reference the Report Services global variables. There are two of them
that apply here.
For example:
="Page " & Globals.PageNumber & " of " & Globals.TotalPages
This will show "Page 1 of 2", etc.
MikeN|||Funny, as each time I try to use Globals!PageNumber in a text box in the
body, I get this error message:
The value expression for the textbox 'textbox20' refers to the global
variable PageNumber or TotalPages. These global variables can be used only
in the page header and page footer.
I'm very interested in how you suggest I can use the globals in the report
body section.
I'm also rather interested in how to reference a textbox field in the header
or footer, even if it's in theory. I've tried referencing it with
ReportItems!myTextBox.value, but no good. Suggestions on syntax are very
welcome.
Kaisa M. Lindahl
"MikeN" <mnorman07@.yahoo.com> wrote in message
news:1113574896.932765.202500@.o13g2000cwo.googlegroups.com...
> Sorry, meant that to be a post. Yes, in theory you can reference a
> textbox field from a Header or Footer. However, for page numbers, I'd
> reference the Report Services global variables. There are two of them
> that apply here.
> For example:
> ="Page " & Globals.PageNumber & " of " & Globals.TotalPages
> This will show "Page 1 of 2", etc.
> MikeN
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment