Monday, March 12, 2012

Integer to HH:MM:SS

Hi,
In SRS 2K, how can I take a field that is listed as an integer (say 60),
and make it look like 01:00:00 in the report? Is there a way to do this in
the Textbox Properties window using the Custom Format section?
Thanks.Found my answer in another thread:
=String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddSeconds(Fields!*Value))
"lucotc" wrote:
> Hi,
> In SRS 2K, how can I take a field that is listed as an integer (say 60),
> and make it look like 01:00:00 in the report? Is there a way to do this in
> the Textbox Properties window using the Custom Format section?
>
> Thanks.

No comments:

Post a Comment