Query Designer in SSRS doesn't support multiple result set, if multiple result sets are retrieved through a single query, only the first result set is processed, and all other result sets are ignored. Please see:

http://msdn.microsoft.com/en-us/library/dd239331.aspx

For you requirement, the best workaround save the result sets into 3 separated tables. Then use three datasets to retrieve the data.