I am trying to save space and was wondering if there is a way to concatenate two fields in one xBrowse Column. I have two dates .. startdate and enddate and would like to show them both in one column, one under the other as in the photo shopped screen below .. notice the Start End column, first row.
I have tried this code but it does not work ..
Code: Select all
// ad run in these publications
REDEFINE xBROWSE oLbxC ;
RECORDSET oRsAdvtBill ;
COLUMNS "PUBLICATIONNAME", ;
"STARTDATE"+CRLF+"ENDINGDATE", ;
"WEEK1", ;
"WEEK2", ;
"WEEK3", ;
"WEEK4", ;
"WEEK5", ;
"ACCOUNTEXECUTIVE", ;
"TOTALBILLED" ;
COLSIZES 57,70,26,26,26,26,26,50,75 ;
HEADERS "Publication", ;
"Start End", ;
"W1", ;
"W2", ;
"W3", ;
"W4", ;
"W5", ;
"AcctEx", ;
"Total Bill" ;
ID 273 of oFld:aDialogs[1] ;
AUTOCOLS LINES CELL
oLbxC:nMarqueeStyle := MARQSTYLE_HIGHLROW
oLbxC:lRecordSelector := .f.
oLbxC:lHScroll := .f. // turn off horiz scroll bar
oLbxC:nRowHeight := 47
Rick Lipkin