SQL Server 2008 R2 Reporting Services export to word pages numbers always 1

nicecats
nicecats used Ask the Experts™
on
Hi All,

I'm having a perplexing problem with SQL Server 2008 R2 Reporting Services. I have a report with a page number in the footer which when rendered in PDF or on the screen it numbers correctly, however when rendered in Word or Excel the page numbers are all 1 regardless of what page it is. Does anyone know what we need to do to get the correct page numbers.

Any help in solving this would be appreciated.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If you are using PageNumber you could try OverallPageNumber, or the other way around. Maybe that helps.

Author

Commented:
Thanks Nicobo, you put me on the right track. I've solved it the problem is it looks like you cannot cast the page number to a string as here

="Page " +Globals!PageNumber.ToString()

Now i've used just = Globals!PageNumber and the numbers are coming up.

Thanks for the help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial