Not sure if this is of any use to anyone, we have used OSTicket for many years and have put over 70k tickets through our install. We found a few years back that we wanted better reporting than what it comes with as standard so I wrote a reporting php script, feel free to take and use as you see fit - https://www.theictguy.co.uk/osticket-advanced-reporting-with-ostreports/
Sorry, reposted this just now as i posted it in the old 1.6.x forum, its been a long day!!