astralliquid Posted March 17, 2015 Share Posted March 17, 2015 Hi I need help with this too : http://forum.whmcs.com/showthread.php?66635-Support-Ticket-Reports I have created a custom field to record duration in minutes for each ticket. Each year I want to send out a report to clients listing all the tickets they have submitted and the time taken. Please point me to how to create a report listing like this : Client : ABC Period : 1/1/2014 - 31/12/2015 Date Ticket No Subject Duration (this is custom field) Requested By (shows the email) -------------------------------------------------------------------------------------------------- xxxx xxxxxxx xxxxxxxx 15 xxxxxxx xxxx xxxxxxx xxxxxxxx 15 xxxxxxx xxxx xxxxxxx xxxxxxxx 15 xxxxxxx xxxx xxxxxxx xxxxxxxx 15 xxxxxxx Please help. Thanks. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted March 17, 2015 Share Posted March 17, 2015 a good starting point might be to take a look at the thread below... http://forum.whmcs.com/showthread.php?34909-Response-Time-Widget-amp-Report if you jump to the final page, there is a github link to download the files. to modify the report for your purpose, you would need to modify the existing SQL queries to get additional fields; add a new query to get the custom field from the database and also add a pdf export option. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.