SSRS Range chat display hours not working

• elidexter

  SSC Enthusiast

  Points: 187

  More actions

  October 11, 2019 at 6:09 pm

  #3688111

  Hi,

  I created a dataset with columns: Title varchar,startdate(datetime),endDate(datetime),diference(hours),startpoint(dif in hours int),endpoint(dif in hour int)..

  the range of my data(min of startdate and max(enddate)) is lower than 1 day.

  So i calculated dif in hours..but char takes hours like days and sum them..

  pej(calculated in hours):

  start date 2019-10-04 13:00

  end date 2019-10-04 14:00

  startpoint 1049773

  endpoint 1049774

  char horizontal axis result formated like date-> 08-03-4474...what?...it sums hours like days..(select dayadd(day,0,1049774))

  Why?..how can i fix it or char can'ts graph in hours?

  Thanks

   

  • This topic was modified 4 years, 6 months ago by  elidexter.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  October 12, 2019 at 6:10 pm

  #3688242

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.