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.
| Author |
Topic |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-08-20 : 14:04:51
|
| I have created text boxes that combines Static Text with variables in the same text box before. An example of one I have working is:="Date Range - " + Parameters!StartDate.Value + " to " + Parameters!EndDate.Valueto display a selected start and end dae range.Unfortunately I cannot get the equivilent when trying to deal with page numbers. Is there a difference in how Parameters work versus Globals!PageNumber and Globals!TotalPages like:="Page " + Globals!PageNumber + " of " + Globals!TotalPagesIt only displays #Error |
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-08-20 : 14:17:35
|
| Try this="Page " + Cstr(Globals!PageNumber) + " of " + Cstr(Globals!TotalPages) |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-20 : 14:30:14
|
| Thanks. I am confused as to why the datetime stamp worked but the page didn't. That goes into my defaults docs for future reference... |
|
|
|
|
|
|
Displaying Page # of ## in footer