wheels0323
Programmer
I need a way to convert this field into hh:mm
=Fields!TotalTimeSeconds.Value
It comes back as total seconds for a day.
I need to do this in reporting services somewhere inside the field textbox itself.
I was using
Convert(VarChar(2), sum(timeinseconds) / 3600) + ':' + Convert(VarChar(2), sum(timeinseconds) / 60 % 60) as TotalTime, in my SQL, but Iam unable to sum this field in reporting services. Yet, this field did come back the way I needed it.
=Fields!TotalTimeSeconds.Value
It comes back as total seconds for a day.
I need to do this in reporting services somewhere inside the field textbox itself.
I was using
Convert(VarChar(2), sum(timeinseconds) / 3600) + ':' + Convert(VarChar(2), sum(timeinseconds) / 60 % 60) as TotalTime, in my SQL, but Iam unable to sum this field in reporting services. Yet, this field did come back the way I needed it.