I cannot remember if the conditional works though.

If it cares that it is just a select statement, you may have to write it more like:

SELECT MyEmail, MyName

FROM MyUserList

WHERE MyReport = 'Report1'

AND EXISTS(SELECT TOP 1 * FROM MyData)

The query is less-than-efficient, but it works with the data-driven report structure.