To Display the fields based on some selection criteria

Hi,

I have few fields to be displayed based on particular condition. i.e I have a field by name STATUS, which contains 5 different values
1.Closed 2.Assigned 3.New 4.Resolved & 5.Workinprogress.

My requirement is, I want to have 2 define fields in which I want to display only Closed & Resolved case_ID and the rest in the other field.

Can anyone suggest me on this....

Thanks & Regards
Ashok kumar M

Posts: 11 | Registered: April 18, 2006

Tewy

Platinum Member

posted

Hide Post

If I am understanding your question correctly, you just need to define your two fields thus:

FIELD1/I9 MISSING ON=
IF STATUS EQ 1 THEN CASE_ID ELSE
IF STATUS EQ 4 THEN CASE_ID ELSE MISSING;

FIELD2/I9 MISSING ON=
IF STATUS EQ 2 THEN CASE_ID ELSE
IF STATUS EQ 3 THEN CASE_ID ELSE
IF STATUS EQ 5 THEN CASE_ID ELSE MISSING;

You will have to change the format of your fields to whatever the format of CASE_ID is.

Regards

Tewy

WF 7.6.11
Output: HTML, PDF, Excel

Posts: 123 | Location: UK | Registered: October 09, 2003

Ignored post by Tewy posted

Show Post

Jim_at_LM

Gold member

posted

Hide Post

Not sure if this is what you need or want:

DEFINE FILE . . .
DEF_FLD1/I9 = IF STATUS EQ 1 OR 4 THEN CASE_ID ELSE 0 ;

DEF_FLD2/I9 = IF STATUS NE 1 OR 4 THEN CASE_ID ELSE 0 ;
END

TABLE FILE . . .
PRINT DEF_FLD1 AS ‘CLOSED/,RESOLVED’
DEF_FLD2 AS ‘ASSIGNED/,NEW/,IN PROGRESS’
:

Take care,
Jim

WebFOCUS 7.6.11, WINDOWS, HTML, PDF, EXCEL

Posts: 77 | Location: Baltimore | Registered: May 31, 2006

Ignored post by Jim_at_LM posted

Show Post

Ashok

Member

posted

Hide Post

Thanks a lot Tewy and Jim for all your timely support.

It seems to work fine now