Had Same Problem I worked through with a junior developer. As usual with SSRS the desired result was not what you would normally expect to code "logically.
Using the JOIN...