How do I report Approval Group and answers to Request Item questions in one report

[alexmitchell]

I have two reports currently, one querying sc_req_item, the other querying sysapprova;_group but I want to present the data all in one report.  Is this possible?

Criteria for sysapproval_group report is "Assignment group.Name starts with "stringA"" as all approval groups I am looking for have the same prefix.

Criteria for sc_req_item report is "Item.Name is Catalogue Item.

In neither report can I dotwalk to the fields I need to pull all the data into one report.

I want to see the RITM number, the Catalogue Access, Approval Group but whilst I can select the RITM number in the sysapproval_group report I can't get the Catalogue Access and similarly in the sc_req_item report I can get the Catalogue Access and the RITM but not the Approval group.

[Brad Tilton]

It sounds like you may need to join those tables with a database view: https://docs.servicenow.com/bundle/madrid-platform-administration/page/use/reporting/concept/c_Datab...

[Jaskaran Walia]

Hi alexmitchell,

Try using the related List condition on reports. Since approval records are related list on RITM, you can use them in the report to add filters and show data from RITM table. We had similar requirement where we wanted to show all the RITM approved or rejected by our security team for last 7 days running. we decided the data to show on the report is on RITM table and filter would be related list.

This handy little feature avoids the need for database view in this case. If you find this information useful, please mark this answer as helpful and correct answer.