Overlapping existing series in Range Charts in SSRS

Question

Hi,

I have a Range Chart as shown below.

This Range Chart shows all the Release for an employee in a particular year. Along with the Releases, it shows the vacation time as well.

Requirement: The Requirement here is - Where ever there is Vacation, highlight the whole chart(as shown in red), so that we will see all the releases which are affected by employee's Time off.

Ex:When Employee took vacation in May, Release 2 was affected. When he took vacation in Septemeber, Release 2 and Release 3 were affected etc.

Is it possible to implement this requirement in Range Charts, if yes, how do we do this?

Thanks

---

NC

Answer 1

This article might help:

http://technet.microsoft.com/en-us/library/dd239316.aspx

---

Bonediggler

Answer 2

Hi,

Thanks for the reply.

My requirement is

Step 1: In the DataSet, get all rows where Title = "vacation"

Step 2: Create Striplines for each for these rows. (StripWidth = StartDate to EndDate)

Is it possible to loop through the DataSet and create the striplines for each of the vacation rows?

Thanks.

---

NC