Display the current status of an application

[Roscoe307]

I need to display the current status of an application. I first need to look at numbers (AWD_DOC_NUM, SOL_DOC_NUM, REQ_DOC_NUM, PLAN_DOC_NUM) to see if there is a number populated in that field. If there is no number then the field automatically populates 'N/A'. So to begin I want to look at AWD_DOC_NUM and if there is a number in that field I want to display the AWD_STAT field. If 'N/A' is in the AWD_DOC_NUM field then I want to look at the SOL_DOC_NUM field and see if that field has a number. If so, I want to display the SOL_STAT field. If 'N/A' is in the SOL_DOC_NUM field then I want to look at the REQ_DOC_NUM field and see if that field has a number etc, etc.

I hope this isn't confusing.

Thanks in advance for the help!!

 

[dgillz]

If you look at these records in SQL query analyzer, can you see 'N/A' or do you see zero or null?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Roscoe307]

I see 'N/A'.

 

[dgillz]

Still unsure what you want. Is this one formula or several?

You can text for numeric text as follows:

If numerictext({AWD_DOC_NUM}) then {AWD_STAT} else.....

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Roscoe307]

I figured it out. Thanks anyways!