I am trying to resolve a simple problem, yet am again totally stuck -
please
help!!

I have 2 datasets - one dataset should get the IP Address of the
person running the
report:

               SELECT  client_net_address as p_IP_Address
               FROM  master.sys.dm_exec_connections
               WHERE session_id = @@SPID;

I pass the p_IP_Address from this dataset as a default value for the
report parameter into
my second dataset - which merely runs a simple SP to get several rows
which are displayed on the report - this is working fine now.

The GET_IP_Address dataset does return one row with one field - but it
is returning the IP Address of the SSRS SQL Server machine - where the
RDL is run from - not the end-user IP Address.

I have tried several different tacks to get the correct IP address
into the second dataset, but to no avail.

When the report is run in Visual Studio 2005, it shows the correct IP
Address, but when I deploy it to the produciton server, and then run
it - it does not return the IP address of the person running the
report - the report is executed via URL.

Please help

    -- vpdj @ yahoo.com

TIA