Hello Guys ,
I've been struggling two days ago but , not reached to the desired result.
Our Customer needs to have SSRS report for all audit trail in rows view for each entity and field new , old value
He did not want to use the Audit summary view as he wants to see all changes in the same grid ( inline)
so for example
Date Entity Name Field Old value New Value
1/1/2018 contact First Name John John1
1/1/2018 contact Last Name Smith Smith1
...
...
...1/1/2018 Account Telephone telepon1 Telephone2
I've googled it , but people talking about enabling this for specific fields and specific entity using the entity fields self.
and I couldn't parse the changed data to understand the old and new values.
I'd like to get old and new value in the single row
How Can I do that ??
Thanks ,
