This discussion is archived
6 Replies Latest reply: Nov 29, 2012 9:13 AM by 733358 RSS

Highlight an Interactive Report cell based on another hidden cell

Shinnizle Journeyer
Currently Being Moderated
Greetings,

Does anyone know of a way to highlight a cell in an Interactive Report, based on the value of another cell in the same row, and without that cell being shown?

The IR built-in highlight feature doesn't seem to let me highlight a cell based on another cell's value (correct me if I'm wrong).

So I've tried going with a JavaScript solution I found in a thread somewhere on the APEX forums. I created a Dynamic Action with this JavsScript code:
$('[headers = "INTENSITE"]').each(function() {
  if ($(this).text() == 1) {
    $(this).siblings('[headers = "NOM_COMPLET_USAGER"]').css('background-color','red'); 
  }
});
and it works perfectly when the colum is shown, but not when it's hidden (which makes perfect sense).

So, that is where I'm stuck. The report has quite a lot of info, and I don't want to have an unneeded column being shown and using some valuable space.

Any help would be appreciated.

Thank you,
Mathieu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points