Hi,
I am trying to display the date(s) in the category field, for the interval of 10 days in line chart.
The reqirement is to display the dates in the interval of 10 days starting from "01/01/2013" to current date(irrespective of the dataset fields).
For this I am taking the category field as =Format(Fields!start_day.Value,"dd/MM/yyyy"), here the label's of x axis is displaying based on the dataset fiels "start_day"
I tried to display the dates based on the paramete passed
=Format(DateSerial(Year(Parameters!Year.Value),01,01),"dd/MM/yyyy")
and set the major grid interval property in x axis tab to 10
but the error message says parameter not valid
Could any one please provide the approach.
Thanks in advance.
Naveen