[SOLVED] Color Coding for Column Total

Try this:

.
.
ON TABLE SET STYLE *
 TYPE=GRANDTOTAL, BACKCOLOR=GREEN,  WHEN=Color EQ 0, $
 TYPE=GRANDTOTAL, BACKCOLOR=RED,    WHEN=Color EQ 3, $
 TYPE=GRANDTOTAL, BACKCOLOR=YELLOW, WHEN=Color EQ -1, $
 etc.
ENDSTYLE
.
.

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Silver Member

posted

thanks Dan for replying, but for some strange reason this is not working. I forgot to mention in my prevoius post that Dept1 Dept2... is an across field. Is this the reason for the code not working. Is there a work around i need to do for the across field

769 Excel,PDF and HTML

Posts: 35 | Location: Bangalore | Registered: March 27, 2008

Ignored post by Shru posted

Tony A

Expert

posted

You say that Color is a calculated field so how are you achieving the layout that you imply? Are you using FML, it could make the difference in how you would attempt this.

Although generally with ACROSS value summarisation you would do something like -

ON TABLE SET STYLE *
 TYPE=GRANDTOTAL(*), BACKCOLOR=GREEN,  WHEN=Color EQ 0, $
 TYPE=GRANDTOTAL(*), BACKCOLOR=RED,    WHEN=Color EQ 3, $
 TYPE=GRANDTOTAL(*), BACKCOLOR=YELLOW, WHEN=Color EQ -1, $
 etc.
ENDSTYLE

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

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Silver Member

posted

hi Tony,

I am calculating the Color field separately and then doing a more with the rest of the report.

I tried your method also but i am still unable to achieve the required results.

769 Excel,PDF and HTML

Posts: 35 | Location: Bangalore | Registered: March 27, 2008

Ignored post by Shru posted

Silver Member

posted

Also i noticed that when i give the condition1 the report works fine. As soon as i give the condition 2 it takes by default condition 2

condition1

 TYPE= GRANDTOTAL,
BACKCOLOR='GREEN',
COLUMN=N2,
WHEN=E01 EQ 'ZCOLOR',
$

condition 2
TYPE= GRANDTOTAL,
-*MACRO=COND0002,
BACKCOLOR='RED',
COLUMN=N2,
WHEN=E01 EQ 'ZCOLOR',

$

I also want to know if i can give 2 when conditions for one column.

For example i want

  TYPE=GRANDTOTAL,
BACKCOLOR='GREEN',
COLUMN=N2,
WHEN = E01 EQ 'COLOR',
WHEN = E02 EQ 0
$

769 Excel,PDF and HTML

Posts: 35 | Location: Bangalore | Registered: March 27, 2008

Ignored post by Shru posted

Kerry

Expert

posted

Hi Shru,

I consulted with our internals and was suggested that it is better that you open a case with Customer Support Services for additional assistance. To open a case, you may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Kerry Zhan
Focal Point Moderator
Information Builders, Inc.

Posts: 1948 | Location: New York | Registered: November 16, 2004

Ignored post by Kerry posted

Senthilvasan S

Member

posted

Shru,

Create a flag field in the define with the
DEFINE FILE
FLAG1/I2 = IF CODITION! OR CONDITION2 THEN 0 ELSE
-IF CONDITION1 OR CONDITION3 THEN 1 ELSE 2;
END

-----STULE ------

condition1

TYPE= GRANDTOTAL,
BACKCOLOR='GREEN',
COLUMN=N2,
WHEN=FLAG1 EQ 0,
$

condition 2
TYPE= GRANDTOTAL,
-*MACRO=COND0002,
BACKCOLOR='RED',
COLUMN=N2,
WHEN=FLAG1 EQ 1,
$

condition 3
TYPE= GRANDTOTAL,
-*MACRO=COND0002,
BACKCOLOR='BLUE',
COLUMN=N2,
WHEN=FLAG1 EQ 2,
$

-------STYLE -------

WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL

Posts: 24 | Registered: April 24, 2009

Ignored post by Senthilvasan S posted

Silver Member

posted

Thanks everyone for the reply.

I used SET command to resolve the issue. I read all the data into a variable and then used

 -SET &COL1 = IF &VAR1 EQ 0 THEN 'BACKCOLOR=GREEN' ELSE IF &VAR1 LT 0 THEN 'BACKCOLOR=YELLOW' ELSE 'BACKCOLOR=RED;

Then in the styling I used

 TYPE= SUBFOOT,OBJECT=FIELD,ITEM=1,COLSPAN=1,&COL1,$

769 Excel,PDF and HTML

Posts: 35 | Location: Bangalore | Registered: March 27, 2008

Ignored post by Shru posted