Page numbering: page x of y pages

(0) Share

Report

Posted on by Community Member

Hi everyone

I'm playing around with creating new reports at the moment and I read in the Microsoft training material that there is a way to use the DataMethod to not just get the page number on the page but the page x of y pages format as well.

Specifically it says "HINT: Another useful DataMethod on reports is the pages Total data method.
This returns the total number of pages in the report. This is useful to display the
page number as ‘Page’ of ‘Total Pages.’ For example, ‘3 of 10.’"

But what is the datamethod called? I can't find its name anywhere? If you can provide me the name and explain to me how I can find data methods in DAX, I would be very grateful! Thanks!

Yours

Abaw

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Girija Shankar Beuria 690 on at

Like (0)

Report

Hi,

You can use the SSRS expression to achive this. That should be easy. The expression would be like this :

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

msdn.microsoft.com/.../dd239335.aspx

- Girija

Was this reply helpful? Yes No