help with display string 1

[saran26]

Hi All,

I have a field in table called testcaseverdict with values as pass , fail or nothing.

I want to display "NotExecuted" if there is no verdict and i used the following formula in the display string of the group field.

if (IsNull({ClearQuest.testcaseverdict}) or {ClearQuest.testcaseverdict} = "")then "Not Executed" else {ClearQuest.testcaseverdict}

It is not displaying any thing when the verdict is empty? Any is wrong in the above.

Please help me out.

Thanks

Saran

 

[lbass]

You can't format something that isn't there. Instead, create the same formula in the field explorer->formula editor and use it on the report instead of the field itself.

-LB

 

[saran26]

Thanks it worked well.

Saran