use dynamic report to query active tickets only