Post reply

Change row colour based on dates

  • March 2, 2010 at 2:02 am

    #219555

    Hello

    I've got a SSRS table as below:

    http://i47.tinypic.com/rqvssl.jpg

    What I'd like to do is base the colour of the rows based on the Date/Time. For example all rows with the Date/Time of 3/1/2010 2:46:27 PM have a red background, rows with Date/Time of 3/1/2010 2:46:27 PM have a blue background etc.

    The data will be completely dynamic so I don't think it can be hard-coded per se.

  • March 2, 2010 at 5:20 am

    #1126982

    I'm not able to view the url you have posted but I think if it is a table then you can change the background color property of the row by using expression like

    =IIF(Fields!SomeDate="3/1/2010 142:46:27","Red","Blue")

    --Ramesh

  • March 5, 2010 at 10:56 am

    #1129327

    Hi,

    If u dnt want to hard like above add one date/Time feild in the iif expression..

    Thanks

    Veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply