TotalPages() in PLD

[Former Member]

In PLD, I want to compare Current Page with Total Pages and print something on the last page only. I get a message that TotalPages() can't work with other functions.

How can I do it?

[Former Member]

Hi Friends,

We will get total pages number in PLD as below steps.

1. To create field with Formula as (TotalPages())

Source Type:Formula

   ->then go to Formula Editor and select TotalPages().

Its working fine for me .

Thanks,

[Former Member]

use currentpage() / totalpage()

must place currentpage() , /, totalpage() in a separate freeText At footer

This is what i had done, and it worked perfect

[Former Member]

Hi Olga Simkin,

Dont compare the Current Page with Total Pages in Concat() Formula.

because some times will be get the error(xxxx) in print.

IF you need to compare the Current Page with Total Pages.

Try this,

->> Create 1 Formula field in Page Footer on require PLD.

Formula

CurrentPage()==TotalPages()

Current Page = 5, Total Pages = 5.

Result: in 5th Page(formula field in Page Footer) Print -> 1

Regards,

Madhan.

[Former Member]

In 2007A SP1 PL6 I got an error that TotalPages() can't be used with others.

As I remember it is worked in SP0.

Any ideas?

[Former Member]

TotalPages() could never be used within a formula. You may have remembered something for different use of it.

[Former Member]

If I can't use in Total Pages how can I calculate the last page?

[Former Member]

The last page calculated by PLD automatically in run time. However it not allow you to embed it to any formula.

[Former Member]

use currentpage() / totalpage()

must place currentpage() , /, totalpage() in a separate freeText At footer

[Former Member]

Hi Olga,

If I understand correctly, the reason why you need the TotalPages formula is because you would like to add a field which will print only on the last page, and not to show the current/total number of pages. If this is right, the following workaround can be used:

You could use the SystemString(ContinueNextPageNotice) formula, which prints 'Continued on next page' on each and every page, apart from the last. Therefore, you could add another formula to state that this previous field is empty: eg. if SystemString(ContinueNextPageNotice) is field F_100, then:

F_100==''

where '' are single quote marks, with nothing in between them.

This formula will print '1' only on the last page, and will be empty on the rest, which means you could use it to link fields to be printed on the last page only to it.

I hope this helps.

Regards,

Nat

[Former Member]

Hi,

Dont use Concat(TotalPages()), thats the meaning of your error the "can't work with other functions", Used the Formula TotalPages() as indenpendent Formula, you cant insert it to other functions.

Thank you,

regards,

Clint

[Former Member]

That is right. No TotalPages() could be used in any formula. PLD calculates this value at run time until the last page.

A simple solution: put the info on the End of Report area. That will ensure it is on the last page.

Thanks,

Gordon

[Former Member]

GetByKey("TMC_OFOC

what is the use of this code