Non proposé par défaut, voici un rapport que je me suis ajouté dans certains trac.

Celui ci me donne par composant, les derniers tickets fermés

[sql]
 SELECT 
 component as __group__,
   changetime AS modified,
   id AS ticket, 
 
   component, 
   summary, 
   (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner_,
 
 
   time AS created,
   t.type AS type, 
   version, 
   description,
   reporter
  FROM ticket t
  WHERE status IN ('close', 'closed') 
  ORDER BY (version IS NULL),version, (component IS NULL),component,  changetime DESC,   t.type, time