Alert in report header

[ShortyA]

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

 

[lbass]

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

 

[ShortyA]

LB,
thanks for that - worked a treat!

ShortyA