Focal Point
[CLOSED] how to JUSTIFY ACROSSCOLUMN

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

May 16, 2012, 05:00 AM
M A Sunil
[CLOSED] how to JUSTIFY ACROSSCOLUMN
I am not able to RIGHT JUSTIFY acrosscolumn.
Can anyone help me on this.

Here is my styling code.
ON TABLE SET STYLE *
INCLUDE=landscp,
RIGHTGAP=0.10,
LEFTGAP=0.04,
TOPGAP=0.20,
BOTTOMGAP=0.20,
SIZE=10,
$
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, $
TYPE=DATA, TOPGAP=0.05, BOTTOMGAP=0.10, JUSTIFY=RIGHT, SIZE=10, $
TYPE=DATA, COLUMN=P1, JUSTIFY=LEFT, $
TYPE=DATA, COLUMN=P2, JUSTIFY=LEFT, $
TYPE=DATA, ACROSSCOLUMN=N1, COLOR=RED, WHEN=CNT_YTD_TOT LT 0, $
TYPE=DATA, ACROSSCOLUMN=N1, STYLE=BOLD, WHEN=STYLE EQ 1, $
TYPE=ACROSSVALUE, JUSTIFY=CENTER, STYLE=BOLD, BACKCOLOR=&COLOR_THEME_RGB, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, TOPGAP=0.05, BOTTOMGAP=0.00, $
TYPE=SUBTOTAL, BACKCOLOR=&COLOR_THEME_RGB, COLOR=WHITE, $
TYPE=SUBTOTAL, ACROSSCOLUMN=N1, COLOR=RED, STYLE=BOLD, WHEN=CNT_YTD_TOT LT 0, $
ENDSTYLE

I used TYPE=DATA, ACROSSCOLUMN=N1, JUSTIFY=RIGHT, $
but it is not working.

This message has been edited. Last edited by: Kerry,


Webfocus 7.1.6
Windows
Excel, HTML, PDF,AHTML
May 16, 2012, 05:08 AM
Wep5622
Perhaps one of your conditional style rules overrides it?
If that's the case, you can probably do something like:
DEFINE FILE YADAYADA
DUMMY/I1 = 0;
END
TABLE FILE YADAYADA
...
TYPE=DATA, ACROSSCOLUMN=N1, JUSTIFY=RIGHT, WHEN=DUMMY EQ 0,$
...



WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
May 18, 2012, 12:07 PM
susannah
quote:
TYPE=ACROSSVALUE, JUSTIFY=CENTER, STYLE=BOLD, BACKCOLOR=&COLOR_THEME_RGB, BORDER-TOP=OFF, BORDER-BOTTOM=OFF,

you're already centered your data?




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID