Hello Everyone, I am new to Reporting Services. What I am trying to do is create a chart that displays Hours 0 - 24 on the y-Axis and The Time from 00:00 - 23:59 on the x-Axis. Then i need to show some type of graph showing at what times during that day someone was doing an activity. Here is what my sql Data looks like. dataDate startTime endTime hours 2005-08-14 00:00:00.0000000 09:40:00.0000000 9 2005-08-14 10:14:00.0000000 11:21:00.0000000 1 2005-08-14 16:02:00.0000000 17:16:00.0000000 1 2005-08-14 21:01:00.0000000 23:59:00.0000000 2 So DataDate column would be the date I would be displaying Then I would need a line starting at 00:00 and ending at 09:40 peaking up to the 9hour mark on the y-axis Is this making any sense?

didn't get completely but based on some assumption In general Y axis is measure and X is Dimension. here it s other way around. Try this, Take the HH part out from your date and convert it into varchar and drop it on X axis Than take Min part as int and drop it on Y axis. See if it works for you. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

I am not sure if i understood. I also noticed my columns example was jumbled up. My Table has 4 Columns dataDate startTime endTime hours 2005-08-14 00:00:00 09:40:00 9 2005-08-14 10:14:00 11:21:00 1 2005-08-14 16:02:00 17:16:00 1 2005-08-14 21:01:00 23:59:00 2 So 8/14/2005 what be One full chart that would look something like this. 10 9 8 7 6 5 4 3 2 1 0 00:00 01:00 02:00 03:00 04:00 05:00 -----10:00 11:00 etc So the first row in my query should have a upside down V shaped line extending from 00:00 to 10:00 and go as high as 9 on the y -axis. then the next peak would start at 10:14 and end at 11:21. And like that for that whole day.

I am not sure if i understood. I also noticed my columns example was jumbled up. My Table has 4 Columns dataDate startTime endTime hours 2005-08-14 00:00:00 09:40:00 9 2005-08-14 10:14:00 11:21:00 1 2005-08-14 16:02:00 17:16:00 1 2005-08-14 21:01:00 23:59:00 2 So 8/14/2005 what be One full chart that would look something like this. 10 9 8 7 6 5 4 3 2 1 0 00:00 01:00 02:00 03:00 04:00 05:00 -----10:00 11:00 etc So the first row in my query should have a upside down V shaped line extending from 00:00 to 10:00 and go as high as 9 on the y -axis. then the next peak would start at 10:14 and end at 11:21. And like that for that whole day.

I am not sure if i understood. I also noticed my columns example was jumbled up. My Table has 4 Columns dataDate startTime endTime hours 2005-08-14 00:00:00 09:40:00 9 2005-08-14 10:14:00 11:21:00 1 2005-08-14 16:02:00 17:16:00 1 2005-08-14 21:01:00 23:59:00 2 So 8/14/2005 what be One full chart that would look something like this. 10 9 8 7 6 5 4 3 2 1 0 00:00 01:00 02:00 03:00 04:00 05:00 -----10:00 11:00 etc So the first row in my query should have a upside down V shaped line extending from 00:00 to 10:00 and go as high as 9 on the y -axis. then the next peak would start at 10:14 and end at 11:21. And like that for that whole day.

well suppose upside down V will be 00:00 to 40:00. and if this is the case than you need 3 rows for each of the rows you shown above dataDate startTime endTime hours ColumnGoingtoPlot 2005-08-14 00:00:00 09:40:00 9 0 2005-08-14 00:00:00 09:40:00 9 9 2005-08-14 00:00:00 09:40:00 9 0 you need to modify your query to get this result. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

well suppose upside down V will be 00:00 to 40:00. and if this is the case than you need 3 rows for each of the rows you shown above dataDate startTime endTime hours ColumnGoingtoPlot 2005-08-14 00:00:00 09:40:00 9 0 2005-08-14 00:00:00 09:40:00 9 9 2005-08-14 00:00:00 09:40:00 9 0 you need to modify your query to get this result. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

what kind of data would be in the last column?

what kind of data would be in the last column?

what kind of data would be in the last column?

Hi Stefbek97, Based on your requirement, I think Range Bar Chart could achieve this, in Narayana Swamy Palla's Blog , he give a detailed steps for creating such chart, please click the link to get a detailed reference. Thanks, Challen Fu