Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

To display the x axis dates in the interval of 10 days in line chart Expand / Collapse
Posted Friday, August 30, 2013 8:14 AM


Group: General Forum Members
Last Login: Monday, March 14, 2016 9:29 PM
Points: 193, Visits: 343

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
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.
Post #1490180
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse