My post got cut off from too many characters.https://github.com/meatballcoder/osticket-jasper-plugin(Disclaimer: I wrote that one, for better or worse.)This might point you in the right direction. I can't post the SQL here because it cuts me off in the post saying it's too many characters.SELECT ht.topic, d.dept_name, p.priority_desc, ts.state, Concat_ws(',', sf.lastname, sf.firstname) AS staff_member, t.number, u.NAME, lsit.extra, t.created, t.ticket_id FROM ost_ticket t LEFT JOIN ost_user u ON t.user_id = u.id LEFT JOIN ost_staff sf ON t.staff_id = sf.staff_id LEFT JOIN ost_department d ON t.dept_id = d.dept_id LEFT JOIN ost_ticket__cdata tcd ON t.ticket_id = tcd.ticket_id LEFT JOIN ost_list_items lsit ON Substring_index(tcd.location, ' ', 1) = lsit.id LEFT JOIN ost_help_topic ht ON t.topic_id = ht.topic_id LEFT JOIN ost_ticket_status ts ON t.status_id = ts.id LEFT JOIN ost_ticket_priority p ON tcd.priority = p.priority_id WHERE t.created BETWEEN $p{ticketStartDate} AND $p{ticketEndDate}