Focal Point
[CLOSED] STYLESHEET USAGE

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

February 05, 2020, 12:24 PM
vaayu
[CLOSED] STYLESHEET USAGE
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
-********************
February 07, 2020, 05:06 PM
FP Mod Chuck
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
February 10, 2020, 09:05 AM
DWaybright
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
February 11, 2020, 10:15 AM
Enrique R
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
February 11, 2020, 10:27 AM
vaayu
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
-********************