Report on both HR Task and HR Case in the same report.

[JD292]

Hello, 

I am trying to create a pretty basic closed HR Task report, where I run into trouble is I also want the report to contain the name of the HR Service the HR Task is sitting on and the Assigned To of the HR Case.

In PeopleSoft, I would just join the HR Task Table and the HR Case Table. Is that the same in ServiceNow? If so, how would I go about doing this?

I have the Reporting Admin role, but not a full Admin role. If I need to have someone with a full Admin role complete the setup, I can, I just need to be able to walk them through it as well.

Thanks much!

J Dean

[Sai Anna · Accepted solution]

Hello,

The "Parent" field on HR Task is a reference field.you can dot walk any reference field and include them in reports. we can use these fields in filter conditions as well as columns in the list view.

Once you expand, you can choose the HR Case table and expand that for HR case columns.

Option 2:

you can also create database view pretty easily. please use "Parent" as a common field. for more information refer

https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/concept/c_Data...

Thanks,

Sai 

[JD292]

Thanks Sai, I was able to pull from the Parent and get what I needed. Thanks, J Dean