How to change the field background color in CR using HTML?

[Former Member]

Hello,

I have a cross-tab in the report. I need to change background color of the summary field based on the database field HEX value. For this I'm interpreting field as HTML. So I created the formula fields and trying to use HTML tags to format it. I can change the font color OK, like this:

<FONT COLOR="' & {Report_SELECT_TagLayouts.FontHex} & '">' & {Report_SELECT_TagLayouts.TagColorAbbreviation} & '</FONT>

But I cannot figure out how to change the background color. I have a database field for this - {Report_SELECT_TagLayouts.BackgroundColorHex}, but even if I just use regular HEX values it doesn't work. I've tried different tags - div, span etc. - no luck.

I would appreciate your suggestions.

[Former Member · Accepted solution]

Crystal only supports a limited number of HTML tags

https://apps.support.sap.com/sap/support/knowledge/public/en/1217084

[Former Member · Accepted solution]

Thank you. Yes, I'm using only these tags, nothing works. Cannot find anything that would change the background color. Font color is fine.