Encrypt and Decrypt function in SSRS

Question

Hi

I am looking for encrypt and decrypt function within SSRS to encrypt a value field in SSRS Report. I know we dont have any such function but can write custom code to do it so.

 

Any Help on this?

---

Ravi.S Chennai, Tamil Nadu, India

Answer 1

Hi Ravi,

What do you mean by encrypting a field in SSRS ?

Do you mean when exported it should sent it in an encrypted format ?

---

Rakesh M J

Dont forget to mark it as Answered if found useful

MCTS,MCITP,MCSS

http://mycubeandreports.blogspot.com/

Answer 2

Tried doing little bit of googling on this and stubled upon the below link..this is a function for encrypt and decrypt in SQL Server... May be you can make use of this at the database level itself if you are working with SQL Server source

http://www.sql-server-helper.com/functions/string-encryption.aspx

If still want to write custom code , the below link will be the good starting point about custom code.

http://msdn.microsoft.com/en-us/library/ms155798.aspx

And below link has the encryption & Decryption code in c#. Hope you can implement it in custome code. As there no difference in writing a custom code function and a C# function.

http://www.codeproject.com/KB/security/DotNetCrypto.aspx

Answer 3

I have a user field displayed in a report and on click action i am loading a report where i send this user filed as parameter. SO i want this USer filed sent encrypted format in URL in the action expression.

---

Ravi.S Chennai, Tamil Nadu, India

Answer 4

Hi Ravi,

Thanks for your question and other partners’ replies, Sorna’s solutions are overall and valuable. I would recommend you apply them on your report. If they achieved you requirement, please remember to mark them as answer.

Thanks,
Sharp Wang

---

Please remember to mark the replies as answers if they help you and unmark them if they provide no help.