Finance | Project Operations, Human Resources, ...

how to make a page number in body in ssrs report

(0) Share

Report

Posted on by Community Member

Hi ,

I need to set page number in body of the ssrs design, how to do that

I need page number like mentioned in header('current page number' of 'totalpage number')

anyone give some idea.

Thanks.

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Did you try using fields from built in fields section from the designer ? take a look at fields pageNumber and OverallPageNumber.

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi Ashok,

You can use the below expression:

= "Page " & Globals!PageNumber & "of" & Globals!TotalPages

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI Ashokkumar Murugesan,

Global!pageNumber cannot be used outside the header and footer.

If you change the requirement to use in the header and footer, it is very simple.

Besides that, You need to calculate by other methods, such as the height of the report, the width of the cell, and the limited number of rows displayed on each page,etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi blue,

Is any possible to access the textbox in design from Dp class.

If it is possible I will achieve my requirement.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sukrit,

Is any other possible solution there for that, from x++

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi

By default, it is not possible to bring the page number in the body using built in functions. DP Class cannot help us here.

You can try as this article says,

stackoverflow.com/.../how-to-display-page-number-in-report-body-of-ssrs-2008-r2

(I haven't tried).

Uday

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi udhaya,

Thanks for this, where will i write code for this,

In Your mentioned document is says like report-->reportproperty-->code,

give some idea for it, Write code for where

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

hi,

Right click in the report design and select report properties.

Uday.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thanks for your support

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Udaya,

I have tried this but this only for show not working properly,

Are any other solutions are there?

Thanks.

Was this reply helpful? Yes No