Accessing domain user name as a report parameter RSS

• • Reply
  

  agent_smith

  Contributor

  2030 Points

  573 Posts

  Accessing domain user name as a report parameter

  Jul 25, 2005 03:19 PM|LINK

  In our legacy reports (ASP.NET/Crystal Reports) we use the logged in user account to filter the report.
  
  Basically you are restricted to seeing your 'own' data when running the report based upon your user ID.
  
  I am looking for suggestions as how to restrict report results based on something like domain user ID in Reporting Services.
  
  There are many cases (like in the sales profession) where users of the same report do not want other users to access their information.
  
  Thanks for any suggestions.   
  --[_]-[_]--
  
  AGENT_SMITH
• • Reply
  

  dragoon

  Member

  5 Points

  1 Post

  Re: Accessing domain user name as a report parameter

  Jul 27, 2005 12:10 PM|LINK

  use the global variable  User!UserID
  
  be aware that you may not create subscriptions for a report that contains user-defined parameter values.