title: Reporting Services 2008: Using user!userid in Parameters
body: <p>I have a report with a parameter that is populated by a list of sales representatives returned by a query. I want to filter that list based on security rights of the user running the report.</p>
  
  <p>In order to make the query work I need to pass the user!userID to the db.  I tried something like this:</p>
  
  <p>...where UserName = user!UserID...</p>
  
  <p>But it doesn't like the syntax.</p>