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