Script to check if value has been exceeded and feed test to report

[KarenD]

Hi All, I want to check to see if a value has been exceeded and then have an alerts tab on a report. For example I want to check if the speed of 7000 rpm was exceeded. I then want on the alert tab of the report for it to say yes or no for verification the value was exceeded. I can find if it was exceeded fine but how do I translate that into a corresponding text statement for a report? Thanks in advance!

[ML927 · Accepted solution]

I think you just need to stock the warning in a text variable like this :

If valueMax < currentValue Then
  T1 = "This is a warning!"
Else
  T1 = "No warning"
End If

On your report just place a text box and write @@T1@@ inside. When refreshing the report you should see if the warning has been triggered or not.

Does it help ?

[KarenD]

Thank you very much! Exactly what I was looking for and so simple!