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,
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
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!