Reporting Services isn't so friendly to complex SQL. I usually create a database view or some kind of a temp table, so the reporting side doesn't need to move data...