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]

Hello,

Just change the table name on the report to Task and you will be able to report on both as below:-

Please mark answer correct/helpful based on Impact

[RC2]

OK, testing this now. THanks for the advice!

[Saurav11]

Sure, Please mark answer correct if everything goes well

[RC2]

Sadly, doesn't work for the other metrics I need. I need to report on success state of the change (so Close Code) and I need to report on Planned Start Date and Closed Date (on or after a specific date). I can't get that to work using this Table. 

Basically, I need to know all changes that were done after XXX date, for specific teams (either task or parent change) and what the outcome was (successful, unsuccessful, etc).

[Saurav11]

Yes you can report on all fields of change task or change table with the same report. Just search for changer request(+) or change task(+) as below:-

Just click on any of them and you will ahve all the fields for that respective table.

Then you can filter through those fields:-

Please mark answer correct/helpful based on impact.