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,

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.

Vaayu - check out this post: http://forums.informationbuild...107082196#8107082196
I think you could leverage their function code to do what you want.

--Deb

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,

Thank you all! I know this will be great for HTML output but what about EXL and PDF?
Appreciate as always!