[SOLVED] LIGHTEST SHADE OF GREEN

November 07, 2019, 04:44 PM

I am trying to select a light green backcolor for a excel report. I'm using APP STUDIO to display alternating colors in every row, like this:

  
TYPE=DATA,
    FONT='IBIDEFAULT',
    SIZE=9,
    COLOR='BLACK',
    BACKCOLOR=( 'WHITE' 'LIME' ),
    STYLE=BOLD, 
$

Does anyone know of a lighter shade of green than the "electric looking" LIME ?

Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

November 07, 2019, 05:14 PM

Doug

TYPE=DATA,
    FONT='IBIDEFAULT',
    SIZE=9,
    COLOR='BLACK',
    BACKCOLOR=( RGB(210 255 220) 'WHITE' ),
    STYLE=BOLD, 
$

I like my first line to be a color instead of white.

November 08, 2019, 10:15 AM

David Briars

For 'light green' we use the Bootstrap 'Success' background color:

BACKCOLOR=( 'WHITE' RGB(#dff0d8) )

TABLE FILE GGSALES
"Bootstrap Light Green"
PRINT REGION DOLLARS
IF SEQ_NO LE 6
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=warm.sty, $
 TYPE = DATA, COLUMN = SEQ_NO, JUSTIFY=CENTER,$
 TYPE = DATA, BACKCOLOR=( 'WHITE' RGB(#dff0d8) ) , $
ENDSTYLE
END

This message has been edited. Last edited by: David Briars,

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

November 08, 2019, 10:54 AM

Tomsweb

So, I have this to display alternating colored rows in my report.

  
TYPE=DATA,
     COLUMN=N4,
     BACKCOLOR=('WHITE' 'GREEN'),
$

How do I code the COLOR tag TO ALTERNATE colors so if
BACKCOLOR='GREEN' the COLOR='WHITE',
AND if
if BACKCOLOR='WHITE' the COLOR='BLACK' ???

Thank you.

November 08, 2019, 11:09 AM

Tony A

Use conditional styling -

TABLE FILE GGSALES
SUM DOLLARS
    COMPUTE FLIPFLOP/I1 = ABS(LAST FLIPFLOP - 1); NOPRINT
 BY REGION
 BY ST
 BY STCD
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
grid=off, $
type=data, backcolor=white, color=green, when=FLIPFLOP EQ 0, $
type=data, backcolor=green, color=white, when=FLIPFLOP EQ 1, $
ENDSTYLE
END

November 08, 2019, 12:37 PM

David Briars

quote:
lighter shade of green

Now, if I could only get 'A Whiter Shade of Pale' out of my head it will be a good day. :-)

November 08, 2019, 12:58 PM

Tomsweb

”Lighter Shade” is one of my favorite early psychedelic songs. The organ is simply eerie!

November 08, 2019, 01:00 PM

Tomsweb

Thanks everyone for your help. Tony I love the flip-flop variable!

Focal point is so helpful and a tremendous resource for learning.

November 08, 2019, 03:45 PM

Doug

Tony: You never cease to amaze me with the FLIPFLOPping... I actually did that to simulate the good ol' Green Bar Paper, using a COUNTER from 1 to 6, reset bact to 1 when it's GT 6 (etc), and WHEN the COUNTER was LT 4 then LightGrren ELSE White (Pseudo Code Only).
Tom: There you have it, multiple thoughts

and some inspiration from Procol Harum,

OK, I'm getting carried away with this: Procol Harum - A Whiter Shade of Pale, live in Denmark 2006, The Original.

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

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