Not from within Agile, we have built similar reports in congnos using data base views added to the Agile schema. You don’t says what the report shuld contain, but; Below is a query that will list unapproved change orders, who they are waiting on approval from and calculates how long its been waiting upto the point the report runs.

SELECT  c.change_number,
        n.description,
        s.USER_NAME_ASSIGNED,
        au.EMAIL, 
        s.created,
        (SELECT sysdate – s.created FROM DUAL ) elapsed
FROM signoff s
JOIN change c ON(s.PROCESS_ID = c.PROCESS_ID)
JOIN nodetable n ON c.STATUS = n.ID
JOIN AGILEUSER au ON s.USER_ASSIGNED = au.ID
WHERE s.USER_ASSIGNED IS NOT NULL
AND s.SIGNOFF_STATUS = 0
AND s.REQUIRED != 6
AND s.FLAGS LIKE ‘10000000000000000000000000000000’
ORDER BY elapsed DESC;

I will use SDK for this,

• Create search include all changes for week/ month .
• Create FOR loop all changes result:
  • Read   Approvers for each change:
    

    IChange change = (IChange)session.getObject(IChange.OBJECT_TYPE,"ReportChanges[i]");
    IWorkflow[] wfs = change.getWorkflows();
     IWorkflow wf = wfs[0];
     IStatus[] steps = wf.getStates(StatusConstants.TYPE_REVIEW);
     IStatus step = sts[1]; // in my ECO I have two steps of Review.
     IDataObject[] Approvers =change.getApprovers(st);
    

  • continue to next change

If you have more questions please feel free to ask,

To let everyone know a simpler method, for anyone else who doesn’t know, is to use the User Sign-off Duration Report.  Run that report for all Changes and Agile will display a list of all changes with respective approvers.

Matt post is true, but you have to add the changes to be reported on when you execute (5.3.3) , our query based solution came for m the desire to automatically generate reports and deliver unattended. Should have made that clear.