Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] STYLESHEET USAGE
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] STYLESHEET USAGE
 Login/Join
 
Guru
posted
Hello,
We're trying to automate some column style using some RGB vals from a table. Wondering if theres a way to use either FUNCTION or Field value for BACKCOLOR property? Ideally we would pass a CAR value and get some STYLE from a function or a table in the below example. I didn't think it would work to start with but, figured I can always get your thoughts.

DEFINE FILE CAR
MAC1/A5 ='RED';
END
TABLE FILE CAR
PRINT SALES DEALER_COST
MAC1
BY COUNTRY
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = warm,
$
TYPE=DATA,
	COLUMN=N4,
	BACKCOLOR=customfunction(N1),
$
TYPE=DATA,
	COLUMN=N4,
	BACKCOLOR=BLUE,
	WHEN=N1 EQ 'FRANCE',
$
ENDSTYLE
END
  

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


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 291 | Location: Houston,TX | Registered: June 11, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Vaayu

I don't know of a way to reference a field value to show backcolor. You may need to create a HOLD file with the values and a -READFILE of the HOLD file to get them into a &variable that you can reference.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2113 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Vaayu - check out this post: http://forums.informationbuild...107082196#8107082196
I think you could leverage their function code to do what you want.

--Deb


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 185 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Member
posted Hide Post
quote:
DEFINE FILE CAR
MAC1/A5 ='RED';
END
TABLE FILE CAR
PRINT SALES DEALER_COST
MAC1
BY COUNTRY
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = warm,
$
TYPE=DATA,
COLUMN=N4,
BACKCOLOR=customfunction(N1),
$
TYPE=DATA,
COLUMN=N4,
BACKCOLOR=BLUE,
WHEN=N1 EQ 'FRANCE',
$
ENDSTYLE
END


It's not a function but you can also add style to the cells by using html/css

  

DEFINE FILE CAR
MAC1/A15 =IF COUNTRY EQ 'ENGLAND' THEN 'RED' ELSE IF COUNTRY EQ 'FRANCE' THEN 'BLUE' ELSE 'YELLOW';
NEW_DEALER_COST/A100 = '<TD style="background-color:'|MAC1|';">' | EDIT(DEALER_COST) | '</TD>';
END
TABLE FILE CAR
PRINT SALES DEALER_COST NEW_DEALER_COST
MAC1
BY COUNTRY
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = warm,
$
-*TYPE=DATA,
-*	COLUMN=N4,
-*-*	BACKCOLOR=customfunction(N1),
-*$
TYPE=DATA,
	COLUMN=N4,
	BACKCOLOR=BLUE,
	WHEN=N1 EQ 'FRANCE',
$
ENDSTYLE
END

This message has been edited. Last edited by: Enrique R,


WebFOCUS 8.2.05
 
Posts: 3 | Registered: May 31, 2016Reply With QuoteReport This Post
Guru
posted Hide Post
Thank you all! I know this will be great for HTML output but what about EXL and PDF?
Appreciate as always!


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 291 | Location: Houston,TX | Registered: June 11, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] STYLESHEET USAGE

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.