OTRS Report [SOLVED]

Moderator: crythias

Locked
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

OTRS Report [SOLVED]

Post by SLESSARD »

Just need some idea regarding what the OTRS community is using for reporting. I know OTRS provides some interesting feature but mot complete. My problem is that budbet is null therefore Crystal Report is not an option ... other than in-house development is anyone aware of interesting open source tools that work well with OTRS MySQL for reporting?
Last edited by SLESSARD on 19 Dec 2011, 23:05, edited 1 time in total.
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Report

Post by jojo »

you can use Open Office with ODBC, Jasper Reports etc. There are loads of SQL based OS reporting tools
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

Re: OTRS Report

Post by SLESSARD »

Thanks ... will look / test around and update my solution later
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

Re: OTRS Report

Post by SLESSARD »

Ended up building what I need with MySQL report builder ... OTRS provides several out of the box report and the possibility to develop our own but for something real specific, an external tool is a must.
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
radioguy
Znuny newbie
Posts: 4
Joined: 12 Dec 2011, 23:46
Znuny Version: 3.1

Re: OTRS Report [SOLVED]

Post by radioguy »

What report builder did you use?
SLESSARD
Znuny advanced
Posts: 119
Joined: 12 Jan 2011, 22:35
Znuny Version: 4.x.x.x.x
Company: Self-Employed

Re: OTRS Report [SOLVED]

Post by SLESSARD »

Report building tool that comes our our SQL licenses ... SQL Server Report Builder
OTRS 4.0.11
Ubuntu 15.04
MySQL Database, PHP5, Apache (LAMP server bundle)
Locked