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? 

[Saurav11]

Please show the screenshot?

[RC2]

Here is the "empty" filtering by close code:

But the actual field is populated:

[Saurav11]

Just to be sure you are using the same close code change request close code in group by and having the field for change request close code on list view as well

[RC2]

I had to step away from it last night and most of today because I couldn't get it to work and I was going nuts. I'm stuck here. I can get Assignment Group for Tasks to search from the Task Table, but not Assignment Group for the Parent Change Request. I don't even see the option. I tried in the New UI and the Classic UI (Screenshots are from the Classic):

I tried "Change Request +" to "Change Request fields", it's not there. Then I tried "Change Task +" to "Change Request" and not there either. In the "New UI" I can expand the "Change Request" (second screenshot), but all the results from that search are empty so it's not the correct data (as I know it's a mandatory field in the parent change). 

I feel like I've tried every option but I cannot find the location of the Parent Change request Assignment group field/table/data from the Task table. If it doesn't exist, then I cannot use the Task Table.

[Sumanth16]

Hi, 

Create database view by joining change request table and change task table. 

Thanks & Regards,

Sumanth Meda.