none
How Page Number handle in ssrs body of the report? RRS feed

All replies

  • Hi,

    Use this expression : Globals!PageNumber & "/" & Globals!TotalPages


    Ousama EL HOR

    [If a post helps to resolve your issue, please click the "Mark as Answer"  of that post or click Answered "Vote as helpful"  button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]


     [User Page]     [MSDN Page]     [Blog]     [Linkedin]

    • Proposed as answer by Mitarai Queen Wednesday, July 24, 2019 1:26 AM
    • Unproposed as answer by Mitarai Queen Wednesday, July 24, 2019 1:29 AM
    Tuesday, July 23, 2019 9:44 AM
  • Create a text box. For the value, enter the following:

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


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Mitarai Queen Wednesday, July 24, 2019 1:26 AM
    • Unproposed as answer by Mitarai Queen Wednesday, July 24, 2019 1:29 AM
    Tuesday, July 23, 2019 9:47 AM
  • Hi Dhana,

    1. Directly we can't insert page number in SSRS body, rather than we can do it in different way to solve the problem.

    We can use report variables like below approach

    https://stackoverflow.com/questions/4758793/access-page-number-in-report-body-in-ssrs


    Thanks

    Srinivasa Rao G, MCSE(Business Intelligence) Blog: TechTalksPro

    Please mark as answer if my post is helped to solve your problem
    and vote as helpful if it helped so that forum users can benefit

    • Proposed as answer by Mitarai Queen Wednesday, July 24, 2019 1:26 AM
    Tuesday, July 23, 2019 9:47 AM
  • Hi Dhana7

    In report footer you could try to use Ousama EL HOR and Uri Dimant ‘s suggestion .

    If you want to embedded the page in report body , you could try the tips that Srinivasa Rao Gude offered.

    Hope it can help you .

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Wednesday, July 24, 2019 1:32 AM
  • Hai Srinivasa ,

    Thanks for the answer.I handled variable Approach but in report body always zero and It is show correctly in header and footer.

    My requirement background image of the report It is show only even page. Any solution?

    Thanks

    Dhana

    Wednesday, July 24, 2019 12:30 PM
  • Hi

    If possible , could you please offer the detailed expected report preview to us to show how the pagenumber render in your report.

    Hoping for your reply.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Thursday, July 25, 2019 1:52 AM