SSRS 2012 Old and New Values in a given table

[Paula Morrison]

I dont know if this is the appropriate platform on which to ask but I have gone all around the houses to try and find the right answer to this and desperately hoping someone can help. This is the query:SELECT EntityView.LogicalName, CASE WHEN Audit.Operation = 1 THEN 'Create' WHEN Audit.Operation = 2 THEN 'Update' WHEN Audit.Operation = 3 THEN 'Delete' WHEN Audit.Operation = 4 THEN 'Access' END AS Action, FORMAT(DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), Audit.CreatedOn), 'dd/MM/yyyy HH:mm') AS AuditCreated, Filteredrqia_registeredperson.rqia_registeredpersonidnumber AS RegisteredPerso

Continue reading...