Creating Gantt Chart in SSRS 2015 and Data Will Not Display

0
votes

I have the following result set giving me a specific status of an item . I need to build a SSRS 2015 Gantt chart to represent this data. I am having difficulty getting the data to display.

Result Set: StatusDate,Status,BegDate,EndDate, StatusDays

In the chart, I want the category to be on monthly intervals of the range provided (BegDate – EndDate) and the series to be each DAY in the range provided (BegDate – EndDate). The bars should represent the item being Up or Down with “Up” being Green and “Down” being black for each day (x-axis) of each month (y-axis).

Hoped for Results

The current preview shows the X & Y axis' correctly, but does not show any "bars" to represent the data.

This is my first chart using SSRS and I am quite lost. Does anyone know where I can get a true tutorial on Range Bar Charts for SSRS 2015 or how I might overcome this “data Display” challenge I am stuck on? I appreciate any direction / guidance offered.

1
visual-studioreporting-serviceschartsgantt-chart
You've posted 2 identical images, none of which offers much insight into your data unfortunately. Can you edit your question and add a sample of the data as it comes from your dataset. – Alan Schofield
@Alan Schofield - Thank you. I have added the result set as an imbedded pic. Am a bit of a Stack novice when posting so please be patient :) – JustPeachy
Just a bit more... Based on the sample data you posted, can you post your expected output. There doesn't seem to be a lot to build a gantt chart from to be honest, but I noticed in your design you are referencing fields that I don;t see in your sample data (statEnd, statStart). Anyway, make sure your example output ties up with your sample data so it's easier to understand. Do the expected output in anything, Excel ,Paint or whatever just so I can see the image. – Alan Schofield
@Alan Schofield - I updated the post but due to my Newbie limits, I had to remove one imbedded pic for another. Basically, I "mapped" out a Gantt chart. I hope this helps. – JustPeachy
Sorry @JustPeachy Had no time today, work busy. I'll follow up tomorrow hopefully. P.S. You in B.Hill? – Alan Schofield

1 Answers

0
votes

This issue was ultimately resolved by @AlanSchofield through another (and probably more clear) question, found here.

After choosing the correct chart, setting the correct properties, and determining the correct values I was able to get the chart I needed, but the behavior was still off. It would not show the a status more than once.

To fix this, and simply put, I needed to sort my data using Dense_Rank and then add the new "sort" column to my Series Group in the Chart properties. Worked like a charm!

Also got some useful guidelines on this blog post.