Ha, it literally said "Reporting Services does not support CROSS APPLY".

However I have just been playing around and when just typing the query it worked every time, I have now published the report and it is still working...maybe I made the message up.