Report on parent and child table

[venishawakodika]

I want to create a list report on two custom tables with a list of all fields from both tables.

The other table is a child of the 1st i.e. for example, two tables are A and B, A is parent and B is child.

I want to report on parent table only, so how do i get   the child table records in my report ?

[dave_edgar · Accepted solution]

For this run the report from the child table then dot walk to the parent table

OR

you could use Database views

Hope this helps

[Jaspal Singh]

Hi Vineetha,

You need to report on child table & then you will directly have access to all fields on Parent. Reporting on Parent table to get access to its child is not possible OOB in ServiceNow. If so, you will have to create a database view.

As per my suggestion report on Child to have access to all fields of parent.

[abhishekdash]

Hello Vineetha,

Not sure if it will be possible. Easy solution would be to run the report on child table. And as others suggested, DB view would be another option to create and report on it.

Thanks,

Abhishek

[venishawakodika]

Ok, understood, thank you all for your reply.

Regards,

Vineetha