GetClientIP Error - rsRuntimeErrorInExpression

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  February 17, 2014 at 5:16 am

  #282435

  To get the client ip followed the steps

  1. Open the layout mode.

  2. Click the menu “Report” -- > “Report Properties…”

  3. Switch to “Reference” tab.

  4. Click the top “Add” button, and then add the “System.Net”

  5. After applying the follow steps, go to “Code” page, embed the following code:

  Public Function GetClientIP() As String

  Dim ipHost As System.Net.IPHostEntry

  ipHost = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName())

  Return ipHost.AddressList(0).ToString()

  End Function

  6. Now, in the report, use the following expression to get the value:

  =Code.GetClientIP()

  Reference :

  http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ff58b2fe-5fa7-4f2b-b36d-9685fc9f74fd/how-to-get-the-ipaddress-and-host-name-of-the-client-machine-on-which-reports-are-being-viewed?forum=sqlreportingservices

  Error

  Request for the permission of type 'System.Net.DnsPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsRuntimeErrorInExpression)

  how to resolve the error.

  DB : SQL server 2008

  OS : Win 7 (32bit)

  Thanks!

• higgim

  SSCarpal Tunnel

  Points: 4090

  More actions

  February 19, 2014 at 8:19 am

  #1690313

  Had a quick look and does the following link shed any light on your problem as a potential solution?

  http://stackoverflow.com/questions/13076761/get-ip-address-of-user-client-viewing-report-in-ssrs-2008-report-manager

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  February 21, 2014 at 4:44 am

  #1691055

  Thanks for the Link but it does not give the solution rather it is trying to address the problem but not fully.