Search code examples
reporting-servicesssrs-2008gridlines

SSRS - range bar chart highlight today gridline

I've created a range bar chart using SSRS 2008.

It is a date range

StartDate is =DateAdd("yyyy",-2,Today())

EndDate is =DateAdd("yyyy",2,Today())

What I want to achieve is, I want the grid-line for only Today()'s date.

Is there any way to achieve it? I don't know what expressions to give for Interval properties.

Thanks!! Any help is appreciated.

Solution

  • Use StripLine to achieve this. View the properties for the horizontal axis. Locate StripLines and click on collections. Add a member and set to the following:

    Set a Background Color (e.g. Green)

    BorderStyle (e.g. Solid)

    Interval: Auto

    IntervalOffset: =Today().ToOADate

    IntervalOffsetType: Days

    IntervalType: Years

    StripWidth: .5

    StripWidthType: Days