How to use Jasper Reports with OTRS?

[firebolt]

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?

[jojo]

you need to use SQL and connect directly to the database via Jasper.

So you will need:
- some jasper knowledge
- some deeper SQL knowledge

[firebolt]

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.

[crythias]

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.