Formating INT value to custom HH:MM:SS using expression for data labels

Question

Post reply

Formating INT value to custom HH:MM:SS using expression for data labels

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

wwwnlc111 Old Hand Points: 385 More actions · Answer 1

Well, please allow me to come in simple talk, let's suppose I have value in SSRs report designer like 103743 or 33059.

How I can using expression show like below for data labels,

103743 i.e. 10 Hou, 37 Min and 43 Sec

33059 i.e. 3 Hou, 30 Min and 59 Sec

Thom A SSC Guru Points: 99133 More actions · Answer 2

wwwnlc111 (5/9/2016)
Well, please allow me to come in simple talk, let's suppose I have value in SSRs report designer like 103743 or 33059.
How I can using expression show like below for data labels,
103743 i.e. 10 Hou, 37 Min and 43 Sec
33059 i.e. 3 Hou, 30 Min and 59 Sec

Does the expression I gave the other day not supply this? For example, it would convert 103743 to "10:37:43", and 33059 to "03:30:59".

If you want "hou"/etc instead of a semi colon, you can simply change the strings in the middle of the expression for the values you want.

If this doesn't, what seems to be wrong?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Thom A SSC Guru Points: 99133 More actions · Answer 3

Edit :Wrong Topic >_<

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

In SSRS is really easy.

=Format(Parameters!intTime.Value, "#0:00:00")

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

wwwnlc111 Old Hand Points: 385 More actions · Answer 5

Hello,

I am attaching two screen shot one normal and other after applying =Format(Parameters!intTime.Value, "#0:00:00")

Thom A SSC Guru Points: 99133 More actions · Answer 6

wwwnlc111 (5/10/2016)
Hello,
I am attaching two screen shot one normal and other after applying =Format(Parameters!intTime.Value, "#0:00:00")

Are the number actually integers or do they have some decimal places? If might be worth casting intTime to a integer in your expression, if you're not sure.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

wwwnlc111 Old Hand Points: 385 More actions · Answer 7

wwwnlc111

Old Hand

Points: 385

May 10, 2016 at 8:23 am

#1877801

It's only integer

Luis Cazares SSC Guru Points: 183706 More actions · Answer 8

wwwnlc111 (5/10/2016)
It's only integer

Is the data type an integer?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2