December 20, 2006, 12:28 PM
Pam KrattI was wrong. Prairie's suggestion didn't work. It works in excel, but does not work in exl2k.
DEFINE FILE ABC
SP/A1 = HEXBYT(160, 'A1');
SP01/A1 = SP;
SP02/A2 = SP|SP;
EVENTNAME/A50=SP02|EVENTNME;
END
TABLE FILE ABC
SUM CNT.OUTPUT_TYPE AS 'TOTALCNT'
BY EVENTNAME
BY OUTPUT_TYPE
ON TABLE HOLD AS OUTFILE FORMAT EXL2K
END
I don't know if you can see the character or not, but it displays as a box in exl2k.
牋Change Detail Report
Any other suggestions?? Exl2k is supposed to be an improvement so we just converted all our applications over the summer to go to it.
December 20, 2006, 03:08 PM
PrarieDEFINE FILE CAR
SP/A1 = HEXBYT(160, 'A1');
SP01/A1 = SP;
SP05/A5 = SP|SP|SP|SP|SP;
EVENTNAME/A50=SP05|CAR;
END
TABLE FILE CAR
SUM CNT.SEATS AS 'TOTALCNT'
BY EVENTNAME
ON TABLE PCHOLD FORMAT EXL2K
END
This worked for me. Wonder if it's your version
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
December 20, 2006, 03:17 PM
Pam Krattthat did work on my desktop. I'll have to look into why it won't work on our server. Very interesting.
webfocus 8.105M; os: windows; pdf, html, exl2k, csv
December 20, 2006, 04:35 PM
Tony APam,
I tried this locally using Dev Studio (Win XP) server and our W2003 server. Worked as per Prarie on both.
T
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | | |
WebFOCUS App Studio 8.2.06 standalone on Windows 10 | |