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)

Blue Wang on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

HI Ashokkumar Murugesan,

As mentioned in the previous reply, Global!pageNumber cannot be used in the body. You used it in code.

If you use the header and footer that everyone has always suggested, it is obviously possible. Of course, you need to decide whether you can accept such a demand change.

As mentioned earlier for manual calculation, you can try to add Group and use RowNumber and CountRows to achieve.

Please check this:robscode.onl/.../

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

Hi,

Agree with Nikolas, Why cant you use the page header for this requirement, It might not be a good idea to go out of the way to implement someting which easily can be fulfilled by adjusting the requirement, ofcourse if it is not 'must have' requirement.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

Seems you already did some web searches and found the discussion where a workaround is suggested: social.msdn.microsoft.com/.../page-number-amp-records-number

The workaround is the same than the expression that you shared in your previous message. So is it working or not?

Also why do you want to show it somewhere else than in header/footer? Perhaps you can discuss it with your customer, to decide together if it's worth the money to spend time looking for workarounds in a scenario that is not supported by SSRS.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

Hi Ashokkumar,

I can't understand why are you trying to put it to the body.

If you printing header part only on the first page, what is the point of page number here? If you print the header part on all pages, maybe you can just move to page header itself?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
RE: how to make a page number in body in ssrs report

Hi Sergei,

Thanks for your reply,

="Page " Code.PageNumber() " of " Code.TotalPages()

this is for expression

Public Function PageNumber() as String Dim str as String str = Report.Globals!PageNumber.ToString() Return str End Function Public Function TotalPages() as String Dim str as String str = Report.Globals!TotalPages.ToString() Return str End Function

this is for report property code

Thanks

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

Hi Ashokkumar,

Could you, please, share expression you have used for body section for pages?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: how to make a page number in body in ssrs report

Hi sukrut,

This is not help for body of the report, are any other solution there?

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: how to make a page number in body in ssrs 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
Community Member on at

Like (1)

Report

RE: how to make a page number in body in ssrs report

Thanks for your support

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

Like (0)

Report

RE: how to make a page number in body in ssrs report

hi,

Right click in the report design and select report properties.

Uday.

Was this reply helpful? Yes No