To display the x axis dates in the interval of 10 days in line chart

• ekknaveen

  SSCrazy

  Points: 2317

  More actions

  August 30, 2013 at 8:14 am

  #282572

  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