title: SSRS Split Report By User
body: <p>We use SSRS to distribute sensitive information to employees (Commissions, Pay checks etc) </p>
  
  <p>What is the best way to split the report by user without requiring a separate schedule per user? </p>
  
  <p>These are automated to send out, so no user accessing the files from the report server, they only see the email that is sent out. </p>
  
  <p>Example Below - </p>
  
  <p>Entire Report</p>
  
  <p><a href="https://i.stack.imgur.com/hrhc8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hrhc8.png" alt="EntireReport"></a></p>
  
  <p>So if Pilar is in the list of recipients that will receive this mail, he should only see the below info. </p>
  
  <p><a href="https://i.stack.imgur.com/CKZ9c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CKZ9c.png" alt="Split For User Pilar"></a></p>