Link to home
Start Free TrialLog in
Avatar of SQLSearcher
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.

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))

Open in new window



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
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SQLSearcher
SQLSearcher

ASKER

Hello Nicobo
I'm unable to download the rdl file can you zip it up for me please?

Regards

SQLSearcher
Thank you for your help.