Hi, I am trying create a report that displays Description and Resolution information around request tickets. The field I need to display is LDTEXT. The problem is that LDTEXT holds information for both Resolution and Description. This is determined by LDOWNERCOL. I.e., if LDOWNERCOL = DESCRIPTION then LDTEXT will display description information. If LDOWNERCOL = FR2CODE then LDTEXT will display resolution information. This generates two rows for the same ticket. One row has resolution info and the next row has Description information. My question is how do I get LDTEXT to be displayed into two different columns. I tried defining a new field but that didn't work. Any suggestions would be greatly appreciated.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

DEFINE FILE XXXX
DESC_INFO /A100 = IF LDOWNERCOL EQ 'DESCRIPTION' THEN LDTEXT ELSE '';
RESOL_INFO/A100 = IF LDOWNERCOL EQ 'FR2CODE' THEN LDTEXT ELSE '';
END
TABLE FILE XXXX
SUM DESC_INFO
RESOL_INFO
BY request_ticket
END

Thanks, This got me a little further but it appears that the Resolution field is not changing. The Resolution appears to be repeating. I.e. the first 5 records show the same resolution even though that is not the resolution related to the ticket id.

Try this ...

TABLE FILE XXXX
SUM
MAX.DESC_INFO
MAX.RESOL_INFO
BY REQUEST_TICKET
END