none
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
    Tuesday, June 28, 2011 10:57 AM

Answers

All replies

  • 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/

    Tuesday, June 28, 2011 11:38 AM
  • 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

    Tuesday, June 28, 2011 11:40 AM
  • 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
    Tuesday, June 28, 2011 11:43 AM
  • 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.
    Wednesday, June 29, 2011 11:10 AM