Is it possible, and if so, how, to create a report that would give me a list of files that have gone from one particular state to another? What I am being asked to deliver is the count of the number of files that are being Declined. When they are Declined, they are going from a state of Waiting For Approval to Pending Documentation. I would like to know everytime that that transition has occured. That information must be available somewhere in the database because you can see in the history of an item if that has indeed occured.
Any help would be greatly appreciated. Thanks everyone.