osTicket > Reports 7.5 (1.10+)

The below modifications have now been re-coded into an easy to install plugin. The plugin is currently available on 1.10 installations for $50. Additional details, support information and community boards are coming very soon at a new website.

Available Time Ranges
Today
Yesterday
This Month
Last Month
Last 30 days
This week (Sun-Sat)
Last week (Sun-Sat)
This business week (Mon-Fri)
Last business week (Mon-Fri)
This year
Last year
All Time
Manual dates entry

Available Reports
Tickets per Department
Tickets per Group
Tickets per Team
Tickets per Day
Tickets per Month
Tickets per Staff
Tickets per Help Topic
Tickets per Client
Tickets per Organization
Replies per Staff

7.0 Updates:

Time to Resolution for all reports
THREE new reports!
Tickets per Organization
Tickets per Group
Tickets per Team

Note regarding demo. The database for this will be restored every day so we don’t get a bunch of crap loading up in it from anyway goofing around, etc. Also the staff table is restored every single minute, so don’t bother making extra users, etc 😉

Hello Steve, Thank you very much for the great,great job u did for us. Now, me and my company are enjoying the result of your job.
The report module is working great, just to ask you something which my boss is askng me to do, and I don’t have any idea:
If I go into report criteria, choose report type and select ‘tickets by help topic’, and submit, there is a field called ‘null’, which maybe is a default for tickets with no help topic. I want to modify it and call it for example ‘others’.
Please help. Or if any other can intervene, i will be more than happy.
Thx

good day, please I request your help, I have installed locally ostickets I mean at 127.0.0.1, and it works perfect, the problem is that when you include the reports module, to change or replace the file header.inc . php with the correct module code, the system will not charge more, this returns a 500 error. if i use it on a web server if it works perfect, but locally not work I do not know what could be?

Well, I thought I followed everything correctly. But after logging into scp and navigating to reports.php I see messages like this: Can’t open reports_csv/Report_1374457836.csv. Also get that when trying to run a report.

Also for reports_admin.php I get Unable to load the webpage because the server sent no data. Error code: ERR_EMPTY_RESPONSE.

I figure I probably need to do something with permissions or something, but I am not sure what or where to do it.

Yep, first thing to check would be the permissions. Also, make sure everything is dumped into the scp/ folder. If that all appears correct check your web servers error log and see if there is anything helpful in there. Feel free to email any errors in the log to me and I can work with you to get it all resolved.

I did all the steps that are shown above, but whenever I try to click on the reports link in the scp page it comes back with a blank page. Is there something that is missing such as reports php? do you include that when you make the donation?

would be interested to have it but we would need to know if you have any study reporting the time spent with each client from one period of time, for example you can have the following data
client, date, ticket number, time spent, ticket status?

Hi Scott
I really love your OS Ticket First Theme and would like to purchase the Customer Client. My question is can I fully customize the CSS file to create a Metro (Windows 8) style. The design needs to be flat colors without gradients. Of course I will also need to update the color palette and replace the logo.
Thanks
Martin

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/virtual/domain/servicedesk/htdocs/scp/reports_includes/functions.php on line 18 Warning: mysql_result() expects parameter 1 to be resource, boolean given in /var/www/virtual/domain/servicedesk/htdocs/scp/reports_includes/functions.php on line 18

Once you’ve donated you should be receiving instructions to download the zip file. Extract all files to the scp/ directory and set all directories to 0755 and all files to 0644. Please also move the included file “include/staff/header.inc.php” to ROOT_INSTALL/include/staff/header.inc.php”

in the donation page i can’t see any login or ID saying that i am (Samuel) paying. How i will receive the zip file if there is no login id for me.

Once you’ve donated you should be receiving instructions to download the zip file. Extract all files to the scp/ directory and set all directories to 0755 and all files to 0644. Please also move the included file “include/staff/header.inc.php” to ROOT_INSTALL/include/staff/header.inc.php”

in the donation page i can’t see any login or ID saying that i am (Samuel) paying. How i will receive the zip file if there is no login id for me.

Scott,
I want to get known that you went the extra mile to give always quick support to something that was revealed not to be your responsibility. Your input and quick assistance forced me to setup another server… then according to your instructions all went smooth and is running great. Great product and support!

Sorry for the confusion and thank you for the email and payment, however,
there has been a lot of work done on the reports MOD since it was priced at
$10 / $15. Several new reports and features have been added and we are also currently working on turning it into a drop in plugin. With this in mind the reports MOD price was changed to $35 / $50. Would you like me to
refund your $10 or would you like to send in the rest of a payment?

-Is it possible to create reports based on custom fields?
-Is anyone else having issues with the applications button?
-Is anyone else getting the ‘use of unidentified constant…’ messages at the top of the reports page?

There currently isn’t support for creating custom field reports, it may be something I look into in the future. The applications button not working is actually an osTicket bug, there is no apps.php page included and so it fails. Can you check on your scp/reports.php line 3? You should have the definition for the REPORTS constant?