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
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