| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
April 11, 2008, 11:33 AM
GinnyJakesJenny,
If I understand you correctly, you can create a dummy sort field whose value is 1 for every other country and 2 for the others. Then you can do ACROSS DUMMYSORT followed by ACROSS COUNTRY as Prarie said.
Hope that helps.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
April 11, 2008, 01:22 PM
JennyMI will try that and see how it goes. Thanks all!
Jen
WF7.1.4
Win/nt/win2003
HTML/PDF/Excel2000
April 11, 2008, 02:17 PM
Francis MarianiI'm not sure if the double ACROSS technique will work, the values of COUNTRY are unique, so I don't think they'll be split two per row.
If your output is PDF, using Labels styling might do the job.
Here's an example:
TABLE FILE CAR
SUM
LENGTH WIDTH HEIGHT
-*WEIGHT WHEELBASE FUEL_CAP
-*BHP RPM MPG ACCEL
COMPUTE WIDTHFLAG/A1 =
IF WIDTH LT 258 THEN '1' ELSE
IF WIDTH FROM 259 TO 399 THEN '2' ELSE '3'; NOPRINT
COMPUTE WBFLAG/A1 =
IF WIDTH FROM 0 TO 200 THEN '1' ELSE
IF WIDTH FROM 201 TO 300 THEN '2' ELSE
IF WIDTH FROM 301 TO 400 THEN '3' ELSE
IF WIDTH FROM 501 TO 500 THEN '3' ELSE '4'; NOPRINT
BY COUNTRY PAGE-BREAK
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
UNITS=IN, PAGESIZE=LEGAL, ORIENTATION=LANDSCAPE,
LEFTMARGIN=0.25, TOPMARGIN=0.25,
PAGEMATRIX=(2 5), ELEMENT=(4 2.1), GUTTER=(0.5 0),
MATRIXORDER=HORIZONTAL, LABELPROMPT=OFF, $
BORDER=1, BORDER-COLOR=SILVER, FONT='ARIAL', SIZE=8, $
TYPE=TITLE, STYLE=BOLD, $
TYPE=DATA, COLOR=WHITE, $
TYPE=DATA, COLUMN=COUNTRY, COLOR=BLACK, $
TYPE=DATA, COLUMN=LENGTH, BACKCOLOR=RED, WHEN=LENGTH LT 600, $
TYPE=DATA, COLUMN=LENGTH, BACKCOLOR=GREEN, WHEN=LENGTH GE 600, $
TYPE=DATA, COLUMN=WIDTH, BACKCOLOR=LIME, WHEN=WIDTHFLAG EQ '1', $
TYPE=DATA, COLUMN=WIDTH, BACKCOLOR=CYAN , WHEN=WIDTHFLAG EQ '2', $
TYPE=DATA, COLUMN=WIDTH, BACKCOLOR=GREEN, WHEN=WIDTHFLAG EQ '3', $
TYPE=DATA, COLUMN=HEIGHT, BACKCOLOR='MIDNIGHT BLUE', WHEN=HEIGHT LT 70, $
TYPE=DATA, COLUMN=HEIGHT, BACKCOLOR=GREEN, WHEN=HEIGHT GE 70, $
TYPE=DATA, COLUMN=WEIGHT, BACKCOLOR=PINK, WHEN=WEIGHT LT 5000, $
TYPE=DATA, COLUMN=WEIGHT, BACKCOLOR=GREEN, WHEN=WEIGHT GE 5000, $
TYPE=DATA, COLUMN=WHEELBASE, BACKCOLOR='CADET BLUE', WHEN=WBFLAG EQ '1', $
TYPE=DATA, COLUMN=WHEELBASE, BACKCOLOR=GOLDENROD, WHEN=WBFLAG EQ '2', $
TYPE=DATA, COLUMN=WHEELBASE, BACKCOLOR=TURQUOISE, WHEN=WBFLAG EQ '3', $
TYPE=DATA, COLUMN=WHEELBASE, BACKCOLOR=MAGENTA, WHEN=WBFLAG EQ '4', $
TYPE=DATA, COLUMN=FUEL_CAP, BACKCOLOR='MEDIUM SLATE BLUE', WHEN=FUEL_CAP LT 30, $
TYPE=DATA, COLUMN=FUEL_CAP, BACKCOLOR=ORANGE, WHEN=FUEL_CAP GE 31, $
TYPE=DATA, COLUMN=BHP, BACKCOLOR=BLUE, WHEN=BHP LT 300, $
TYPE=DATA, COLUMN=BHP, BACKCOLOR=GREEN, WHEN=BHP GE 301, $
TYPE=DATA, COLUMN=RPM, BACKCOLOR=KHAKI, WHEN=RPM LE 5000, $
TYPE=DATA, COLUMN=RPM, BACKCOLOR=MAROON, WHEN=RPM GT 5000, $
TYPE=DATA, COLUMN=MPG, BACKCOLOR=RED, WHEN=MPG LT 60, $
TYPE=DATA, COLUMN=MPG, BACKCOLOR=GOLD, WHEN=MPG GE 60, $
TYPE=DATA, COLUMN=ACCEL, BACKCOLOR=PURPLE, WHEN=ACCEL LT 20, $
TYPE=DATA, COLUMN=ACCEL, BACKCOLOR=GREEN, WHEN=ACCEL GE 20, $
ENDSTYLE
END
On my lowly WF 5.3.2 server I get this message:
(FOC3228) STYLED REPORTS CURRENTLY LIMITED TO 128 COLUMNS
so I can't specify all the fields in the row...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 01, 2008, 05:16 PM
JennyMFrancis, the double across technique did not work. I had to do some rigging around. but my problem at this point is that the very first column will not do the conditioning styling. Anybody have any bright ideas? Our go live day was today and well we are not ready for this report.
DEFINE FILE ALLPAGES
ACROSS_KEY/I5 = LIST;
END
TABLE FILE ALLPAGES
PRINT
PAGECOLOR AS '' OVER
PRFSTATUS AS '' OVER
PARTREC AS ''
PGSREC AS ''
PRFOUT AS ''
PRFBACK AS ''
BY FORM_SIDE AS ''
BY ACROSS_KEY AS ''
BY PGIMP# AS ''
ON TABLE HOLD AS ALLPAGE FORMAT ALPHA
END
-RUN
?FF ALLPAGE
-*
TABLE FILE ALLPAGE
SUM
PAGECOLOR AS '' OVER
PRFSTATUS AS '' OVER
PARTREC AS ''
PGSREC NOPRINT
PRFOUT NOPRINT
PRFBACK NOPRINT
BY FORM_SIDE AS ''
ACROSS ACROSS_KEY NOPRINT
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N5 EQ 'Y',
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N6 EQ 'Y',
$
DEFMACRO=COND0003,
MACTYPE=RULE,
WHEN=N7 EQ 'Y',
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP-COLOR='BLUE',
BORDER-LEFT-COLOR='BLUE',
BORDER-RIGHT-COLOR='BLUE',
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP-COLOR='BLUE',
BORDER-LEFT-COLOR='BLUE',
BORDER-RIGHT-COLOR='BLUE',
BACKCOLOR=RGB(255 255 153),
MACRO=COND0001,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP-COLOR='BLUE',
BORDER-LEFT-COLOR='BLUE',
BORDER-RIGHT-COLOR='BLUE',
BACKCOLOR=RGB(204 255 204),
MACRO=COND0002,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP-COLOR='BLUE',
BORDER-LEFT-COLOR='BLUE',
BORDER-RIGHT-COLOR='BLUE',
BACKCOLOR=RGB(255 217 236),
MACRO=COND0003,
$
TYPE=DATA,
ACROSSCOLUMN=N2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
$
TYPE=DATA,
ACROSSCOLUMN=N2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(255 255 153),
MACRO=COND0001,
$
TYPE=DATA,
ACROSSCOLUMN=N2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(204 255 204),
MACRO=COND0002,
$
TYPE=DATA,
ACROSSCOLUMN=N2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(255 217 236),
MACRO=COND0003,
$
TYPE=DATA,
ACROSSCOLUMN=N3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
$
TYPE=DATA,
ACROSSCOLUMN=N3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(255 255 153),
MACRO=COND0001,
$
TYPE=DATA,
ACROSSCOLUMN=N3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(204 255 204),
MACRO=COND0002,
$
TYPE=DATA,
ACROSSCOLUMN=N3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-COLOR='BLUE',
BACKCOLOR=RGB(255 217 236),
MACRO=COND0003,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=8.000000,
$
ENDSTYLE
END
Jen
WF7.1.4
Win/nt/win2003
HTML/PDF/Excel2000