v2019 Adv.  Customer would like a Crystal report showing what email address is set up in Employee Maintenance/Paperless for Electronic Delivery.  It may/may not be the same as the Email that is on the Employee Header.  The PR_EmployeeDocuments.m4t is an encrypted table.  I used the Pr_Employee, PR_EmployeePIIWrk & PR_EmployeeDocuments tables, added the report to the menu and set about creating the report.  I found the Email Address in PR_EmployeeDocuments will not pull into the report (comes up blank). The PR_EmployeePIIWrk table does not include any fields from the PR_EmployeeDocuments table.  How can I access the encrypted fields in PR_EmployeeDocuments in a Crystal Report.  Seems like Sage forgot about these fields in creating the PII Table.  Ideas?

On a side note: At time of migration/conversion from v2016 to v2019, the data all came over and did not encrypt during conversion.  However, any modification/update to the record (employee changes emails or creation of electronic delivery record) after the conversion is now encrypted.  

Thank you

Nancy