locked
Completely stuck from 2 days - SSRS X-axis Dates RRS feed

  • Question

  • User265788195 posted

    Hello, I have a graph and my x-axis show date & time. 

    The start date is 1/28/2014 9:20:00 PM -08:00 and end date is 1/29/2014 4:35:00 AM -08:00.

    In my Axis Options ->

    Selected Axis Type as Scalar(Numbers/Dates) 

    I have set Minimum as =CDate(Format(CDate(Last(Fields!Time.Value, "dsEventGraphReportData")),"M/d/yy HH:mm")) //  Should be 1/28/2014 9:20:00 PM -08:00 

    I have set Maximun as =CDate(Format(CDate(First(Fields!Time.Value, "dsEventGraphReportData")),"M/d/yy HH:mm")) //  Should be 1/29/2014 4:35:00 AM -08:00.

    Under Number -> Selected Date -> Custom -> M/d/yy HH:mm

    But the graph shows dates starting from 1/29/14 5:15 - 1/29/14 12:30.

    what am I doing wrong?

    Thursday, October 9, 2014 11:10 AM

Answers