highlight row background if over 30 days
Hello. Have a ssrs report (table style) in which on column is a date. If the date is older than 30 days from today I would like to highlight the row in yellow. Not the info in yellow but the background. I suspect it is an IIF but not sure how to construct or where to place it. Thanks...John
July 2nd, 2011 4:56pm

Hi John, Please click on the column name and in the properties window, click the background color property and then select expression. In the expression dialogue box, paste the following expression =IIF(DateDiff("d",Fields!DateColumn.Value,Today())>30,"RED","YELLOW") Please replace DateColumn with your date field and colors of your choice. Hope this helps!
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 5:13pm

Thanks for the info. Did some tweaking with what you gave me, placed it in the row property background and it worked like they want it.... John
July 2nd, 2011 5:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics