Edited - Decryption issue reading a table in a GP Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

NOTE: This has been edited

Hi,

I have created dex trigger scripts that Encrypts a Social Security Number when writing to the UPR_MSTR table and Decrypts the SSN when reading it from the UPR_MSTR table. Everything works great with the exception of reports. If the Report uses the UPR_MSTR table and the SSN field on the report is coming from the UPR_MSTR the report shows the Encrypted value. It looks like the Reports are bypassing the 'Read' trigger. Any ideas how the Reports are reading the data from the table and can I trigger at some point to Decrypt the SSN?

Any help with this would be greatly appreciated.

*This post is locked for comments