[SOLVED] How to wrap ACROSS value (work as column title)?
I am trying to wrap ACROSS value with the same old syntax by inserting ",", but it doesn't work.
TABLE FILE EXPENSES SUM AMOUNT AS '' ACROSS DEPT COLUMNS 'ABCD,EFGH' AND 'XXYY,ZZZZ' BY REGION END
The output just copies the comma, but doesn't wrap the dept value.
Any suggestion?This message has been edited. Last edited by: <Kathryn Henning>,
7.66 and 7.704 System: Windows / AIX / Linux Output: Mostly HTML, with some PDF, Excel and Lotus(!)
March 26, 2013, 03:04 PM
Kerry
Hi bug,
If this is still an issue, please contact Customer Support Services for assistance. The phone number is 1-800-736-6130, or access online at InfoResponse.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
March 26, 2013, 05:38 PM
susannah
the COLUMNS command isn't an AS phrase. the COLUMNS command refers to actual values in the DEPT field. Useful for changing the order of display... Do you have commas within the actual values in the DEPT fields?
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
March 26, 2013, 06:15 PM
Tony A
What output format?
If MS Excel then you could replace (use STRREP) with carraige control and/or line feeds (HEXBYT(13,'A1')||HEXBYT(10,'A1')). Also use stylesheet for that column to include WRAP=ON. If HTML then look at using the HTML tag <:br />
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
April 02, 2013, 01:41 PM
bug
Tony's solution works. I was trying to use Excel function but this seems better. Thanks.
7.66 and 7.704 System: Windows / AIX / Linux Output: Mostly HTML, with some PDF, Excel and Lotus(!)
