This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Custom report using SSRS

jchill - Tuesday, March 22, 2011 3:28 PM:

I'm working on a report which displays ECRs filtered by a customer.  I need to find out when the ECR entered a perticular state.  Is there a table within the database that contains a history of state changes?



SamsAn - Sunday, April 17, 2011 4:18 PM:

Hello.

The history info (ECR is histarable in the standard solution by default) is stored in History table. You can find the record by action=promote and state=perticular. Then created_on column says when the ECR instance was promoted to the state.

SamsAn.