SSRS Question-->How do we capture the network user_id at the back_end

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  January 9, 2012 at 12:51 pm

  #262673

  Team:

  I am developing a SSRS report, but would also like to see who is using this report.

  I mean I like to log that info to a table each time the report gets executed.

  What i am looking for is some kind of a parameter that will have the Network user id

  that can be sent as a parameter to a stored procedure.

  ( I am not asking about querying the ReportServer.Executionlog table and getting this info )

  Thanks and look forward to your response.

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  January 9, 2012 at 8:15 pm

  #1430878

  How about adding a parameter to your sproc and in the dataset that uses that sproc, specify "=User!UserID" as its value