SQLSearcher
asked on
SSRS Set a monthly Interval on chart
Hello Experts Exchange
I have a SSRS report where I select a date range and it give me a line chart of the sums for each day.
Here is the query I use to get the data.
I want to be able to set the Interval of the Chart Axis to the start of every month. Please take a look at my attached file.
At the moment the Chart Axis is a bit random I want it so that at the start of every month a new label is shown.
Is this possible to do in SSRS?
Regards
SQLSearcher
Monthly-Chart.jpg
I have a SSRS report where I select a date range and it give me a line chart of the sums for each day.
Here is the query I use to get the data.
Select dateadd(DAY,0, datediff(day,0, Date)) as Date,Sum([Total Lost Hours]) as Total_Lost_Hours
from [dbo].[MachineLosses_View]
Where date >= @StartDate AND date < @EndDate
Group by dateadd(DAY,0, datediff(day,0, Date))
order by dateadd(DAY,0, datediff(day,0, Date))
I want to be able to set the Interval of the Chart Axis to the start of every month. Please take a look at my attached file.
At the moment the Chart Axis is a bit random I want it so that at the start of every month a new label is shown.
Is this possible to do in SSRS?
Regards
SQLSearcher
Monthly-Chart.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help.
ASKER
I'm unable to download the rdl file can you zip it up for me please?
Regards
SQLSearcher