How to display a time span of seconds in hh:mm:ss format in Reporting Services -


In MS Reporting Services 2008, I have a field that has a stored duration in seconds. Is it a true way of getting the HH: mm: SS format in the group section of the report?

If you want to display it, then convert an expression to the value of the text box: 

  = Format (add date ("s", field! MySecondsField.Value, "00:00: 00"), "hh: mm: ss")   
 if you want to count on it , Then convert the seconds into the datetime into your dataset. Use of SQL:  
  SELECT DATEADD (SS, MaisonCandfield, '19 00-01-01') Time SAS Seconds Set date   
 In Linux Something will happen:  
  var qry = q to t. Select the timeless new {secondsAssetTame = dateTime. Today.Edecand (Q.Missandfield)};   
 Then you can format it as a normal datetime.

Comments

Post a Comment