Report on parent and child table

venishawakodika
Giga Contributor

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 ?

1 ACCEPTED SOLUTION

dave_edgar
Mega Guru

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


View solution in original post

7 REPLIES 7

Daniel50
Kilo Guru

is it possible to create a similar report with projects/-tasks? I want to filter project-tasks which have NO child-task.

Thanks for your inputs.

Daniel

Hi Daniel,

 

Surely you can. Try something as below.

find_real_file.png

Daniel50
Kilo Guru

Thank you, Jaspal! You're awesome! 

Daniel