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

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/

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

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

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.