Hi There,
You can accomplish something like this with a simple SQL Join:
Application Name, AppID, Comments:
select a.ApplicationLName,a.ApplicationID, b.DataText from ams_application a, AMS_ApplicationItem b
WHERE b.ItemID = a.CurrentWFMajorItemID
You would do something similar for the second report query, only against the AMS_Person and AMS_WFMajorItemTpl tables, which will have the display names of the User GUID and Current Workflow Phase GUID's stored IN AMS_Application.
Regards,