Post reply

Hide and unhide an indicator based on time value.

  • November 14, 2015 at 12:48 pm

    #309574

    Hello,

    I am using SSRS 2008 & 2013 I want to hide an indicator and show it at different times of the day for example I want to show the color green between 6:00 am to 10:00 am, yellow at 10:01 am to 2:00 pm. and red at 2:01 pm to 6:00 pm. I know how to hide and unhide the indicators, but I don't know how to code by the hour and by morning and afternoon. Any tips will be appreciated. Thank you in advance.

  • November 14, 2015 at 5:16 pm

    #1839837

    Something like this should work:

    Value:

    =DateDiff(DateInterval.Hour,Today(),Now())

    Then you could just choose your ranges for red/yellow/green, as long as the ranges don't overlap and there's only one red/yellow/green value range per day.

  • November 15, 2015 at 10:22 am

    #1839848

    Thanks pietlinden, you save me. I appreciate your help. I will give this a try.

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

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