Page numbering when exporting from SSRS

Aspose.Words Product Family
1

When I try to export a report to Word it doesn’t display the correct page numbers. all pages get page “Page 1 of 1”. In the Reporting Services interface it correctly says “Page 1 of 2” and it also works when I export to PDF. But exporting to Word fails…

This message was posted using Aspose.Live 2 Forum

2

The expression in SSRS is: Format(Globals!PageNumber) + " of " + Format(Globals!TotalPages)

3

Hi

Thanks for your request. Page numbers should be properly recognized. Could you please attach your output document, rdl report and rdl.data file here for testing?
Which version of Aspose.Words for Reporting Services do you use? To check version of the library, right click on the dll, select Properties from the context menu, then select Version tab. You will see File version.
Best regards,

4

The version is the latest downloaded from your website this morning; Version: 3.3.1.0 according to the DLL.
I am not really confortable placing the RDL, rdl.data and report on a public forum. Are there any parts I could send you via e-mail?
Kind Regards
Oscar

5

Hi

Thanks for your inquiry. It is safe to attach files in this forum. Only you and Aspose staff can download files attached in the forum. Also, you can send files to my e-mail as described here:
https://forum.aspose.com/t/aspose-words-faq/2711
Best regards,

6

Files sent…

7

Hi

Thank you for additional information. Please try to define page numbers as shown below:

<Paragraphs>
	<Paragraph>
		<TextRuns>
			<TextRun>
				<Value>="Page " & Globals!PageNumber & " of " & Globals!TotalPages</Value>
			</TextRun>
		</TextRuns>
	</Paragraph>
</Paragraphs>

Please let me know if this helps.
Best regards.

8

Now it works!
Thanks a lot!

9

We are using SSRS 2008 R2 and discovered that the page number string appears several times on a report page if we include the Globals!Totalpages value. We don’t have any problem if we just reference the Globals!PageNumber value.
It seems to appear just before each subreport. Is there a fix for this?

10

Hi Ken,
Could you please attach your rdl report and rdl.data file and output document here and we will take a closer look and provide a suggestion or solution.
Thanks,

11

We are using SSRS 2005. Where to write the code mentioned above?
Thanks and regards,
Abhishek

12

Hi Abhishek,

Thanks for your query. Are you talking about the code mentioned at this post? It would be great, if you please elaborate your query with some more detail.