<div>
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<br />
<br />
=&quot;Page &quot;&nbsp;+Globals!PageNumber.ToStri<wbr />ng()<br />
<br />
Now i've used just = Globals!PageNumber and the numbers are coming up.<br />
<br />
Thanks for the help
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
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.<br />
<br />
Any help in solving this would be appreciated.<br />
<br />
Thanks
</div>
</div>


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

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

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.