Color code text in SSRS

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 3, 2020 at 3:54 pm

  #3786045

  We have this: https://www.sqlservercentral.com/articles/dynamically-change-background-color-in-ssrs-reports-using-custom-code

   

  However, can I get an example of how to color code negative values as red, and maybe a value that is above some range, say 1000, as green?

• Thom A

  SSC Guru

  Points: 99143

  More actions

  September 3, 2020 at 4:20 pm

  #3786067

  Don't mind doing this, if no one else offers. Shouldn't take too long.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 3, 2020 at 4:38 pm

  #3786074

  Take it. Should be a short, easy one.

• Thom A

  SSC Guru

  Points: 99143

  More actions

  September 4, 2020 at 10:25 am

  #3786255

  Sent something across. Covered a couple of extra bits like font weight, and using T-SQL to adjust the conditional formatting too, which I find very handy.

  Cheers Steve!

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  September 4, 2020 at 2:49 pm

  #3786318

  Looks great, closing this.