For ticket templates, this should work fine: https://www.lansweeper.com/knowledgebase/creating-ticket-templates/
As for the report, I would suggest taking a look at the built-in reports and the database documentation. Maybe there is something on the forum too that is near what your trying to get.