Decrypt credit card number for Reporting Services Report

[Amy B]

Hi,

A co-worker is creating a vb.net web application which uses the
CryptKeeper.dll to encrypt credit card numbers into a sql database.
It is my job to pull these encrypted numbers and use the decrypt
method of this dll to show the credit card numbers on a Reporting
Services report. I'm not even sure where this should be done. In the
sql stored procedure or in the report itself? Any help would be
greatly appreciated.

Thanks in advance,
Amy Bolden

[Ravi Mumulla \(Microsoft\)]

If you have access to this dll via an extended stored procedure in SQL
Server, you could go that route. Or you could use embedded code or a custom
assembly. Check
http://msdn.microsoft.com/library/de...asp?frame=true
for details on latter.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
"Amy B" <ab*****@eastridge.net> wrote in message
news:ba**************************@posting.google.c om...

Hi,

A co-worker is creating a vb.net web application which uses the
CryptKeeper.dll to encrypt credit card numbers into a sql database.
It is my job to pull these encrypted numbers and use the decrypt
method of this dll to show the credit card numbers on a Reporting
Services report. I'm not even sure where this should be done. In the
sql stored procedure or in the report itself? Any help would be
greatly appreciated.

Thanks in advance,
Amy Bolden