V9 sc_field_style macro will not accept a variable as background colour parameter

The problem is discussed here for Version 8:

http://www.scriptcase.net/forum/forum/scriptcase-7/bugs/4268-sc_field_style-macro-does-not-accept-variable?_=1503956311878

BUT in v9 the suggested solution to use a global variable no longer works.

This is a pretty fundamental requirement for BI reporting (to colour code fields) based on some parameters and some colours defined by the user.

2 Likes

This is at least working again with global variables. It does not work with local variables still which is annoying.

Also it requires that the global variable must be presented within double quotes to function.

e.g. sc_field_style({field_to_format}, "[bgcolor_3]", "", "[color_3]", "", "[bold3]");
and not:
sc_field_style({problem_coded_pc}, [bgcolor_3], "", [color_3], "", [bold3]);

1 Like