Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, August 30, 2013 8:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 10:09 AM
Points: 189, Visits: 333
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
Post #1490180
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse