Focal Point
[SOLVED] How to wrap ACROSS value (work as column title)?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1357083926

March 11, 2013, 10:33 AM
bug
[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(!)