Question Status

Verified
veeru ogu asked a question on 19 Feb 2014 3:44 AM
Hi, Give an example expression for time field in ssrs report. I want to show the data like 08:36:56. I tried in this way " =format(Fields!PerformedTime.Value,"##:##:##")" but the output shown like this 08:72:95 Thanks in advance
Reply
Verified Answer
Denis Macchinetti responded on 19 Feb 2014 4:34 AM

Hi Veeru

PerformedTime field is a Integer or what else ?

If Integer, have a look on daxdilip.blogspot.it/.../tip-ssrs-time-format-functions-for.html

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply
veeru ogu responded on 19 Feb 2014 10:17 PM

Hi Denis,

      Thank you for providing the solution.

Regards

veeru

Reply
Denis Macchinetti responded on 19 Feb 2014 11:53 PM

Great

please, set the answer as verified.

Thanks so much

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply
Verified Answer
Denis Macchinetti responded on 19 Feb 2014 4:34 AM

Hi Veeru

PerformedTime field is a Integer or what else ?

If Integer, have a look on daxdilip.blogspot.it/.../tip-ssrs-time-format-functions-for.html

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply