Hello - 

We have a client building some custom reporting for business processes/workflows, and they have a requirement to report a specific field's value when certain business processes are started - has anyone done something along these lines, and if so would you be willing to share some tips?

The best thing I could come up with so far is to retrieve the necessary field value at the start of the workflow and write it, along with the business process's Process ID, to a SQL table using an Insert Data activity. It appears that the system writes Process ID to the data3 column of the dbo.bp_event table. That table has another column (bpi_id) that is used in the dbo.BPInstances view, so they should be able to tie the field's value to the business process instance there.

Thanks all for your time!