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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alert in report header

Status
Not open for further replies.

ShortyA

MIS
Feb 20, 2002
363
CH
Hi,
I am using CR9 against a SQL Server 7 database using ODBC to connect.

I have a count of {Field1} within Group{Field2}. When the count is over 1,000 an alert is triggered. However I would like the message to shown which group the alert has been triggered in. Currently I cannot use the Groupname({Field2} as it is evaluated later. So.. I tried to use the Field2 in part of the message but this just returns the last value in the report of Field2.

Has anyone setup the alert message so it shows which group the alert was triggered in ?

E.G.

Group : MidWest
500 cases

Group : Northern
1234 cases

Group : Southern
1500 cases

I would like the alert to be triggered twice (for Northern and Southern) and for the message to reflect this.

Thanks for any help that can be offered.

ShortyA
 
You could save the report as a unlinked subreport and then insert it in the report header. In the subreport, use a group selection formula (report->edit selection formulas->GROUP):

count({table.field},{table.group}) > 1000

Suppress all other fields of the report except the Name, and all other sections. Add a text message like: "Alert: the following regions exceeded 1000: "

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top