How can i create an assembly to decrypt data in SSRS 2008 R2.
I have encryted data in an Employee table and i need to be able to decreyt the data to print unencrypted values.
I am envrypting the data using a certificate. I can decryt the data in SQL but i want to be able to decrypt it in SSRS.
I am using the following code in SQL.
OPEN SYMMETRIC KEY Emp
DECRYPTION BY CERTIFICATE EmpCert;
Any help will be greatly appreciated...