All the records should be taken to a table ? Is there a way to read each loop from ssrs report?

my sql provided is working fine in SSMS, where it is giving all the results i wanted. The results are thrown in different windows though. Need to do this in SSRS.

Thanks.