Reporting : Sum time, format

Reporting : Sum time, format

Postby nusa » Tue 14 Feb 2017 11:36

Hi,

I'm french people. I wanted to create a reporting. I sum a different time on min. My result is not good.
For ewample I've 200 min. I wanted to see : 3hrs 20 min on my report.

is'it possible?

Thank's.

Nusa :?:
nusa
 
Posts: 18
Joined: Thu 02 Feb 2017 16:12

Re: Reporting : Sum time, format

Postby alexa » Tue 14 Feb 2017 13:33

Could you please provide us the report file and the CREATE definitions of the objects that are present in the report? Screenshots or video would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
alexa
Devart Team
 
Posts: 1932
Joined: Fri 24 Jun 2011 14:17

Re: Reporting : Sum time, format

Postby nusa » Wed 15 Feb 2017 08:20

Hi,

On my Report I've :
https://cl.ly/1i0H2D0t0U3w

136 is in minutes : 136 minutes.

i wanted to see 2h 16 min.

is it possible?

Nusa
nusa
 
Posts: 18
Joined: Thu 02 Feb 2017 16:12

Re: Reporting : Sum time, format

Postby alexa » Wed 15 Feb 2017 12:05

Thank you for the reply.

Could you please let us know what are the types of the columns TicketTask.Logwork and TicketTask.CreationDate?
alexa
Devart Team
 
Posts: 1932
Joined: Fri 24 Jun 2011 14:17

Re: Reporting : Sum time, format

Postby nusa » Wed 15 Feb 2017 13:45

Hi,

TicketTask.Logwork : INT
TicketTask.CreationDate : datime

TicketTask.CreationDate is not important, I make a sum of TicketTask.Logwork

Nusa
nusa
 
Posts: 18
Joined: Thu 02 Feb 2017 16:12

Re: Reporting : Sum time, format

Postby nusa » Thu 16 Feb 2017 16:30

I sole vmy problem :

Code: Select all
CONVERT (TIME(0), DATEADD(SECOND, TicketTask.Logwork, 0)) as 'hh:mm:ss'


Nusa
nusa
 
Posts: 18
Joined: Thu 02 Feb 2017 16:12

Re: Reporting : Sum time, format

Postby alexa » Fri 17 Feb 2017 12:39

Thank you for updating us on this issue.
alexa
Devart Team
 
Posts: 1932
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for SQL Server