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

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

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

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

It seems to work fine now

Regards,
Ashok Kumar M