August 13, 2012 at 11:19 am
Good Afternoon Everyone.
i would like to seek help from anyone as i am new in using SSRS. my goal is to display an SLA chart by Service Level And By Ticket Volume. i have attached a sample report done in excel. my problem is i cannot display the months in the X axis as well as creating a line variance displayed in the Chart. i have also uploaded the sample data in excel as well for creating the report. would it be possible if you could guide me if i creating the regions for both the x and y axis for these reports? again many thanks for your continued support and assistance
Best Regards,
Noel
August 13, 2012 at 12:54 pm
Check this out, it might help.
http://sqlbg.wordpress.com/2010/03/18/creating-dual-y-axis-chart-in-ssrs-2008/
August 13, 2012 at 1:02 pm
Thank you Very Much Daniel i will be testing this on my own Database. by the way the Query that i created for the report is displayed below.
AS
BEGIN
SELECT convert(varchar(7), Submit_date, 126) As SubmitDate,
i.Summary,
i.Due_Date,
i.Completed_Date,
p.[Full_Name] as [Assignee],
MONTH(Submit_date) as MonthNumber,
Case when DATEDIFF(dd,Due_Date, Completed_Date) > 0 then 1
when DATEDIFF(dd,Due_Date, Completed_Date) < 0 then 0
Else '' End as MetSLA,
DateDiff(dd,Due_Date, Completed_Date) as [Ovedue By]
FROM Incidents i
Left Outer Join Persons p
on i.[Assignee_ID] = p.[ID]
where Year(Submit_Date) = @YearDate
--And Year(submit_date) = @YearDate
AND p.Full_Name IN ('Young, Ross', 'Kaur, Rajwinder','Hasham, Sameer','Rwankole, Paul', 'Chan, Randy','Nylen, Eric', 'Nguyen, Hieu', 'Kelter, Angela', 'Daniel, Ian', 'Atkins, Chris','Callaghan, Andrea', 'Giesbrecht, William', 'Bauman, Rob','Weniger, Tom','Sanders, Alphons')
AND DateDiff(dd,Completed_Date, Due_date) is NOT NUll
Group by MONTH(Submit_Date),summary,due_date,completed_date,Full_Name,Submit_Date.
should i display Months as "January,February,march etc..." instead of displaying it as 1,2,3 and then changing the axis properties for these?
August 13, 2012 at 1:33 pm
Hi,
i try to run the report and was able to display the months but in even order. (February, April, June, August, October, December). i am not sure why the other months are not displaying on the chart. can you tell me what i am doing wrong in this report?
much thanks
Noel
August 14, 2012 at 10:57 pm
I think that the chart is showing every other month because the default settings for the axis labels "Interval" property is "auto". Change this to 1 and you will see every month. This may cause the labels to be offset or rotated by 45 or 90 degrees so that the month name fits. You may need to adjust other properties to get a layout of the month labels that you like
August 20, 2012 at 11:08 am
Much Thanks Sir. It Did Work For Me!!! 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply