Reporting on Parent table

[Trailblazer11]

There is a custom field on the child table and as those child records are present in parent tables, the field which is there on child is having values in it but not showing on parent table list view.

I am working on a report and those fields are not showing up. Could you please assist the best approach to achieve this? Thanks

[Mark Manders]

If you want fields from a child table to show up on a list of the parent table, you will need to create your report on the child table and show the (dotwalked) parent fields you need and add the child fields you are missing.

If it is to only report numbers of records (number of cases of which the child.custom field = xyz), you can use the related list conditions on the report (show all records where there are one or more child records with that value on the field).

[Trailblazer11]

Hi Mark, There are 3 different classes so we don't want to have 3 different reports

Is there anyway to do it on the parent table itself?

[Ankur Bawiskar]

@Trailblazer11 

so report is on parent table and you want to bring custom field value from child table on it's list

If yes then it should be possible OOB

what did you try so far and what didn't work?

Why not have report on child table itself?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Trailblazer11]

I have made the report on [cmdb_ci_service] as below:

here, [Calculated Application Service] in class I am not able to pull the "Possessed By" field:

I want this field on the list view report on [cmdb_ci_service] table.