• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

Creatiing alert to notify when totalpagenumber > 1 - this is urgent, please help!

Hi there.  I have a report that returns multiple customer records.  Sometimes the record may span 2 pages, mostly one.  I want to create an alert that tells me when it DOES span 2 pages however, I keep getting the message "one of the previous fields is not constant over group level of this field".
0
mwhalen061600
Asked:
mwhalen061600
1 Solution
 
mlmccCommented:
How are you calling the report?

mlmcc
0
 
frodomanCommented:
AFAIK there is no way to do this.

The problem is that alerts are usually triggered in the "BeforeReadingRecords" or "WhileReadingRecords" pass of the report engine but the number of pages isn't available until the "WhilePrintingRecords" pass (which is after the other two).  Alerts can't to the best of my knowledge be triggered during the print pass.



0
 
PWinterCommented:
Hi.

You can create a formula (evaluated "WhilePrintingRecords") that calls a user defined function if the page number > 1.
The user-defined function can fire up an alert.

Good Luck.
PW
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now