Query Assignment Group in tables change_request AND change_task in the same report?

[RC2]

I can't figure out how to do this in a report, but can do it in a general search?

I need to find all Change Records AND all Change Tasks to a specific Assignment Group in one report. I can figure out how to do it in two reports, but not in one. It's because the tables/data are different that hold the data. Is there a table or data source that has both? If so, what is it called? 

[RC2]

I'm not an admin so I don't have that access. I could request it, but no guarantee it would be approved or how long it would take to process the request (could be 6+ months). Is there no other way? Trying to avoid two reports that pull duplicate data. 

[Dan Menter]

Hey this is simple. Remember change and change_task both extend task. Go to the task table and build this with the group you are interested in instead of the is dynamic one of my groups.

[RC2]

Thanks. I posted above that this almost works, but then my other data I cannot get. 

Basically, I need to know all changes that were done after XXX date, for specific teams (either task or parent change - all teams under a specific manager) and what the outcome was (successful, unsuccessful, etc). Right now we do two reports to capture all tasks and all parent changes, then filter out the duplicates. 

[RC2]

OK...I think I found a way to query it but it times out. I think we just have too much data.