I have a similar issue wherein SSRS is needlessly duplicating all crossjoins in the generated query, causing an exponential increase in execution time.

SELECT
  NON...