How can I show the Sales Report for particular user?
Attempt to answer the "Why does an affiliate get an empty report?" part of your question (which I believe is part of your question): could it be related to some "permission" you have not granted to an affiliate (yet)?

Here are a few links related to permissions that may be helpful:


Drupal Commerce issue nr 1303194.
What&#39;s the explanation for my product permission issue in a Drupal Commerce view? (and/or some of the "related" questions there).