title: Filter SSRS report to current user
body: <p>This seems to be a common issue, but I could find no solution which worked.</p>
  
  <p>I have an SSRS report which shows employee Vacation balances.</p>
  
  <blockquote>
    <p>I want to make a linked report which will only display information for the current user.</p>
  </blockquote>
  
  <p>The built in field <code>User!UserID</code>, returns the Login of the User, however that Login is generally not used in our DW, so I cannot filter off of it alone.
  We have a stored procedure which will convert that login to the matching <code>UserID</code>, which I can then filter the report on.</p>
  
  <blockquote>
    <p>My issue there is that although I have a secondary dataset which returns the current users <code>EmployeeID</code>, that dataset cannot be used in the filter of my primary data set, nor in any parameters.</p>
  </blockquote>
  
  <p>Because of the need to identify current user, I do not know of a way to do this within SSMS, but am stuck trying to make it work in SSRS</p>
  
  <p>To clarify the linked report idea, I was planning to have a Boolean where true/false indicated whether to display data for the current user or just return all.  The linked report was an effort to not replicate the RDL with this minor change</p>
  
  <p>Any help will be greatly appreciated, this is the sort of issue I am sure I will come across again in the future</p>