Hi, Thx for the info, Could you send more info how to do Excel-Art with ODBC ?? Thx in advance. Karl From: obee@myhammer.de To: otrs@otrs.org Date: Thu, 15 Jan 2009 17:58:29 +0100 Subject: Re: [otrs] OTRS reporting An honest word: skip the stats and do some Excel-Art with ODBC… Greets Daniel Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Trasschaert Karl Gesendet: Donnerstag, 15. Januar 2009 17:38 An: otrs@otrs.org Betreff: [otrs] OTRS reporting Hi, I would like to create stats or reporting about Nubers of ticket Answered/Closed in the sla times.%in the sla time ans % out of the sla times. And stats about new to open and new to closed time. Can someone help me to make the configuration of the stat module ? I also have a problem, i cannot make graphics with the stats module, what can be wrong with my config ? Thanks in advance Karl Vous pouvez désormais lire tous vos comptes e-mails à un endroit. Gagnez du temps grâce à Windows Live ! _________________________________________________________________ Vos emails et contacts Messenger vous suivent partout http://www.windowslivemobile.msn.com/?mkt=fr-be

Daniel, Do you have a sample xls file ? If yes, could you share it ? Thx in advance. Karl From: obee@myhammer.de To: otrs@otrs.org Date: Fri, 16 Jan 2009 10:48:03 +0100 Subject: Re: [otrs] OTRS reporting The easiest way is to use Toad (Freeware), build a statement as needed and export it as excel sheet with pivot table. Toad automatically inserts the ODBC connection, so you can update the data in the file. Another way is to install an ODBC driver on your computer and manually add the ODBC information and statements in the sheets. Can’t really go into details here because this is a complex topic. Refer to MS for more information on ODBC and try Toad. Nice tool anyway… Greets Daniel Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Trasschaert Karl Gesendet: Freitag, 16. Januar 2009 09:40 An: otrs@otrs.org Betreff: Re: [otrs] OTRS reporting Hi, Thx for the info, Could you send more info how to do Excel-Art with ODBC ?? Thx in advance. Karl From: obee@myhammer.de To: otrs@otrs.org Date: Thu, 15 Jan 2009 17:58:29 +0100 Subject: Re: [otrs] OTRS reporting An honest word: skip the stats and do some Excel-Art with ODBC… Greets Daniel Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Trasschaert Karl Gesendet: Donnerstag, 15. Januar 2009 17:38 An: otrs@otrs.org Betreff: [otrs] OTRS reporting Hi, I would like to create stats or reporting about Nubers of ticket Answered/Closed in the sla times.%in the sla time ans % out of the sla times. And stats about new to open and new to closed time. Can someone help me to make the configuration of the stat module ? I also have a problem, i cannot make graphics with the stats module, what can be wrong with my config ? Thanks in advance Karl Vous pouvez désormais lire tous vos comptes e-mails à un endroit. Gagnez du temps grâce à Windows Live ! Vos emails et contacts Messenger vous suivent partout ! _________________________________________________________________ Découvrez vite le nouveau Hotmail ! http://www.windowslive-hotmail.com/comingsoon/fr/default.htm