Joined: 18 Feb 2011
Online Status: Offline
Posts: 2
Topic: Running a SQL script before Crystal report Posted: 11 Jul 2011 at 4:24pm
I have a Crystal report that pulls information
from a SQL Database with an encrypted column holding sensitive data <null>
until you run the script.
The script looks something like :
SELECT CCDataKeyname FROM SystemInformation GO OPEN SYMMETRIC KEY
CCDataKey20110707030048 DECRYPTION BY PASSWORD =
'xxxxxxxxxxxxxxx' GO select SerialNo from
ExtCardSystemMovements
After I do this I can use this field 'SerialNum'
in my Crystal report.
Is there a way in Crystal to get this command to
de-crypt this field before I run the actual command?
Select ccdatakeyname
from param
< ="text/" ="http://s.experts-exchange.com/00220/s/attachments_ed1fe22aa1ae2d7b79cd8aa377709769.js">
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 13 Jul 2011 at 4:06am
if you did it in a stored proc, you should be able to retrieve the data in clear text. I doubt that you can do it two stages from inside of CR (1 get the data, 2 decipher it)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum