Range Chart X-Axis DateTime Format

• waxb18

  Ten Centuries

  Points: 1060

  More actions

  November 16, 2015 at 10:46 am

  #302308

  Afternoon Ladies and Gents,

  I'm having some problems setting custom datetime values for x-axis in a range chart.

  A little background:

  The range chart is to look at SQL job performance and see where there are overlaps between jobs at busy periods of the day.

  The report has parameters for StartDate (date format), StartTime (string), EndDate (date Format) and EndTime (string) as below:

  

  However i cannot seem to set the top range and min range based off the date values plus the "RunDate" (this is in the date format).

  Can anyone help with the formatting of these columns?

  I have attempted to add time to the StartDate parameters however the format is always date, if i could format this to date time it would save me having to have 4 parameters and instead have 2 (StartDateTime and EndDateTime)

  Your valuable advice would be much appreciated.

  Thanks