Encrypt and Decrypt Data - Subscription

Hi All,
I am subsrcibing a report through the Report Manager, before sending the
mail, i need to encrypt the data in the report and send it to the user.
I can do the encryption but passing the data to a function in a custom
assembly and then return the encrypted data to the report and then send a
mail.
But at the receiver end, the report data should be decrypted and display in
the mail when the user open the subscribed mail.
Any inputs..
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comIn this scenario your clients would have to have your decrypt utility. And
that would only work if your export format is one of the text based ones
(csv, xml, etc) and not one of the image based ones (tiff, pdf, etc).
What I did was, based on my application logic, create subscriptions, have
reports saved to a file share, have a windows service process take the
report and save it in an image field in the database. To get the report the
user logs into my web app (which is https and secure) and retrieves the
report.
--
Adrian M.
MCP
"BALAJI via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:bd5744926a0e4a00b632863dfb28dc20@.SQLMonster.com...
> Hi All,
> I am subsrcibing a report through the Report Manager, before sending the
> mail, i need to encrypt the data in the report and send it to the user.
> I can do the encryption but passing the data to a function in a custom
> assembly and then return the encrypted data to the report and then send a
> mail.
> But at the receiver end, the report data should be decrypted and display
> in
> the mail when the user open the subscribed mail.
> Any inputs..
> Thanks
> Balaji
> --
> Message posted via http://www.sqlmonster.com