AZdesertdog
IS-IT--Management
CRXI and CEXI against MSSQL2k
I have created a report that runs nightly and in it is an alert if the total charges exceeds a certain amount. The alert condition is basically looking for a 'not isnull ({field})'. So if anything shows up it will fire. I have the Alert Notification set to email me a link of the report. I have nothing in the Notification section and the format is Crystal Report.
This all works. Each day I get an email with a very long url link if there is an excessive charge. The problem I'm having is if this email is check MORE than 1 day after it is delivered. I seems that when the link is used, it refreshes the report and if there was not alert on "yesterday", then it returns with blanks. I checked and the alerts actually exist as instances but for some reason an old url in the email want to run the report again (I think that's what it's doing). This problem usually mainifests itself after a weekend and I check alerts that were emailed on the weekend.
Is there any way to ensure an alert triggered URL in the email to point to the actual alert instance no matter when it is run?
Any suggestions appreciated!
I have created a report that runs nightly and in it is an alert if the total charges exceeds a certain amount. The alert condition is basically looking for a 'not isnull ({field})'. So if anything shows up it will fire. I have the Alert Notification set to email me a link of the report. I have nothing in the Notification section and the format is Crystal Report.
This all works. Each day I get an email with a very long url link if there is an excessive charge. The problem I'm having is if this email is check MORE than 1 day after it is delivered. I seems that when the link is used, it refreshes the report and if there was not alert on "yesterday", then it returns with blanks. I checked and the alerts actually exist as instances but for some reason an old url in the email want to run the report again (I think that's what it's doing). This problem usually mainifests itself after a weekend and I check alerts that were emailed on the weekend.
Is there any way to ensure an alert triggered URL in the email to point to the actual alert instance no matter when it is run?
Any suggestions appreciated!