Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Display two columns from field that has multiple entires
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Display two columns from field that has multiple entires
 Login/Join
 
Member
posted
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>,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 13 | Registered: August 22, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Member
posted Hide Post
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.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 13 | Registered: August 22, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Try this ...

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


WebFocus 8.201M, Windows, App Studio
 
Posts: 225 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Display two columns from field that has multiple entires

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.