Sometimes there's a need to add security to your SSRS report. You can limit what values your users can see by adding a new parameter and modifying your "where" clause to equal the user - that way they can only see what they have rights to:
Create a parameter called User
with a Default Value:
And in your DataSet add Parameter:
Add a WHERE Clause to your Dataset:
Should be good to go!