Hello.
I don't satisfied with OTRS's stats module. I heard it's possible to use Jasper Reports for getting stats from OTRS's database in acceptable form. Please help me to understand the issue. How to use it?
How to use Jasper Reports with OTRS?
Moderator: crythias
-
- Znuny newbie
- Posts: 47
- Joined: 21 Sep 2012, 07:55
- Znuny Version: 5.0.10
- Real Name: Игорь (Igor)
How to use Jasper Reports with OTRS?
OTRS 6.0.20, Debian GNU/Linux 9 stretch
Re: How to use Jasper Reports with OTRS?
you need to use SQL and connect directly to the database via Jasper.
So you will need:
- some jasper knowledge
- some deeper SQL knowledge
So you will need:
- some jasper knowledge
- some deeper SQL knowledge
"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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 47
- Joined: 21 Sep 2012, 07:55
- Znuny Version: 5.0.10
- Real Name: Игорь (Igor)
Re: How to use Jasper Reports with OTRS?
Yes, I understand that. But I didn't get how to install Jasper. What to install: jasperreports server or iReports only or something else?
And if you know can you give me a link where I can to read about SQL requests directly to OTRS database? I need some deeper SQL knowledge.
And if you know can you give me a link where I can to read about SQL requests directly to OTRS database? I need some deeper SQL knowledge.
OTRS 6.0.20, Debian GNU/Linux 9 stretch
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: How to use Jasper Reports with OTRS?
Jasper Reports is not supported by OTRS. Don't expect support for it here. Though, yes, you'll likely need jasperreports server and read its documentation how to install.
The basic SQL connection information to OTRS is in your Config.pm (username, password, database name)
After that, you'll need to know the schema of otrs, its interactions, table information, and maybe take a look at http://wiki.otterhub.org/index.php?titl ... generators for some queries.
The basic SQL connection information to OTRS is in your Config.pm (username, password, database name)
After that, you'll need to know the schema of otrs, its interactions, table information, and maybe take a look at http://wiki.otterhub.org/index.php?titl ... generators for some queries.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask