I'm struggling to create a chart in SSRS (output from SQL Query) that will show how many project hours have been spent during a quarter. If the total number of hours crosses several quarters, each quarter should have the total number of hours spent during each quarter)
I understand that using DATEDIFF(hh, ProjectStartDate, ProjectFinishDate)as [Total Number of Hours] will give me the total number of hours of a project but I need to be able to split the output into Quarters
i.e. Q1 2014, Q2 2014, Q3 2014, Q4 2014, Q1 2015 etc.
Please see attached image to show what I am aiming for with the results.
Fields in SQL table: Project Name, ProjectStartDate, ProjectEndDate
Q1 2014 1,800 Hours
Q2 2014 1,992 Hours
Q3 2014 990 Hours
Q4 2014 800 Hours
Q1 2015 950 Hours
Many thanks in advance!