Hi all,

Is it possible to show 2 colours on an individual cell in a report?
The top level data should show heat map but if certain background data is missing I want to be able to show a secondary colour on that heat map cell to represent that the field is good but there is an issue behind it.

Many Thanks.

This message has been edited. Last edited by: Jon FB,

best way to achieve this is to build all logic in a computed field and use that for coloring.

e.g.
field is = turnover
computed = if turnover ge target then 'green' else if turnover le target then 'rood' else if turnover is missing then 'grey' else if target is missing then 'blue';

Hi Dave,

Thanks for the response.

The issue i think i'll have with using a computational field is that i am working with limited real estate to display the report. So there might not be enough room to achieve this solution.

I had though about using the size of the text in the heat map cells to represent issues which may work and provide visibility to issues in the background.

- Jon

...you should use NOPRINT for the compute so it's doesn't occupy you're precious real-estate.