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: [email protected] [mailto:[email protected]] Im Auftrag von Trasschaert Karl Gesendet: Freitag, 16. Januar 2009 09:40 An: [email protected] 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: [email protected] To: [email protected] 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: [email protected] [mailto:[email protected]] Im Auftrag von Trasschaert Karl Gesendet: Donnerstag, 15. Januar 2009 17:38 An: [email protected] 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 !<http://www.microsoft.com/windows/windowslive/default.aspx> ________________________________ Vos emails et contacts Messenger vous suivent partout !<http://www.windowslivemobile.msn.com/?mkt=fr-be>
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
