Tuesday, 28 July 2020

SSRS graph axis label interval is not continuous. And SSRS date in graph x axis is not sorted

Hi Folks!
Do I love my job or Do I love my job...
I am so happy to be able to fix issues so quickly.

One of my colleague came to me with two issues in SSRS.

Issue 1 - SSRS graph axis label interval is not continuous
I,e they get the below type of graph



What is expected is below



To achieve this, you have to set 1 in Labels under properties.



And then the next issue was the dates were not  sorted.
Well...just type in below code and Bingo..issue is fixed

=Format(Fields!MyDateField,"dd/mm/yyyy")

Happy helping !!