SSRS Expressions background color

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  May 11, 2016 at 1:25 am

  #307544

  Hi Experts

  I have a column 'LastFullBackup' that i want to set background color if

  Last full backupdate within last 7 days = Colour green, if not colour red

  Thank you

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  May 11, 2016 at 9:44 am

  #1878293

  This blog covers conditional formatting, its pretty simple

  https://blogs.msdn.microsoft.com/davidlean/2009/02/16/sql-reporting-how-to-conditional-color-14-the-basics-report-expressions-custom-code/

  for example in:

  =iif( Fields!myField.Value < 0, “Red”, “Black”)

  MCITP SQL 2005, MCSA SQL 2012

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  May 11, 2016 at 12:59 pm

  #1878368

  Thanks Taylor i will try that.