Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : GNpKsSuguOKkdC31aW+mDj
Finance | Project Operations, Human Resources, ...
Answered

Page number coming wrong after exporting to word

Like (0) ShareShare
ReportReport
Posted on 30 Aug 2023 08:50:40 by 118
Hello all,
 
We are facing one issue with SSRS reports when we export it to word.
Even if the report has more than one pages, it shows, 1 of 1 on all pages in word. However, it shows correct in the front-end report.
I have attached image here below,
 
//
 
My SSRS version is 15.0.1102.861.
 
Please suggest some solution to make this right.
 
Thanks,
Bhagyashree Dave
  • Bhagyashree Dave Profile Picture
    118 on 04 Sep 2023 at 08:14:19
    Page number coming wrong after exporting to word
    Thank you Girish,
     
    I used this expression and it worked.
    Globals!PageNumber & " of " & Globals!TotalPages
     
    But it is a bit weird that because of a label we were facing this issue.
     
    Thanks,
    Bhagyashree Dave
  • Verified answer
    GirishS Profile Picture
    27,823 Moderator on 04 Sep 2023 at 07:22:42
    Page number coming wrong after exporting to word
    Yes, this issue is available in the standard report itself.
    From my understanding the label used in the expression is causing the issue.
    Try the expression which is given by me in my previous post. This expression works for me, and it is showing correct page numbers.
     
    Thanks,
    Girish S.
  • Bhagyashree Dave Profile Picture
    118 on 04 Sep 2023 at 06:52:04
    Page number coming wrong after exporting to word
    Hi Girish,
     
    This thing with page number is happening in standard as well as custom reports for us.
     
    we are using below expression in custom reports,
    =Globals!PageNumber & space(1) & Labels!@SYS92595 & space(1) & Globals!TotalPages
     
    Is there any solution for this?

    Thanks, 
    Bhagyashree Dave
     
  • GirishS Profile Picture
    27,823 Moderator on 30 Aug 2023 at 10:31:07
    Page number coming wrong after exporting to word
    Hi Bhagya,
     
    I think the below expression for page number works when exporting it to word documents.
    "Page number" & ":" & Globals!PageNumber & " of " & Globals!TotalPages
    Seems you are talking about the standard report - So it must duplicate the report design and change accordingly.
     
    Thanks,
    Girish S.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete