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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trigger Message box
- Thread starter ahhuang
- Start date
I think you can use something called report alerts (i'm using crystal 8.5).
Report Alerts are custom messages created in Crystal Reports that appear when certain conditions are met by data in a report. Report Alerts may indicate action to be taken by the user or information about report data.
Report Alerts are created from formulas that evaluate conditions you specify. If the condition is true, the alert is triggered and its message is displayed. Messages can be text strings or formulas that combine text and report fields.
Once a Report Alert is triggered, it's not evaluated again until you refresh your report's data.
Because Report Alerts are specific to each report, you decide when to use them and when not to. They can be useful to point out important information, such as sales that fall above or below a limit. And the message is created by you, so it can be specific to your data.
I'm not quite sure how good they are i've never used them but it can't hurt to try. Click on Report -> create alerts
Transcend
![[gorgeous]](/data/assets/smilies/gorgeous.gif "[gorgeous] [gorgeous]")
Report Alerts are custom messages created in Crystal Reports that appear when certain conditions are met by data in a report. Report Alerts may indicate action to be taken by the user or information about report data.
Report Alerts are created from formulas that evaluate conditions you specify. If the condition is true, the alert is triggered and its message is displayed. Messages can be text strings or formulas that combine text and report fields.
Once a Report Alert is triggered, it's not evaluated again until you refresh your report's data.
Because Report Alerts are specific to each report, you decide when to use them and when not to. They can be useful to point out important information, such as sales that fall above or below a limit. And the message is created by you, so it can be specific to your data.
I'm not quite sure how good they are i've never used them but it can't hurt to try. Click on Report -> create alerts
Transcend
chelseatech
Instructor
I wrote a UFL that did this. It displayed a standard Windows message box.
I discovered a couple of interesting things when i developed this.
1) In the original version, if it was invoked lots of times by the report conditions, you had to say "OK" lots of times. So for that reason, I added a "Cancel" button to say ignore the rest of the messages.
2) I put a demo report on my CR8.0 Web Component Server and it killed it. It appears the Report generated the message box which really upset the service running the report. The machine had to be rebooted to become operational again.
Email me (bruce@chelseatech.co.nz) and I'll send it to you. I charge for my other UFL's and Crystal Utilities but this only has 3 lines of code. And most of that is to handle the Cancel button. Editor and Publisher of Crystal Clear
I discovered a couple of interesting things when i developed this.
1) In the original version, if it was invoked lots of times by the report conditions, you had to say "OK" lots of times. So for that reason, I added a "Cancel" button to say ignore the rest of the messages.
2) I put a demo report on my CR8.0 Web Component Server and it killed it. It appears the Report generated the message box which really upset the service running the report. The machine had to be rebooted to become operational again.
Email me (bruce@chelseatech.co.nz) and I'll send it to you. I charge for my other UFL's and Crystal Utilities but this only has 3 lines of code. And most of that is to handle the Cancel button. Editor and Publisher of Crystal Clear
chelseatech
Instructor
Alerts first appeared in Cr8.5 so they are not available with prior versions.
My UFL will work with any version that supports UFL's. Editor and Publisher of Crystal Clear
My UFL will work with any version that supports UFL's. Editor and Publisher of Crystal Clear
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question