urgent! How do I alert when a page number is more than 1

[mwhalen]

I have used the special function PageNumber. I want use an alert if it is the page number is more than 1, meaniing flag the user if their customer report spills over onto multiple pages. It doesn't seem to like my using the PageNumber function?

 

[pgtek]

Hi
Yes you can
instead of using page number
just select from the list page n of m
this will show how many pages there are.


cheers

pg


pgtek

 

[lbass]

Try a formula like:

if totalpagecount > 1 then "Report Exceeds One Page"

-LB

 

[mwhalen]

Even if I use Page n of m or totalpagecount, it still doesn't like it when I go to create the alert. It keeps telling me:
One of the previous fields is not constant over group level of this field

 

[lbass]

You need to share the formula you are using for the alert and explain where you are placing it.

-LB

 

[mwhalen]

I'm confused by what you mean share where I am placing the alert? You don't have to place it anywhere on the report.

The condition contents of my alert is as follows:

TotalPageCount > 1



and my total page count is a special function placed on my page header

Thanks.