CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
Bruce
Bruce

Reputation: 21

SSRS Tablix Group Reset Page Number and Page Name not working when Exported to Word

I have a SSRS (.rdl) report with a tablix whose details group is set to put a page break between group items, reset the page number and set the page name (as per http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx).

This works correctly when rendered to HTML or as a PDF.

When rendered to Word the page numbers do not reset and the page name never changes (the page name is always the value set on the first page). The page breaks work as expected.

I have read (at https://msdn.microsoft.com/en-us/library/dd283105.aspx#ReportHeadersFooters) that complex expressions must be converted into runs of simple expressions in order to display correctly when exporting to Word. I have done this but the problem persists.

Is there any way to make the tablix group reset page number and page name functionality work when exporting to Word?

If not is there a way of achieving the same effect when exporting a report to Word from SSRS?

Upvotes: 2

Views: 2375

Answers (1)

d_ethier
d_ethier

Reputation: 3911

This is an older question but recently ran into this issue myself so it might help someone else.

There are a lot of examples out there that use casting in the examples for the page number display (CStr or ToString()). Whenever I invoked those methods, the counts would be off when exporting to Word (either doc or docx).

The only way I could get it to work is with three separate text boxes in the footer with these expressions:

=Globals!PageNumber
"of"
=Globals!TotalPages

Avoid the use of those other approaches. Three separate text boxes was the only way I could get this to work.

Upvotes: 1

Related Questions