How to Show "Page x of y" in RDLC sales invoice report in Navsion 2013

(0) Share

Report

Posted on by Community Member

Hi,

While executing the report on document wise, based on the group, I would like to reset the Page Number : Page 1 of 3, Page 2 of 3, Page 3 of 3 etc. I am able to print Page 1 and reset based on the group, but I am unable to reset the Global!TotalPages. How could I achieve this.

Best Regards,

A. Durga Siva Krishna

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Hi Siva

Can you explain more where you want to reset the page number ?

As in report we can show Page X of Y

Was this reply helpful? Yes No
Suggested answer

Binesh 7,887 on at

Like (0)

Report
Copy link

Link copied!

Hello Siva,

You can do by little bit customization.

Open the Report Layout, In page no TextBox Write the following expression.

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

See the bellow screenshot for better understanding.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Salvi,

I want to reset the page number in Sales Invoice report (206). For brief see the below example

Ex :- In request page user run's the report as Doc-001..Doc-005, now the Doc-001 output is fitted to page 1 then Page Number should be Page : 1 of 1, if Doc-002 is having 3 pages output then Page Number should be Page : 1 of 3, Page : 2 of 3, Page : 3 of 3, and again if Doc-003 output is having page 1 then Page Number should be Page : 1 of 1.

Like this i need to reset the page numbers for every document.

As per the base report we already have custom code to reset Globals!Pageumbers, but my question is resetting of Globals!TotalPages.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,887 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You have to write the couple of code in Report Code.

See the bellow screenshot

TextBox Expression

Reference: Report 10153 Picking List by Order

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Binesh Singh Rajput,

Thanks for the reply.

According to the custom code the Globals!PageNumbers will be reset, but not the Globals!TotalPages, i want to reset Total Pages for each & every Order No.

Was this reply helpful? Yes No
Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Hi Siva,

This means user is going to print multiple invoices together Am I right ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yeah Salvi

Was this reply helpful? Yes No
Suggested answer

Binesh 7,887 on at

Like (1)

Report
Copy link

Link copied!

Hello, See this link
Report Design: Reset Page Number on Group

You have to set PageBreak properties for Group,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Binesh Singh Rajput,

The above provided screen shot will works in Navision 2013 R2, but my current version is Navision 2013.

Best Regards,

A. Durga Siva Krishna

Was this reply helpful? Yes No