Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

urgently needed! I need to make an alert if totalpages > 1

Status
Not open for further replies.

mwhalen

Programmer
Oct 31, 2000
217
CA
Please help - I have a deadline today and I have been struggling with this all weekend!!!!

I am returning multiple customers in the one report. Sometimes the customer record may spill onto 2 pages. I can get the total page count fine for that customer where it is 2. When I try to create an alert when totalpages is great than 1, I get a message "one of the previous fields is not constant over group level"

It doesn't matter if I use page number either.

So even when I try to create the alert on a created formula that contains the text "flag" based on the number I pages, I cannot see that formula "flag" in the editor available to me.

PLEASE HELP!
 
You have created multiple posts on this issue, and I believe you are not getting the help you need because you are not describing the problem clearly. Please tell us what steps you have taken to create the "Alert" (it is not obvious what you mean by this or what it's purpose is), and also show the contents of your formula that "contains the text 'flag'". What does "based on the number I pages" mean?

-LB
 
I am using Crystal 9.
1.Go to Menu/Report/Alerts/Create Alerts
2.New/Enter Name/Enter Message/Click Condition
3.The condition contents are as follows:

TotalPageCount > 1

when I use the formula checker I get that:
"one of the previous fields is not constant over group level"

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



 
I don't have CR 9.0, so wasn't aware of this alert feature. I have also never seen this message, but I wonder whether you have set the pagenumber to reset after a certain section, and whether this might affect the functioning of the alert. Just a guess. Someone with 9.0 might have to jump in.

If you explained what you want the alert to do, that would also help. Did you try my earlier suggestion in the other thread to create a formula in the formula editor:

if totalpagecount > 1 then "More than 1 page!"

This doesn't use the alert feature, but isn't this something like what you want, probably posted in the page header? It helps to give feedback on WHY suggestions don't meet your needs.

-LB
 
mwhalen

I've tested this out in V9 and it looks like the alert formulas can only use Group or record specific data as part of the condition.



Gary Parker
Systems Support Analyst
Manchester, England
 
Thank you Gary!!! Much appreciated! Is there a way I can re-work my page number perhaps in a group formula as a workaround so I can use the alert formula? Any thoughts?

 
can't think of a way, I tried a few workarounds using formulas and variables, but couldn't get it to work, Sorry


Gary Parker
Systems Support Analyst
Manchester, England
 
This workaround is'nt the best, but should work.

If you can work out how many records it takes to make 2 pages you can use the Count() function in your alert.

i.e. if you can fit 25 records on 1 page, then use Count({field}) >25 to trigger the alert.

Hope this helps...

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.
 
smart thinking Reebo [thumbsup2]

Gary Parker
Systems Support Analyst
Manchester, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top