Microsoft Dynamics AX (Archived)

Page Number in SSRS

(1) Share

Report

Posted on by AX 2012 r3

2,426

Good Morning,

I need Page numbers when page break.

Example Like

Page break is for every vendor

So.i am getting report page break for every vendor.

But here i am getting page no - 1/132

Complete report page numbers are coming.

Can i get like Vendor-1 is having 2 pages Page 1/2 and on second page page 2/2

again for next vendor-2 i need again Page 1/3.

Is it possible .

Please Guide.

Regards.

Have a great day.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Hi,

Now your using Global PageNumber to print page numbers? However the vendor data with tablix right? Then you can select repeat with property using tablix. if the page break happened the your text box of page number also will repeat with Tablix.

Thanks

Suresh

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi Suresh,

I am using This Expression to display page numbers

=Globals.PageNumber & " / " & Globals.TotalPages

So,

i tried using Repeat with Tablix

I am getting following Error

Please Guide.

Regards

Was this reply helpful? Yes No
Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Hi,

Take a look at this, it might help you achieve what you're trying to do here.

https://blogs.msdn.microsoft.com/robertbruckner/2010/04/25/report-design-reset-page-number-on-group/

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi Zain,

I saw That blog.

But there are some properties which we dont have in AX SSRS

Like

Reset Page Number Property.

Can we achieve this through data method.?

Please guide how can we achieve

Regards.

Have a great day Zain.

Was this reply helpful? Yes No
Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Hmm, You won't find an easy solution for it.

I think yes, you can use a data method to achieve this but I haven't tried it myself,

I will try this in a test machine whenever I can.

Meanwhile take a look at this,

https://blogs.msdn.microsoft.com/chrishays/2006/01/05/reset-page-number-on-group/

Let me know if this helps.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi Suresh,

My issue was not solved.

Regards.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

Hi,

If some one can advice how to achieve.

it would be helpful.

Regards

Was this reply helpful? Yes No
Verified answer

AX 2012 r3 2,426 on at

Like (0)

Report

Hi,

I have found one solution.This might help to some one

1.For Visual studio 2013 the property called Reset Page Number is not available

2.The property Reset Page Number is available in SQL Server DataTools For Visual Studio 2013

3. Open with Run as Administrator

4.Open any report Ex - CustListReport

5.In Design Add Group - AccountNum

6.Click on Bottom Row Group - Check for Group Property -> Expand Page Break -> here we go --> the property Page reset Number

7.Add Page Break From Properties for Group AccountNum

8.Only Check Between Each Instance

9.Deploy Report

8.Run through Ax

The Result is

here total pages are 32 but on right showing Page 1 of 1

Lets go for image 2

Here it is page 2 .But page is 1 of 1 because this new vendor is having only one page.

The version for This visual studio is

This Might help some one in future.

Regards.

Have a great day.

Was this reply helpful? Yes No