It's only integer

Hello,

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

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...

Manually it is working perfectly fine, actually my destination is network shared location , even SQL job working perfectly fine as destination local driver but with network location keep running...

Well .BAT file copying files from one folder to other folder using robocopy command utility

Hi,

I have INT value like 103743 or 33059, which going to aggregate in my chart for/by different dates.

I want to use expression for show data labels, and want to show...

I applied as you suggested but it seems some more modification is require.

I am attaching screen shot for you for reference.

Default

after applying expression

I hope it will give you clear...

This expression I have to do in SSRS Report Designer

Just you think with designer how we can show HH:MM:SS instead of INT

To aggregate we need INT or decimal data type,

Okay my requirement is to show in last 30 days specific SQL job what time executed.

Now here I have two output from...

Hi Pulivarthi Sasidhar

I have the requirements such a way I have to carry INT from SQL end and have to do HH:MM:SS in SSRS Report Builder only for showing data...

Well I need to show the time format like HH:MM:SS, so if I am getting 33058 mean 3 Hou, 30 Min and 58 Sec.

and what you suggesting add 0, like...

When we query msdb.dbo.sysjobhistory table we are getting run_time what time the job competed,

Now question how can convert run_time as INT to hh:mm in report designer to show HH:MM

Hi,

I need to show SQL job execution for last 30 days at what time, this mean I have Date and time.

Now question how I can take Time (hh:mm) for aggregations,...