Display one field or the other 1

[cjbrown815]

Hello, I have a manual Xtab report and I have two fields that need to be displayed based on the result of one of the fields. One field (SAMPLEPARAM.SRESULT) is either PASS or FAIL, if the result is FAIL then we want to see the comments in the other(SAMPLEPARAM.TRESULT) field and not display the first field.

Something like:

IF SAMPLEPARAM.SRESULT = "FAIL" then SAMPLEPARAM.TRESULT else SAMPLEPARAM.SRESULT

Thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[IanWaterman]

YOu have answered your own question, use a formula exactly as you have written it.

Ian

 

[cjbrown815]

Thanks, I'm getting better at this

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[dev1212]