Help with StripLines in SSRS 2008
Hi I am unable to get a single StripLine to appear on my line charts. What I want to do is have a single vertical StripLine occur at a specific date from the dates on the Y-Axis. I have set the IntervalOffset to be the date I am looking for (either hard-coded as a test or even to be from a date column from one of my datasets), I set the StripWidth and played with numerous other properties. Nothing seems to work. I cannot get a single stripline to appear.Does anyone know if this feature works? And, if so, can someone help me overcome my madness?Thanks - willwill
March 5th, 2010 1:02am

Hi Anyone can help with this? maybe someone from microsoft that can actually get this feature to work?? thanks - willwill
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2010 9:16pm

I know this thread is pretty old, but I came across the exact same issue and this is the thread my search initially lead me. After a bit of reading I discovered when having an axis with DateTime you need to add an expression for your offset. To get this to work I did the following: Clicked on my X-Axis grid and clicked Striplines collection. After adding the stripline switch its BorderStyle to Solid and set your color. Add your Title as you would like to display and position it (top, bottom, etc) HERE IS THE TRICK -->> In the IntervalOffset set the expression to something like: =DateAdd(DateInterval.Hour, 5, Min(Fields!xtimestamp.Value)).ToOADate (In this case you have to add the ToOADate call to make it work). It seems so simple after you figure it out but it was a real pain to discover the trick which is what 50% of the coding seems with this type of tool. In any case I hope this is helpful for you or anyone else who happens to trip across this post. Shane
August 1st, 2011 11:55pm

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

Other recent topics Other recent topics