A reporting structure

C4RLOCO

It would be great to have a better reporting system to download data for department analysis.

Some of the reports I would find useful are: tickets closed by staff and open tickets assigned to staff. At this moment there is no quick way to see this information.

But this is just an idea, as overall this is one of the best ticket support systems I have ever used.

Keep up the good work out there.

michael.therrien

I agree, I'm working on a few things for reporting right now. I'll post the MODs when I'm done, be on the lookout!

pchelp

Have completed the reporting MOD?

cutesnifer

It would be great to have a better reporting system to download data for department analysis.
Some of the reports I would find useful are: tickets closed by staff and open tickets assigned to staff. At this moment there is no quick way to see this information.
But this is just an idea, as overall this is one of the best ticket support systems I have ever used.
Keep up the good work out there.
AK

yes u are right.. I am too thinking of making one report generation page for all staffs. i know the importance of generating report. If it come handy .. defenitly can save alot of my time

I have some idea on my own. they are like:

Daily report,

weekly report,

monthly report,

yearly report,

I was wondering what all thing will be needed to include in these report data. I mean may be like - Number of attended tickets, Number of opened ticket, number of closed tickets, work time (time between an opened ticket and closed tickets), Assigned to other staff, assigned to other dept.. etc.

I would like to hear from u guys too.. any suggestion please elaborate.

benyraja

If we create with more filters then it is easy to classify the stats as expected

the reporting tool must have more filters to fine tune the search to get the exact data we need.

Just my thought!!

-Beny

pcl123

Hi, 1.6 have report now, but it is not good enough: can't export file to excel

Wait for this feature.

Thank you

gauravkhubchandani

Report Tool

Please let us know about the feature once its done because its utmost important to make a report or if it is possible to export data from osticket for quality monitoring and development.

Thanks

tery161

How long do we have to wait for this reporting tool. It's really helpful but no receive the consideration of many.

valentin.marzac

reports

Hello,

you can use another reporting tool that you can connect to mysql databases for example try Jasper ...it a great tool, open source ...and you can create waterver you want, even graphics....

Achiles

reporting tool

Hello,
you can use another reporting tool that you can connect to mysql databases for example try Jasper ...it a great tool, open source ...and you can create waterver you want, even graphics....

Hii,

How do connect to ostiket.?

ntozier

OST clients and staff connect with the web interface. (ie http://yourdomain.com(http://yourdomain.com) or http://yourdomain.com/scp(http://yourdomain.com/scp) respectively).

If you are asking how to connect to the osticket database, then you will need to know the following:

servername:

databasename:

username:

password:

Most applications that connect to databases have a tutorial as to how they want things setup I recommend that you consult the documentation for the 3rd party product that you are using, or ask for help on that products forums.

jasonk

Yes how do we connect to osticket after we have created the report via Jasper , what i would like to do is if i created my reports i would like to alter the php code for osticket reports to insert the new link to the new reports , how can this be done