Daniel,
Do you have a sample xls file ?
If yes, could you share it ?
Thx in advance.
Karl
From: o...@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-boun...@otrs.org [mailto:otrs-boun...@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: o...@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-boun...@otrs.org [mailto:otrs-boun...@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
_______________________________________________
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
