hash in RS

Hi,

I need to take the Social Security number and hash it into a unique identifier because I can't display Social Security numbers on a report.

Does Reporting Services have any encrypting/hashing routines that I can use?

Any suggestions?

Thanks.

You could write some code to do this, however there is no built-in functionality.

If it needs to be secure I would has the data within SQL Server. If you are using SQL 2005 there are some functions to do this.

Here is something that may relate.

http://blogs.msdn.com/lcris/archive/2005/12/22/506931.aspx

cheers!

|||

Maybe you can use the vb code in the following link in your report code and call the function to get the encrypted value:

http://www.freevbcode.com/ShowCode.asp?ID=4398

Or you can write a custom code in any of the .net supported language and use Encryption class in the BCL and refer to this custom code (.dll) and call the function again to get the excrypted value back.

Or in a simple way, display just "###-##-####" for all records instead of displaying the encrypted/hashed value because there is always a possibility that the hacker could decrypt the value.

Shyam