Hi,

I'd like to get a report that shows after what duration tickets have been assigned to a group the first time and to a technician the first time in two different columns. The report should consider the business hours defined. More or less what is shown in the history "Time Elapsed Analysis" in the bars "Group" and "Technician".

The list should contain the following attributes in addition:
WORKORDERID, RequestTypeDefinition.Name, PriorityDefinition.PriorityName, TITLE, CREATEDTIME, RESPONDEDTIME (if exists, else empty), RESOLVEDTIME (if exists, else empty), COMPLETEDTIME (if exists, else empty),  SDOrganization.NAME, LTRIM(People.ATTRIBUTE_901)

The list should look like this

Attributes as  mentioned above ....  First assignment to group, First Assignment to technician
xxxxx                                                hhh:mm:ss                         hhh:mm:ss
xxxxx                                                hhh:mm:ss                         hhh:mm:ss
xxxxx                                                hhh:mm:ss                         hhh:mm:ss

We use an MSSQL database

Would that be possible ?

Thanks a lot

Matthias